Database Articles
  Home arrow Database Articles arrow Page 9 - Create dynamic sites with PHP & MySQL
Codewalker Forums 
  Tutorials  
Database Articles  
Miscellaneous  
Navigation Usability  
PEAR Articles  
Programming Basics  
Server Administration  
XML Tutorials  
  Reviews  
Database Book Reviews  
Linux Book Reviews  
Miscellaneous Reviews  
PHP Book Reviews  
PHP Software Reviews  
Server Admin Reviews  
SQL Tool Reviews  
  Code Gallery  
Content Management Code  
Contest Code  
Counters Code  
Database Code  
Date Time Code  
Discussion Board Code  
Email Code  
File Manipulation Code  
GUI Code  
Link Farm Code  
Miscellaneous Code  
Search Code  
Site Navigation Code  
User Management Code  
Mobile Linux 
App Generation ROI 
IBM® developerWorks 
Download TestComplete 
Forums Sitemap 
Weekly Newsletter 
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
DATABASE ARTICLES

Create dynamic sites with PHP & MySQL
By: Codewalkers
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 25
    2002-05-19

    Table of Contents:
  • Create dynamic sites with PHP & MySQL
  • Introduction and installation
  • Installing Apache server routines
  • Installing MySQL
  • Installing PHP
  • Your first script
  • Your first database
  • Where's my view?
  • Creating an HTML form
  • Putting it together
  • Passing variables
  • Viewing individual rows
  • Deleting rows
  • Editing data
  • Searching our data
  • Tips for common tasks

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Create dynamic sites with PHP & MySQL - Creating an HTML form


    (Page 9 of 16 )

    So now you can view records stored in your MySQL database and display them in your browser using PHP. But you want to add new record. Assuming that you know about HTML forms, let's code a page that will do just that. First we'll create a static form, datain.html:

    <HTML> 
    <BODY> 
    <form method="post" action="datain.php"> 
    First name:<input type="Text" name="first"><br> 
    Last name:<input type="Text" name="last"><br> 
    Nick Name:<input type="Text" name="nickname"><br> 
    E-mail:<input type="Text" name="email"><br> 
    Salary:<input type="Text" name="salary"><br> 
    <input type="Submit" name="submit" value="Enter information"> 
    </form> 
    </HTML>

    Now we have a form that will post the information to a page "datain.php". We must code this page so that it is able to process the posted data and send it to our MySQL database. The following listing of datain.php will do that:

    <HTML> 
    <?php 
    $db = mysql_connect("localhost", "root",""); 
    mysql_select_db("learndb",$db); 
    $sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary) VALUES ('$first', '$last', '$nickname','$email','$salary')";
    $result = mysql_query($sql); 
    echo "Thank you! Information entered.\ n"; 
    ?> 
    </HTML>

    The first 3 lines are same as before, only we use the SQL command "INSERT INTO", which means insert into the database into the columns specified (here firstname, lastname, nick, email) the data contained in the variable '$first', '$last', '$nickname', '$email' respectively.

    But where did these variables come from? Well, PHP has a wonderful way of creating the variables automatically from the data posted to it. So the text box with name "first" created the variable $first and it contained the text typed in that textbox.

    Important Note: As of PHP 4.2, php no longer automatically creates the variables for you. If you want posted variables to be automatically created. You have to edit your php.ini file and set the register_globals variable to on. The line should read:

    register_globals = on

    If that is not possible, you have to initialize the variables in your code everytime. The method is, if you are posting a form with the field "name" you have to write the following code in the page where you are posting:

    <?php
    $name
    =$_POST[name];        //for post method
    $name=$_GET[name];        //for get method
    ?>

    The general format is:

    <?php
    $variablename
    =$_POST[the_field_posted_by_form];
    ?>

    So the above code will look like:

    &lt;HTML&gt;
    &lt;?php
    $db = mysql_connect("localhost", "root","");
    mysql_select_db("learndb",$db);
     
    //for new PHP
    $first=$_POST[first];
    $last=$_POST[last];
    $nickname=$_POST[nickname];
    $email=$_POST[email];
    $salary=$_POST[salary];
    //
     
    $sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary) 
    VALUES ('$first','$last','$nickname','$email','$salary')";
    $result = mysql_query($sql);
    echo "Thank you! Information entered.\n";
    ?&gt;
    &lt;/HTML&gt;

    More Database Articles Articles
    More By Codewalkers


       · Hi :-)Thank you for this great tutorial!Best regardsU.
       · Very easy to use and follow. There are a few errors with the examples but i found...
       · Well organized, super-clear tutorial.Thanks so much!
       · thanks u for this tutorial it's really user friendly and helpful!=)luvvies,cat
       · I am so glad that I found this tutorial. It has a very comfortable rate of progress...
       · This tutorial sets out to do great things. And when you fix all the code, it really...
       · Hey, you have a few spaces where there not needed, so anyone who gets the...
       · usando esse tutorial voc&ecirc; aprende muitas coisas boas sobre mysql e php...
       · 'nuff said
       · its good, but could be made more better by putting more examples
       · I am an idiot among the newbies.Many other tutorials never mention the $_POST[]...
       · Thanks!
       · Congratulations for your hard work to help people like me.This was very important...
       · This helped me get started with mySql and PHP. Thanks a lot!
       · This one of the greatest and most comprehensive tutorials i have read in a long...
       · This one of the greatest and most comprehensive tutorials i have read in a long...
       · 
       · This tutorial helped me make my site for 30 % and 35% exists from databases (= thank...
       · This very useful for me as a new comer. The way tutorial is presented is very...
       · IM KNEELING DOWN IN AWE...MASTER!!! MASTER!!!
     

    DATABASE ARTICLES ARTICLES

    - More on Query Optimization for Oracle Databa...
    - Query Optimization in Oracle
    - Clusters and Other Data Structures for Oracle
    - Using Indexes with an Oracle Database
    - The Basics of Data Structures in Oracle
    - Oracle Data Structures
    - Best Practices for PL/SQL Variables
    - What`s Code Without Variables?
    - Clauses, Sorting, and SQL Queries
    - The From Clause and SQL Queries
    - Query Primer
    - Full Text Searches and Strings
    - Searching with Strings
    - Pattern Matching with Strings
    - Working with Cases of Strings





    © 2003-2009 by Developer Shed. All rights reserved. DS Cluster 4 Hosted by Hostway
    Stay green...Green IT