Skip to content

Instantly share code, notes, and snippets.

@stevenwadejr

stevenwadejr/upstate.php

Created January 3, 2018 16:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stevenwadejr/1ee6fe6b306d427fce72182d30dcef7c to your computer and use it in GitHub Desktop.
Save stevenwadejr/1ee6fe6b306d427fce72182d30dcef7c to your computer and use it in GitHub Desktop.
Download ZIP
This is the very first PHP script I ever wrote (circa 2007)
Raw
upstate.php
<?php
$hostname = "localhost";
$db_user = "swade_steven";
$db_password = "yeahman";
$db_table = "upstate_show";
$db = mysql_connect($hostname, $db_user, $db_password);
mysql_select_db("swade_information");
?>
<html>
<head>
<title>18th Annual Upstate High School Art Exhibit</title>
</head>
<body>
<hr>
<?php
if (isset($_REQUEST['Submit']))
{
# THIS CODE TELL MYSQL TO INSERT THE DATA FROM THE FORM INTO YOUR MYSQL TABLE
$sql = "INSERT INTO $db_table(name,grade,homePhone,homeAddress,homeCity,homeState,homeZip,homeCounty,title,category,height,width,depth,media,schoolName,principal,instructor,schoolAddress,schoolCity,schoolState,schoolZip,schoolCounty,schoolPhone) values ('$name','$grade','$homePhone','$homeAddress','$homeCity','$homeState','$homeZip','$homeCounty','$title','$category','$height','$width','$depth','$media','$schoolName','$principal','$instructor','$schoolAddress','$schoolCity','$schoolState','$schoolZip','$schoolCounty','$schoolPhone')";
if($result = mysql_query($sql ,$db))
{
echo "Thank you for your entry";
}
else
{
echo "ERROR: ".mysql_error();
}
}
else
{
?>
<?php
}
?>
</body>
</html>
@stevenwadejr
Copy link
Author

stevenwadejr commented Jan 3, 2018 •
edited

Pretty much every bit of this was copy/pasted from StackOverflow. I didn’t even understand what it was doing but I knew I needed insert something into a database. ¯\(ツ)/¯

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment