1 / 27

PHP with MYSQL

PHP with MYSQL. Please use speaker notes for additional information!. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", "password") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_close($link); ?>. <?php

dacey
Download Presentation

PHP with MYSQL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PHP with MYSQL Please use speaker notes for additional information!

  2. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", "password") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_close($link); ?>

  3. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", "password", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_select_db("pgrocer_biz_data"); $result = @mysql_query("SELECT idno from donor") or die("Invalid query: " . mysql_error()); while ( $row = mysql_fetch_row($result)) { echo ("<p>" . $row[0] . "</p>"); } ?> My database as assigned by Nevidia. My table. I am now looping through the table showing one row at a time starting the index at 0.

  4. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", ”password", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_select_db("pgrocer_biz_data"); $result = @mysql_query("SELECT idno from donor") or die("Invalid query: " . mysql_error()); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { echo ("<p>ID= ". $row["idno"] ." </p>"); } ?>

  5. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", "password", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_select_db("pgrocer_biz_data"); $result = @mysql_query("SELECT idno, name from donor") or die("Invalid query: " . mysql_error()); while ($row = mysql_fetch_array($result)) { echo ("<br> ID = ". $row["idno"] . "<br> NAME = " . $row["name"] . "<br>"); } ?>

  6. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", ”password", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_select_db("pgrocer_biz_data"); $result = @mysql_query("SELECT * from donor") or die("Invalid query: " . mysql_error()); while ($row = mysql_fetch_array($result)) { echo ("<br> ID = ". $row["idno"] . "<br> NAME = " . $row["name"] . "<br>"); echo("CITY = " . $row["city"] . "<br> STATE = " . $row["state"] . "<br>"); } ?>

  7. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", ”password", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_select_db("pgrocer_biz_data"); $state="RI"; $result = @mysql_query("SELECT * from donor where state = '$state'") or die("Invalid query: " . mysql_error()); while ($row = mysql_fetch_array($result)) { echo ("<br> ID = ". $row["idno"] . "<br> NAME = " . $row["name"] . "<br>"); echo("CITY = " . $row["city"] . "<br> STATE = " . $row["state"] . "<br>"); } ?>

  8. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", ”password", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_select_db("pgrocer_biz_data"); $idno='11111'; $result = @mysql_query("SELECT * from donor where idno = '$idno'") or die("Invalid query: " . mysql_error()); $row = mysql_fetch_array($result); echo ("<br> ID = ". $row[0] . "<br> NAME = " . $row["name"] . "<br>"); echo("CITY = " . $row["city"] . "<br> STATE = " . $row["state"] . "<br>"); ?>

  9. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", "whatever", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_select_db("pgrocer_biz_data"); $sql = "INSERT INTO donor values ('33333', 'Al Richards', '111 South St', 'Braintree', 'MA', '02184','2002-10-10',300, 'John Smith')"; $result= mysql_query($sql,$link) or die(mysql_error()); echo $result; ?> Note that I did the insert as one long string that I had to wrap to show on the slide. I then ran connect7.php to show that the record got added.

  10. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", "whatever", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_select_db("pgrocer_biz_data"); $sql = "INSERT INTO donor values ('44444', 'Sarah Grove', '123 Elm St', 'Seekonk', 'MA', '02345','2001-10-12',300, 'John Smith')"; $result= mysql_query($sql,$link) or die(mysql_error()); echo $result; ?> Again I wrapped for the slide, the insert is one line in my code. Indicates successful execution. When I executed insert1a.php a second time this error message was returned.

  11. See insert on previous slide

  12. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", "whatever", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_select_db("pgrocer_biz_data"); $sql = "INSERT INTO donor values ('45654', 'John Doe', '123 Elm St', 'Swansea', 'MA', '02345', '2001-10-12',300, 'John Smith')"; if (mysql_query($sql,$link)) { echo "record added"; } else { echo "must have been a duplicate"; } ?> Again note the wrap that is not in the code. When I ran insert1b.php a second time I got my duplicate message.

  13. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", "whatever", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully "); mysql_select_db("pgrocer_biz_data"); $getidno='45654'; $sql = "DELETE FROM donor WHERE idno = '$getidno'"; if (mysql_query($sql,$link)) { echo "record deleted"; } ?>

  14. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", "whatever", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_select_db("pgrocer_biz_data"); $getidno = '33333'; $sql = "UPDATE donor SET stadr = '111 North St' WHERE idno = '$getidno'"; $result= mysql_query($sql,$link) or die(mysql_error()); echo $result; ?>

  15. The update changes the street name from South to North.

  16. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", "whatever", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_select_db("pgrocer_biz_data"); $result = @mysql_query("SELECT * from donor") or die("Invalid query: " . mysql_error()); while ($row = mysql_fetch_array($result)) { echo ("<br> ID = ". $row["idno"] . "<br> NAME = " . $row["name"] . "<br>"); echo ("STREET ADDRESS = " . $row["stadr"] . "<br>"); echo("CITY = " . $row["city"] . "<br> STATE = " . $row["state"] . "<br>"); } ?>

  17. <html> <head> <title>Insert</title> </head> <body> <form action="insert2.php" method="POST"> IDNO: <input type="text" name="inidno"> <br>NAME: <input type="text" name="inname"> <br>STREET ADDRESS: <input type="text" name="instadr"> <br>CITY: <input type="text" name="incity"> <br>STATE: <input type="text" name="instate"> <br>ZIP: <input type="text" name="inzip"> <br>DATE FIRST CONTRIBUTED: <input type="text" name="indatefst"> <br>YEAR GOAL: <input type="text" name="inyrgoal"> <br>CONTACT: <input type="text" name="incontact"> <br> <input type="submit" value="Click"> </form> </body> </html>

  18. <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", "whatever", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_select_db("pgrocer_biz_data"); $idno=$_POST[inidno]; $name=$_POST[inname]; $stadr=$_POST[instadr]; $city=$_POST[incity]; $state=$_POST[instate]; $zip=$_POST[inzip]; $datefst=$_POST[indatefst]; $yrgoal=$_POST[inyrgoal]; $contact=$_POST[incontact]; $sql = "INSERT INTO donor values ('$idno', '$name', '$stadr', '$city', '$state', '$zip', '$datefst', '$yrgoal', '$contact')"; $result= mysql_query($sql,$link) or die(mysql_error()); echo $result; ?> The code has the insert on one line. I wrapped to fit on the slide.

  19. <html> <head> <title>Insert</title> </head> <body> <form action="delete2.php" method="POST"> Enter the identification number for the record you want to delete.<br><br> IDNO: <input type="text" name="inidno"> <input type="submit" value="Click"> </form> </body> </html> <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", "whatever", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_select_db("pgrocer_biz_data"); $idno=$_POST[inidno]; $sql = "DELETE FROM donor WHERE idno = '$idno'"; $result= mysql_query($sql,$link) or die(mysql_error()); echo $result; ?>

  20. <html> <head> <title>Insert</title> </head> <body> <form action="update2.php" method="POST"> Change the name for the following id.<br><br> IDNO: <input type="text" name="inidno"> <br>NAME: <input type="text" name="inname"> <br> <input type="submit" value="Click"> </form> </body> </html> <?php $link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", "whatever", "pgrocer_biz_data") or die("Could not connect: " . mysql_error()); print ("Connected successfully"); mysql_select_db("pgrocer_biz_data"); $idno=$_POST[inidno]; $name=$_POST[inname]; $sql = "UPDATE donor SET name = '$name' WHERE idno = '$idno'"; $result= mysql_query($sql,$link) or die(mysql_error()); echo $result; ?>

More Related