Solved

how to insert date from my registration page into sql database

Posted on 2009-05-19
4
281 Views
Last Modified: 2012-05-07
i have registration form and i would like to insert system date into mysql database.

please help!!!
my database looks like this :---
 
 

<?php
 

$con = mysql_connect("localhost","root","");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

// Create database

if (mysql_query("CREATE DATABASE reg",$con))

  {

  echo "Database created";

  }

else

  {

  echo "Error creating database: " . mysql_error();

  }

// Create table

mysql_select_db("reg", $con);

$sql = "CREATE TABLE details

(
 

 

   ID INT NOT NULL AUTO_INCREMENT,

   email VARCHAR(35) NOT NULL,

   name VARCHAR(35) NOT NULL,

   department VARCHAR(35) NOT NULL,

   phone VARCHAR(35) NOT NULL,

   altphone VARCHAR(35) NOT NULL,

   vista VARCHAR(35) NOT NULL,

  wimba VARCHAR(35) NOT NULL,

   date1 datetime default NULL,   

   PRIMARY KEY (ID)
 

   

   
 
 
 
 
 

)";

// Execute query

mysql_query($sql,$con);

mysql_close($con);
 

?>
 
 
 

form code :--
 
 

<form name="registration" method="post" action="registration.php5">  

      <table align="center" class="style1">

          <tr>

              <td class="style2">

                  Email</td>

              <td class="style2">

                  :</td>

              <td>

                  <input id="Text1" type="text" name="email" /></td>

          </tr>

          <tr>

              <td class="style2">

                  Name</td>

              <td class="style2">

                  :</td>

              <td>

                  <input id="Text2" type="text" name="name" /></td>

          </tr>

          <tr>

              <td class="style2">

                  Department</td>

              <td class="style2">

                  :</td>

              <td>

                  <input id="Text3" type="text" name="department" /></td>

          </tr>

          <tr>

              <td class="style2">

                  Office Phone</td>

              <td class="style2">

                  :</td>

              <td>

                  <input id="Text4" type="text" name="phone"/></td>

          </tr>

          <tr>

              <td class="style2">

                  Alternate Phone</td>

              <td class="style2">

                  :</td>

              <td>

                  <input id="Text5" type="text" name="altphone"/></td>

          </tr>

          <tr>

              <td class="style2">

                  &nbsp;</td>

              <td class="style2">

                  &nbsp;</td>

              <td>

                  &nbsp;</td>

          </tr>

          <tr>

              <td class="style2">

                  &nbsp;</td>

              <td class="style2">

                  &nbsp;</td>

              <td>

                  <input id="submit" type="submit" value="Submit" /></td>

          </tr>

          

      </table>
 
 

php code :--
 

<?PHP
 

//Database Information
 

$dbhost = "localhost";

$dbname = "reg";

$dbuser = "root";

$dbpass = "";
 

//Connect to database
 

mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());

mysql_select_db($dbname) or die(mysql_error());

                     

    

$email = $_POST['email'];

$name = $_POST['name'];    

$department = $_POST['department'];

$phone = $_POST['phone'];

$altphone = $_POST['altphone'];

$vista= $_POST['vista'] ;

$wimba= $_POST['wimba'] ; 
 

   $date1= $_POST['date'];                   
 

          

              

   
 
 

$query = "INSERT INTO details (email,name,department,phone,altphone,vista,wimba,date)

VALUES('$email','$name','$department','$phone','$altphone','$vista','$wimba','$DATE: Auto CURDATE()', CURDATE())";
 

                       
 
 

mysql_query($query) or die(mysql_error());

mysql_close();

          header("location:login_success.php5"); 

//echo "You have successfully Registered";

?>

   
 
 

there is error .....
 

i need to populate database columns ,along with date .

Open in new window

0
Comment
Question by:siddharthkool
  • 2
4 Comments
 
LVL 27

Expert Comment

by:yodercm
ID: 24424460
$query = "INSERT INTO details (email,name,department,phone,altphone,vista,wimba,date)
VALUES('$email','$name','$department','$phone','$altphone','$vista','$wimba',NOW() )";
 
0
 

Author Comment

by:siddharthkool
ID: 24424928
thanks a lot !!!!!
0
 
LVL 108

Accepted Solution

by:
Ray Paseur earned 500 total points
ID: 24425007
Beware of using the column name, "date" since "date" is a reserved word in MySQL.  Try something different, or remember to put the reserved word in backticks on every use.
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 25399256
@siddharthkool:Thanks for the points, but you might want to share the points on this Q with yodercm.  The SQL expression NOW() is an integral part of the answer.  You can use the "request attention" button and ask a moderator how to change a grade.  Best regards, ~Ray
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Batch, VBS, and scripts in general are incredibly useful for repetitive tasks.  Some tasks can take a while to complete and it can be annoying to check back only to discover that your script finished 5 minutes ago.  Some scripts may complete nearly …
Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
Learn the basics of modules and packages in Python. Every Python file is a module, ending in the suffix: .py: Modules are a collection of functions and variables.: Packages are a collection of modules.: Module functions and variables are accessed us…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now