I have removed some errors and also added a "delete" function.
It's great for beginners to learn about PHPs function()
// First create a DB with phpmyadmin's SQL tab or similar:
CREATE DATABASE `my_db`
// then create a table:
CREATE TABLE `contacts` (
`id` int(10) NOT NULL auto_increment,
`first_name` varchar(30) NOT NULL default '',
`last_name` varchar(50) NOT NULL default '',
`email` varchar(75) default NULL,
`contact_status` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM
// paste this into a *.php file:
<html>
<head>
<title>Manage contact's data</title>
</head>
<body>
<?php
/*************************************************************************
control code for application
*************************************************************************/
//submit button was pressed so call the process form function
if (isset($_POST['submit']))
{
process_form();
die();
}//end if
if (isset($_POST['submit_delete']))
{
delete_form();
die();
}//end if
//call the get_data function
if (isset($_GET['id']))
{
get_data();
}//endif
//nothing chosen so list the kids
if ((empty($_POST))&&(empty($_GET)))
{
list_users();
die();
}//end if
//request to add a new contact so call the show_form function
if ((isset($_GET['action']))&&($_GET['action']=='add'))
{
show_form();
}//endif
/*************************************************************************
get the data for an individual contact
*************************************************************************/
function get_data()
{
//validate the id has been passed at that it is a number
if ((empty($_GET['id']))||(is_nan($_GET['id'])))
{
//there was a problem so list the users again
list_users();
//kill the script
die();
}else{
//all is ok and assign the data to a local variable
$id = $_GET['id'];
}//end if
$sql = "select * from contacts where id = $id";
$result = conn($sql);
if (mysql_num_rows($result)==1){
//call the form and pass it the handle to the resultset
show_form($result);
}else{
$msg = "No data found for selected contact";
confirm($msg);
//call the list users function
list_users();
}//end if
}//end function
/*************************************************************************
show the input / edit form
*************************************************************************/
function show_form($handle='',$data='')
{
//$handle is the link to the resultset, the ='' means that the handle can be empty / null so if nothing is picked it won't blow up
//set default values
$first_name = '';
$last_name = '';
$email = '';
$status = '';
$id = '';
$value = 'Add'; //submit button value
$action = 'add'; //default form action is to add a new kid to db
//set the action based on what the user wants to do
if ($handle)
{
//set form values for button and action
$action = "edit";
$value = "Update";
//get the values from the db resultset
$row = mysql_fetch_array($handle);
$first_name = $row['first_name'];
$last_name = $row['last_name'];
$email = $row['email'];
$status = $row['contact_status'];
$id = $row['id'];
<a href ="<?php echo $_SERVER['PHP_SELF']; ?>">Back to all entries</a>
</body>
<?php
}//end function
/*************************************************************************
list all the contacts in the db
*************************************************************************/
function list_users()
{
$y = 0; //counter for background color
$sql = "select * from contacts "; //may want to add the option where clause to only take kids with an active status
$result = conn($sql);
echo "<table width='400' align='center' cellpadding='0' cellspacing='0'>
<tr><td colspan='2' align='center' style='font-size:18px; font-weight:bold;'>Manage Contacts Data Form</td></tr>
<tr><td colspan='2'> </td></tr>
<tr><td colspan='2'><a href='".$_SERVER['PHP_SELF']."?action=add'>Add a new contact</a></td></tr>
<tr><td colspan='2'> </td></tr>";
if (mysql_num_rows($result)){
//show a list of kids with name as a link to the prepopulated form with their data in it
while($rows = mysql_fetch_array($result)){
//build strings to make life easier
$name = $rows['first_name'].' '.$rows['last_name'];
$status = $rows['contact_status'];
$id = $rows['id'];
//convert status to readable string from 1 or 0
($status == 0) ? $status = "Available to contact" : $status = "Do not contact at present.";
//echo out the row
echo "<tr style='background-color:$bgcolor;'><td><a href='".$_SERVER['PHP_SELF']."?id=$id'>$name</a></td><td>$status</td><tr>";
$y++; //increment the counter
}//end while
echo "</table>";
}else{
//handle no results
echo "<tr><td colspan='2' align='center'><b>No data found.</b></td></tr>";
}//endif
}
/*************************************************************************
add / update the contact's data
*************************************************************************/
function process_form()
{
$fname = '';
$lname = '';
$email = '';
$id = '';
$action = '';
$status = 0; //default value
//if no status is set, defaults to 0 (allow contact)
if ($status == ''){$status = 0; }
if (($fname=='')||($lname=='')||(!preg_match("/@/", $email)))
{
$msg = "Some data from the form was forgotten. Please fill in the entire form.";
confirm($msg);
$data = "$fname|$lname|$email|$id";
show_form('',$data);
die();
}//end if
// I added a simple validation that wants to see a @ in the email address:
if ($action == "add")
{
$sql = "insert into contacts (first_name, last_name, email, contact_status) values('$fname','$lname','$email',$status)";
$msg = "Record successfully added";
}elseif($action=="edit"){
$sql = "update contacts set first_name = '$fname', last_name = '$lname', email = '$email', contact_status = '$status' where id = $id";
$msg = "Record successfully updated";
}
$result = conn($sql);
if (mysql_errno()==0)
{
confirm($msg);
list_users();
}else{
$msg = "There was a problem adding the user to the database. Error is:".mysql_error();
confirm($msg);
}//end if
}
/*************************************************************************
delete e contact
*************************************************************************/
function delete_form()
{
$action = @$_GET['action'];
$id = @$_POST['id'];
if ($action == "delete")
$sql = "DELETE FROM contacts WHERE id = '$id' ";
$msg = "Record successfully deleted";
$result = conn($sql);
if (mysql_errno()==0)
{
confirm($msg);
list_users();
}else{
$msg = "There was a problem deleting the user to the database. Error is:".mysql_error();
confirm($msg);
}//end if
}
/*************************************************************************
db connection function
*************************************************************************/
function conn($sql)
{
/*
If you use include("/connect.php") delete everyting else within these function bracket
and change $result = conn($sql); to $result = mysql_query($sql) or die;
*/
$host = "localhost"; // may need to change according your settings
$user = "root"; // may need to change according your settings
$pass = "root"; // may need to change according your settings
$db = "my_db";
//echo "commnecing connection to local db<br>";
if (!($conn=mysql_connect($host, $user, $pass))) {
printf("error connecting to DB by user = $user and pwd=$pass");
exit;
}
$db3=mysql_select_db($db,$conn) or die("Unable to connect to local database");
$result = mysql_query($sql) or die ("Can't run query because ". mysql_error());
return $result;
}//end function
/*************************************************************************
alert box popup confimation message function
*************************************************************************/
function confirm($msg)
{
echo "<script langauge=\"javascript\">alert(\"".$msg."\");</script>";
}//end function
bastien koert wrote :1897
Thanks for the choice. Nice work on the additional features
Ian Cox wrote :1910
Great code, works well, the additions are helpful.
Few questions
1. Can I have user upload a photo or a few photos via this form? - with MySql saving file name & posting image to file (not storing image in MySql) - if so please advise code addition.
2. How can code be adjusted to allow user input over multiple pages?
Have tried for days to add photo upload functionality, I am suffering a lack of expertise!
