note 113538 added to function.mysql-query
| From: | deepakshahji at ymail dot com | Date: | Sun, 27 Oct 2013 12:40:03 +0000 |
| Subject: | note 113538 added to function.mysql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-197331@lists.php.net to get a copy of this message | ||
can any help me to connect mysql php with following code
<?php
$empname=$_POST['$name'];
$empid=10;
$ebp=2500;
$ta=12*$ebp;
echo $empname;
echo $empid;
$query ="INSERT INTO emp"(ID,NAME,BP,TA) "VALUES"
('$empid','$empname','$ebp','$ta')
$inserts=mysql_query($query);
if(!$inserts)
{
$message = 'INVALId query:' .mysql_error()."\n";
$message .= 'whole query' .$query;
die($message);
}
while($row = mysql_fetch_assoc($inserts))
{
echo $row["empname"];
echo $row["empid"];
echo $row["ebp"];
echo $row["ta"];
}
?>
<?php
include("header.php");
?>
----
Server IP: 72.52.91.14
Probable Submitter: 72.52.91.14
----
Manual Page -- http://php.net/manual/en/function.mysql-query.php
Edit -- https://master.php.net/note/edit/113538
Del: integrated -- https://master.php.net/note/delete/113538/integrated
Del: useless -- https://master.php.net/note/delete/113538/useless
Del: bad code -- https://master.php.net/note/delete/113538/bad+code
Del: spam -- https://master.php.net/note/delete/113538/spam
Del: non-english -- https://master.php.net/note/delete/113538/non-english
Del: in docs -- https://master.php.net/note/delete/113538/in+docs
Del: other reasons-- https://master.php.net/note/delete/113538
Reject -- https://master.php.net/note/reject/113538
Search -- https://master.php.net/manage/user-notes.php