View more random threads:
- php&mysql urdu turtorial for Urdu speaking distance...
- All php scripts for 2011 online
- waht is mean by lenght of strings" what is its use in...
- send sms from mysql query php??
- Students should share php and mysql knowledge with each...
- php lectures in urdu of Virtual University of Pakistan 2012
- what is the latest updates PHP May 2011
- php basic tags to start with
- Variables in function names in php 2011
- what is factorial language?
Code:$rollbackStatus=False; $link = mysql_connect(dbHost, dbUser, dbPassword); if(!$link) { die('Failed to connect to server: ' . mysql_error()); } //Select database $db = mysql_select_db(dbDatabase); if(!$db) { die("Unable to select database"); } mysqli_autocommit($link, FALSE); $selectQuery1 ="Select clientName From tblClient Where clientName='".$clientName."'"; $result1 = mysql_query($selectQuery1); if ($result1 !== TRUE) { mysqli_rollback($link); $rollbackStatus=True; } $row1 = mysql_fetch_array($result1, MYSQL_ASSOC); $n1 = mysql_num_rows($result1); if($n1>0) { $status="<span class=\"statusFailed\">: Client ".$clientName." Alread Exist.</span>"; } else { $insertQuery1 = "Insert Into tblClient Set ". "clientName='".$clientName."', ". "clientContactPerson='".$clientContactPerson."',". "clientAddress='".$clientAddress."',". "clientContactNumber='".$clientContactNumber."',". "clientStatus='a'"; $result2 = mysql_query($insertQuery1,$link); if ($result2 !== TRUE) { $status="<span class=\"statusFailed\">: Error adding adding Client:" . mysql_error() . "</span>"; mysqli_rollback($link); $rollbackStatus=True; } else { $status="<span class=\"statusOk\">: Client ".$clientName." Added Succesfully.</span>"; } } if($rollbackStatus=="False") { mysqli_commit($link); } mysqli_close($link); }
Sponsored Links
There are currently 1 users browsing this thread. (0 members and 1 guests)