cd_catalog.xml html.html htmlpage.html out.html help.txt mysqlinit.txt signature.txt action.php action1.php actioni.php catalog.php catalog.save.php emailphp.php emailphptest.php emailphptext.php form.php form1.php formphp.php formphp1.php formphpi.php getcd.php getenv.php getenv1.php henrylogin.php mysqlcreate.php mysqlcreate1.php mysqlcreate2.php mysqlcreate3.php mysqlcreate4.php mysqlcreatei.php mysqlcreatetable.php mysqldel.php mysqldel1.php mysqldelete.php mysqldelete1.php mysqldeletei.php mysqldeli.php mysqldriver.php mysqldriver1.php mysqldriveri.php mysqldriversave.php mysqlinsert.php mysqlinsert1.php mysqlinserti.php mysqlitable.php mysqltable.php mysqltable1.php mysqltablei.php oopinsert.php out.php outout.php processscript.php processscript1.php sakila.php shuffle.php shufflesave.php tempstyle.php test1.php test2.php testfile.php testfname.php testpost.php testreceive.php testx.php testy.php style.css Number of files = 66 online compaq devendra athlon kingston kingston2 kingston3 kingston4 pi pi2 pi3 Page created on February 11th 2014 and updated on November 30th. 2017. Visitor number home launcher guestbook |
1. <HTML><HEAD><TITLE>Insert 3 records into the database</TITLE>
2. <link rel="stylesheet" type="text/css" href="style.css"> 3. </HEAD> 4. <BODY><FONT FACE=ARIAL> 5. <H2>Insert 3 records into the database</H2> 6. <?php 7. $dbh=mysql_connect("localhost","onwardov_henry","Xbloodychristmas7") 8. or die('Cannot connect to the database because: ' . mysql_error()); 9. mysql_select_db ("onwardov_testdb2", $dbh); 10. //$h = strftime("%H") ; 11. $m = strftime("%M"); 12. $s = strftime("%S"); 13. $h = 1 + abs( $m - $s); 14. mysql_query("INSERT INTO Persons (FirstName, LastName, Age) 15. VALUES ('Mary', 'Jones', $h )"); 16. mysql_query("INSERT INTO Persons (FirstName, LastName, Age) 17. VALUES ('Cecil', 'Henry', $m)"); 18. mysql_query("INSERT INTO Persons (FirstName, LastName, Age) 19. VALUES ('Sara', 'Mansions', $s)"); 20. mysql_close($dbh); 21. ?> 22. <BR>3 records inserted into the database. 23. <BR><BR><BR><FORM ACTION="mysqltable1.php" method="get"> 24. <INPUT class="btn-secondary" type="submit" name ="mysqltable1" value="mysqltable1"> 25. </FORM> 26. <BR><BR><FONT SIZE=1> Page created on June 5th. 2010 and updated on December 16th. 2017.<BR> 27. </BODY></HTML> 28. |