Att: saeed ahmed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Try this:

mysql> CREATE DATABASE addressbook;
Query OK, 1 row affected (0.00 sec)

mysql> USE addressbook;
Database changed

mysql> CREATE TABLE userData(id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 firstName VARCHAR(50) NOT NULL,
 lastName VARCHAR(50) NOT NULL,
 telephone INT(12) NOT NULL,
 email VARCHAR(100) NOT NULL);
Query OK, 0 rows affected (0.11 sec)

Now when you have the databse created and a table to store data, you
need to write a PHP page that do the trick.
Here is a simpe sample. Read all comments and look at the source code...

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
	"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en">
<head>
	<meta http-equiv="content-type" content="application/xhtml+xml;
charset=utf-8" />
	<title>Addressbook</title>
	<meta name="generator" content="BBEdit 10.1" />
</head>
<body>
<?php
if(!isset($_POST['updateDB'])){
?>

<form action="addressbook.php" method="post">
<fieldset>
   <legend>Contact info:</legend>
   <p>
   <label for="firstName">First Name:</label><br />
   <input type="text" id="firstName" name="firstName" />
   </p>
   <p>
   <label for="lastName">Last Name:</label><br />
   <input type="text" id="lastName" name="lastName" />
   </p>
   <p>
   <label for="telephone">Telephone:</label><br />
   <input type="text" id="telephone" name="telephone" />
   </p>
   <p>
   <label for="emailAddress">Email Address:</label><br />
   <input type="text" id="emailAddress" name="emailAddress" />
   </p>
   <p>
   <input type="submit" name="updateDB" value="Update DB" />
   </p>
</fieldset>

</form>

<?php
} else {
	// Formfields
	$firstName = $_POST['firstName'];
	$lastName = $_POST['lastName'];
	$telephone = $_POST['telephone'];
	$email = $_POST['emailAddress'];
	
	// Delete all kind of tags that may be found in form fields
	$firstName = strip_tags($firstName);
	$lastName = strip_tags($lastName);
	$telephone = strip_tags($telephone);
	$email = strip_tags($email);
	
	// Just a simple way to a little more secure query
	$firstName = mysql_real_escape_string($firstName);
	$lastName = mysql_real_escape_string($lastName);
	$telephone = mysql_real_escape_string($telephone);
	$email = mysql_real_escape_string($email);

	// Connect to the Database
	$connectDB = mysql_connect("localhost","root","br0ok2meg") or
die(mysql_error());
	// Select Database
	$selectDB = mysql_select_db("addressbook") or die(mysql_error());
	
	// Now create the query that insert data into table userData
	$sql = "INSERT INTO
userData(firstName,lastName,telephone,email)VALUES(\"$firstName\",\"$lastName\",\"$telephone\",\"$email\")";
	
	// Run the query that actually insert data into the table userData
	mysql_query($sql,$connectDB) or die(mysql_error());
	echo "<p>The Contact information is registred</p>";
	}
?>

<p><a href="addressbook.php?view">View Contact Info</a></p>

<?php
if(isset($_GET['view'])){
	// Connect to the Database
	$connectDB = mysql_connect("localhost","root","br0ok2meg") or
die(mysql_error());
	// Select Database
	$selectDB = mysql_select_db("addressbook") or die(mysql_error());
	
	// Ask for information in table userData
	$sql = "SELECT * FROM userData";
	$result = mysql_query($sql,$connectDB) or die(mysql_error());

	// Handle received data
	while($row = mysql_fetch_array($result)){
		$firstName = $row['firstName'];
		$lastName = $row['lastName'];
		$telephone = $row['telephone'];
		$email = $row['email'];
	
	
	// Print the result to screen
	echo "<p><strong>First Name:</strong> $firstName<br />";
	echo "<strong>Last Name:</strong> $lastName<br />";
	echo "<strong>Telephone:</strong> $telephone<br />";
	echo "<strong>Email:</strong> $email<br />";
	echo "</p>";
	}
}

?>
</body>
</html>

Hope this can be in help for you.

Karl
-- 
Hjemmeside: http://www.karl-arne.name/



Den 08:45 31. mars 2012 skrev saeed ahmed <mycomputerbooks@xxxxxxxxx> følgende:
> i have made a php script with a tutorial help....i dont know where is a
> error.please have a look
>
>
> <?php
> //connect and select a database
> mysql_connect("localhost","root"," " );
> mysql_select_db("addressbook");
> //Run a query
> $result=mysql_query("select("SELECT*FROM COLLEAGUE");
> ?>
> <!DOCTYPE html PUBLIC"-//w3c//DTD XHTML 1.0 Transitional//EN"
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
> <html xmlns="http://www.w3.org/1999/xhtml";>
> <head>
> <title>Address Book</title>
> <meta http-equiv="content-type" content="text/html;charset=utf-8"
> </head>
> <body>
> <h1>Address Book<h1>
> <table Border="1" cellpadding="2"cellspacing="3"
> summary="table holda colleague contacts information">
> <tr>
> <th> ID</th>
> <th>First Name</th>
> <th>Last Name</th>
> <th>Telephone</th>
> <th>Email Address</th>
> </tr>
> <?php
> //LOOP through all table rows
> while ($row=mysql_fetch_array($result)) {
> echo"<tr>";
> echo"<td>".$row['id'] . "</td>;
> echo "<td>" . $row['firstName'] . "</td>";
> echo "<td>" . $row['lastName'] . "</td>";
> echo "<td>" . $row['telephone'] . "</td>";
> echo "<td>" . Srow['email'] . "</td";
> echo"</tr>";
> }
> //free result memory and close database connection
> mysql_free_result($result);
> mysql_close();
> ?>
> </table>
> </body>
> </html>
> thanks

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux