MySQL Database Php

  1. Home
  2. Php
  3. MySQL Database
  4. Update data record and get the affected rows

  
    $host="mysql153.secureserver.net";
  $uname="rntsoft";
  $pass="password";
  $database="rntsoft";
  $tablename="Employee";
  
  $connection= mysql_connect($host,$uname,$pass)  or die("Database connection failed!
");
  $result=mysql_select_db($database) or die("Database could not be selected");
  $query = "UPDATE Employee SET Firstname=\"new Name\" where id=2";
  $result = mysql_query($query);
  if (!$result) {
     die(" Query could not be executed.
");
  } else {
  echo " ";
  echo " ";
  echo "   ";
  echo "     
".mysql_affected_rows()." record updated successfully
";
  echo "   ";
  echo "  ";
  echo "  ";
  echo "    ";
  echo "   ";
  echo " ";
  echo " ";
  echo "   ";
  echo "    ";
  echo "  ";
  echo "  ";
  echo "    ";
  echo "    ";
  echo "  ";
  echo "
";
  echo "       Name";
  echo "   		".$name. "
";
  echo "     E-mail";
  echo "    		".$email. "
";
  echo "       CustomerID";
  echo "    		".$customerid. "
";
  }
  ?>