PHP SQL Variable

PHP SQL Variable are denoted with a leading dollar sign ($). The PHP variable includes $ con , $ update and so on.

PHP SQL Variable

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: