06-23-2011, 09:45 PM
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);
}0300-9520262
Get solution in 24 hour |cpmputer & internet
mileys81:[SIZE="4"][SIZE="3"]....[/SIZE][/SIZE]