Home Sql Mysql-example PHP SQL Variable
Questions:Ask|Latest

 
 

Share on Google+Share on Google+

PHP SQL Variable

Advertisement
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 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:

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: February 4, 2009

Related Tutorials

Ask Questions?    Discuss: PHP SQL Variable  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com