银行转账php参考whatyourinput:";echo"thepayercardnumber:$payer";echo"
";echo"thepayeecardnumber:$payee";echo"
";echo"theprice:$price";echo"
";$server="localhost";$user="root";$pwd="";$schema="comp7370";//thedatabasename//connectdatabase$db=newmysqli($server,$user,$pwd,$schema);if(mysqli_connect_errno()){printf("Connectionfailed:%s
",mysqli_connect_error());exit();}$db->autocommit(TRUE);$query="SELECT*frombankcardWHERECardNumber=$payer";$result=$db->query($query);$row=$result->fetch_assoc();//print_r($row);$Balance=$row["Balance"];echo"Payer'sBalace:".$Balance."
";if($Balance<$price)echo"Nosufficientbalance!";else{$query="UPDATEBankCardSETBalance=Balance-$priceWHERECardNumber=$payer;";$db->query($query);$query="UPDATEBankCardSETBalance=Balance+$priceWHERECardNumber=$payee;";$db->query($query); $query="select*frombankcard;";$result=$db->query($query);//2. Getnumberofrecords,numberoffields,andfieldnamelist$r=$result->num_rows;$c=$result->field_count;$fields=$result->fetch_fields();//3. PrinttableheaderinHTMLformatecho'
';//for($j=0;$j<$c;$j++)printf("| %s | %s | %s | %s | ",$fields[0]->name,$fields[1]->name,$fields[3]->name,$fields[5]->name);echo"
";//4. Printvaluesfor($i=0;$i<$r;$i++){$arr=$result->fetch_row();echo"";//for($j=0;$j<$c;$j++)printf("| %s | %s | %s | %s | ",$arr[0],$arr[1],$arr[3],$arr[5]);echo"
";}echo"";//5. Releaseresultset$result->free();}}?>
