You can see the output at www.pgrocer.biz

connect1.php

<?php

$link = mysql_connect("mysql2.nevidia.com", "pgrocer.biz", "password")

or die("Could not connect: " . mysql_error());

print ("Connected successfully");

mysql_close($link);

?>

connect3.php

<?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());

?>

connect4.php

<?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>");

}

?>

connect5.php

<?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>");

}

?>

connect6.php

<?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>");

}

?>

connect7.php

<?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>");

}

?>

connect7a.html

<?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 ("STREET ADDRESS = " . $row["stadr"] . "<br>");

echo("CITY = " . $row["city"] . "<br> STATE = " . $row["state"] . "<br>");

}

?>

connect8.html

<?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>");

}

?>

connect9.php

<?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>");

?>

delete1.php

<?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");

$getidno='45654';

$sql = "DELETE FROM donor WHERE idno = '$getidno'";

if (mysql_query($sql,$link))

{

echo "record deleted";

}

?>

delete2.html

<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>

delete2.php

<?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=$_POST[inidno];

$sql = "DELETE FROM donor WHERE idno = '$idno'";

$result= mysql_query($sql,$link) or die(mysql_error());

echo $result;

?>

insert1.php

<?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");

$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;

?>

insert1a.php

<?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");

$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;

?>

insert1b.php

<?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");

$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";

}

?>

insert2.html

<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>

insert2.php

<?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=$_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;

?>

update1.php

<?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");

$getidno = '33333';

$sql = "UPDATE donor SET stadr = '111 North St' WHERE idno = '$getidno'";

$result= mysql_query($sql,$link) or die(mysql_error());

echo $result;

?>

update2.html

<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>

update2.php

<?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=$_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;

?>