Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $conn = mysql_connect("localhost:8889", "root", "root");
- if (!$conn)
- {
- die('Could not connect: '. mysql_error());
- }
- mysql_select_db("openmrs_simulated", $conn);
- //person
- $sql = "INSERT INTO person VALUES (NULL,'".$sex[$m]."','".$dateOfBirth[$m]."',0,0,NULL,NULL,1,'2012-09-28 00:00:00',NULL,NULL,0,NULL,NULL,NULL,uuid())";
- if (!mysql_query($sql,$conn))
- {
- die('Error: Person ' . mysql_error());
- }
- echo "person <br/>";
- //person_name
- $lastInsert = mysql_insert_id();
- $sql = "INSERT INTO person_name VALUES(NULL,1,".$lastInsert.",NULL,'".$fName[$m]."',NULL,NULL,'".$lName[$m]."',NULL,NULL,NULL,1,'2012-09-28 00:00:00',0,NULL,NULL,NULL,NULL,NULL,uuid())";
- if (!mysql_query($sql,$conn))
- {
- die('Error: Person Name ' . mysql_error());
- }
- echo "person_name <br/>";
- //patient
- $sql = "INSERT INTO patient VALUES(".$lastInsert.",NULL,1,'2012-09-28 00:00:00', NULL, NULL,0,NULL,NULL,NULL)";
- if (!mysql_query($sql,$conn))
- {
- die('Error: Patient ' . mysql_error());
- }
- echo "patient <br/>";
Advertisement
Add Comment
Please, Sign In to add comment