MYSQL USEFUL TIPS

How to Know How many row update in mysql.

Ans:- Mysql_affected_rows();

Insert created current id in to another table in Mysql.

Ans: - mysql_insert_id()

How to change date formate

Ans:- $currentDateFrom=date('Y-m-d',strtotime($currentDate)-24*60*60);

How to fetch data in random from database?

Ans:-

$query="SELECT * FROM product ORDER BY RAND( )LIMIT 0 , 5 ";

$result=mysql_query($query);

=========

conn.php

==========

$db=mysql_connect('localhost','root','');

mysql_select_db('userinfo',$db);

?>

======================

   HOW TO INSERT 

======================

include('conn.php');

if(isset($_POST['submit']))

{

/* if($_FILES['image']['name'])

                {

                $pname='images/'.$_FILES['image']['name'];

                                $source=$_FILES['image']['tmp_name'];

                                copy($source,$pname);

                } */

                if($_FILES['image']['name'])

                                {

                                $target='images/'.$_FILES['image']['name'];

                                $source=$_FILES['image']['tmp_name'];

                                copy($source,$target);

                                }

$query="insert into name of table set Name='".$_POST['name']."',Title='".$_POST['title']."',Descripation='".$_POST['description']."',image='$pname'";

mysql_query($query) or die(mysql_error());

} ?>

=================

    FORM METHOD

=================

 form close always end of body

                =================

FETCH

                =================

$query="select * from name of table";

$result=mysql_query($query) or die(mysql_error());

while($row=mysql_fetch_object($result))

                                                {

                                                ?>

          

                                   ID; ?>

                                   Name; ?>

                                Title; ?>

           

            Descripation; ?>

                                                EditDelete

                                 

                                               

                                                }

                                                ?>

                =========================

                          SPECIAL CONDITION

                =========================

$i=1;

while($row=mysql_fetch_object($result))

{

?>

$querya="select * from catagory where id='$row->Catagory'";

$resulta=mysql_query($querya) or die (mysql_error());

$rowa=mysql_fetch_object($resulta);

?>

name; ?>

$queryc="select * from subcatagory where id='$row->Subcatagory'";

$resultc=mysql_query($queryc) or die (mysql_error());

$rowc=mysql_fetch_object($resultc);

?>

name; ?>

name; ?>

price; ?>

sku; ?>

description; ?>

date; ?>

EDIT | DELETE

$i++;

}

?>