PHP SQL Variable
PHP SQL Variable are denoted with a leading dollar sign ($). The PHP
variable includes $ con , $ update and so on.
Understand with Example
This example illustrates how to create the variable in php for sql operation.
In this example we create a variable $con for mysql connection and $update. The sign ($) is used to create the variable in
php. The code begin with <? php delimiter and end with ?>. The variable $
con is used to assigned the value of mysql_connect ( ) function that accept the
parameter local host, user and password. The if loop authenticate the connection
between PHP and database. The die script will be executed only if the variable
con fail to establish a connection between PHP and database. The variable $
update is used to modify the table emp_table and set the new records for the
existing value.
Table: emp_table before insertion
Table: emp_table after insertion
Source Code of sql_variable.php
<?php
// variable con created..
$con = mysql_connect("localhost","root","root");
if (!$con){
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
// variable update created..
$update = "UPDATE emp_table SET emp_name = 'sandeep' WHERE emp_id = 1";
mysql_query($update, $con);
echo "Column <b>emp_name</b> updated successfully<br><br>";
mysql_close($con);
?>
|
Download Source Code
Output:
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
