connect_errno) { die("
Failed to connect to Mysql:".$db_obj->connect_error); } else { print "connection successful
\n"; } $fname = array("Fan","Jim","Kate"); $lname = array("Zhang","Green","Lee"); $address = array("Pittsburgh","Pittsburgh","New York"); $sex = array(1,1,0); $count = count($fname); for($i = 0;$i<$count;$i++) { $query = "INSERT INTO Person (firstname,lastname,address,sex) VALUES (\"$fname[$i]\",\"$lname[$i]\",\"$address[$i]\",$sex[$i])"; $db_obj->query($query); } ?>