How to insert these values to database in php

Hi everybody,
I already post a thread like this but that was in mysql.
Here i have a problem with all the code,,

Expand|Select|Wrap|Line Numbers

 
<?php // signup.php
 
include("common.php");

include("db.php");
 
if (!isset($_POST['submitok'])):

    // Display the user signup form

    ?>

<!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> Access Code Generator Form </title>

  <meta http-equiv="Content-Type"

    content="text/html; charset=iso-8859-1

</head><link href="style.css" rel="stylesheet" type="text/css">

<body bgcolor="slate"><center>
 
<h3> <font color="#FFFFFF" face="verdana"><u>Registration Form For New Users</u><p>Please Fill The Form Below Carefully

</font>

</h3></body>
 
<form name="reg" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
 
<table align="center" border="0" cellpadding="0" cellspacing="5">

<hr color="blue" />

    <tr>

        <td align="right">

            <p><font color="#FFFFFF" face="verdana">IC Number :</font></p>

        </td>

        <td>

            <input name="icnumber" type="text" maxlength="100" size="25" />

            <font color="orangered" size="+1"><tt><b>*</b></tt></font>

        </td>

    </tr>
 
    <tr>

        <td align="right">

            <p><font color="#FFFFFF" face="verdana">Access Code :</font></p>

        </td>

        <td>

            <input name="acccode" type="text" maxlength="100" size="25" />

            <font color="orangered" size="+1"><tt><b>*</b></tt></font>

        </td>

    </tr>

    <tr>

        <td align="right">

            <p><font color="#FFFFFF" face="verdana">Username :</font></p>

        </td>

        <td>

            <input name="username" type="text" maxlength="100" size="25" />

            <font color="orangered" size="+1"><tt><b>*</b></tt></font><td align="left">Enter a valid user name.</td>

        </td>

    </tr>

    <tr>

        <td align="right">

            <p><font color="#FFFFFF" face="verdana">Full Name :</font></p>

        </td>

        <td>

            <input name="fullname" type="text" maxlength="100" size="25" />

            <font color="orangered" size="+1"><tt><b>*</b></tt></font>

        </td>

    </tr>

    <tr>

        <td align="right">

            <p><font color="#FFFFFF" face="verdana">Email :</font></p>

        </td>

        <td>

            <input name="email" type="text" maxlength="100" size="25" />

            <font color="orangered" size="+1"><tt><b>*</b></tt></font><td>Email must be valid for password retreival.</td>

        </td>

    </tr>

    <tr>

        <td align="right">

            <p><font color="#FFFFFF" face="verdana">Hand Phone :</font></p>

        </td>

        <td>

            <input name="hp" type="text" maxlength="100" size="25" />

            <font color="orangered" size="+1"><tt><b>*</b></tt></font>

        </td>

    </tr>

    <tr><td>

    <font  face="verdana" color="orangered" size="+1"><tt><b>*</b></tt></font>

    <u><font face="arial" size="2" color="#FFFFFF">indicates a required field</u></font>

    </td>

    </tr>
 
    <tr>  

        <td align="right" colspan="3">

           <hr color="blue" />
 
            <input type="reset" value="Reset" />

            <input type="submit" name="submitok" value="Register"  />
 
        </td>

    </tr>

</table>

</form>
 
</body>

</html>
 
    <?php 
 
else:

    // Process signup submission

    dbConnect('db');
 
    if ($_POST['icnumber']=='' or $_POST['acccode']=='' or $_POST['username']==''or $_POST['fullname']==''

      or $_POST['email']=='' or $_POST['hp']=='')  { 

         error ('One or more required fields were left blank.\\n'.

              'Please fill them in and try again.');

    }
 
    // Check for existing user with the new id

    $sql = "SELECT * FROM m_users WHERE icnumber = '$_POST[icnumber]' AND acccode = '$_POST[acccode]'";

    $result = mysql_query($sql);

    if (!$result==0) {    

        error('A database error occurred in processing your '.

              'submission.\\nIf this error persists, please '.

             'contact you@example.com.');

    }

    if (mysql_result($result) < 1) {

        error('Your entered Ic number and Access code does not match\\n'.

             'to the database data. Please try agian.');

    }
 
    $newpass = substr(md5(time()),0,6);
 
    $sql = "INSERT INTO m_users where icnumber = '$_POST[icnumber]' SET

             password = PASSWORD('$newpass'),

             email = '$_POST[email]',

             h/p = '$_POST[hp]',

             username = '$_POST[username]',

             fullname = '$_POST[fullname]'";

    if (!mysql_query($sql))

        error('A database error occurred in processing your '.

              'submission.\\nIf this error persists, please '.

              'contact admin@straight-a.com.my .\\n' . mysql_error());
 
    // Email the new password to the person.

    $message = "G'Day!
 
Your personal account for the Straight-a program

has been created! To log in, proceed to the

following address:
 
    http://www.straight-a.com.my/
 
Your personal login ID and password are as

follows:
 
    username: $_POST[username]

    password: $newpass
 
You aren't stuck with this password! Your can

change it at any time after you have logged in.
 
If you have any problems, feel free to contact me at

<admin@straight-a.com.my>.
 
-Arif

 Webmaster

";
 
    mail($_POST['email'],"Your Password for the Straight-a Program",

         $message, "From:Arif <admin@straight-a.com.my>");
 
    ?>

    <!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> Registration Complete </title>

      <meta http-equiv="Content-Type"

        content="text/html; charset=iso-8859-1" />

    </head>

    <body>

    <p><strong>User registration successful!</strong></p>

    <p>Your userid and password have been emailed to

       <strong><?=$_POST['email']?></strong>, the email address

       you provided in your registration form. To log in,

       go to your email and click the link provided in your email.</p>

    </body>

    </html>

    <?php

endif;

?>

Now the question arises are these:

IC number and Access Code are alredy given to users.

1: I want that when user enters the details like Ic number,access code,Full name,email,hp,username etc. The script 1st check that is their any IC number and access code exist in the table, if have than store the
others values to the table like email,username,hp etc to that row of table.
if no error msg showed.
2: Where i edit the script to give right results.Is there any thing wrong in the sql query.

Plz help me if any body have idea..
Thanks...

Dec 28 '06 #1

Subscribe Post Reply

2731

ronverdonk

4,258

Expert 4TB

What is your problem? You already check that a user exists and, if so, update the table! So what is there to change?

Ronald :cool:

Dec 28 '06 #2

mmarif4u

Ronald the problem is simple 1st i want to check the icnumber
& access code if it exists in the database than it insert the other values
like fullname,email,handphone,username etc, But if these 2 not exists in
the database than data not stored in the database...

For example my ic number is 123456 and access code is 456,i enter
these values to the text box with completing the form like name=arif,
email=mmarif4u@domain.com,username=mmarif4u etc and click submit
button,so 1st the query checks the ic number & access code if it is in the
database than my name,email,username stored to the database otherwise
cannot...

i think u will understand what i want to say here,,,

The problem is this script cannot work, i dont know something wrong with query
or script...
When i click the button it says the user already exists,thats the problem..

Thanks

Dec 29 '06 #3

ronverdonk

4,258

Expert 4TB

You cannot do an INSERT when the record already exists. Statement should be

Expand|Select|Wrap|Line Numbers

 $sql = "UPDATE m_users SET

        password = PASSWORD('$newpass'),

        email = '$_POST[email]',

        h/p = '$_POST[hp]',

        username = '$_POST[username]',

        fullname = '$_POST[fullname]'

        WHERE icnumber = '$_POST[icnumber]'";

I must also caution you should sanitize ANY input before using it with database functions. You should at least use the strip_tags or htmlentities commands.

Ronald :cool:

Dec 29 '06 #4

by: Jack | last post by:

I have a text file of data in a file (add2db.txt) where the entries are already entered on separate lines in the following form: INSERT INTO `reviews` VALUES("", "Tony's", "Lunch", "Great...

PHP

Need help on best way to insert many items quickly

by: a-ok | last post by:

Hi, My client has a product database od around 20000 items. And it is updated every few days when he gets a catalog from the supplier. It's supposed to work like this: if there already is a...

PHP

Multiple insert - iterate form collection - checkbox name dynamic?

by: jason | last post by:

How does one loop through the contents of a form complicated by dynamic construction of checkboxes which are assigned a 'model' and 'listingID' to the NAME field on the fly in this syntax:...

ASP / Active Server Pages

insert multiple records

by: shank | last post by:

I have a recordset that contains multiple records of product a user is purchasing. For clarity, I converted the recordset fields to variables. I need to take that entire recordset and insert it...

ASP / Active Server Pages

UPDATE/INSERT to make One-to-Many table become One-to-One

by: serge | last post by:

I have a scenario where two tables are in a One-to-Many relationship and I need to move the data from the Many table to the One table so that it becomes a One-to-One relationship. I need to...

Microsoft SQL Server

Python, Mysql, insert NULL

by: Python_it | last post by:

Python 2.4 MySQL-python.exe-1.2.0.win32-py2.4.zip How can I insert a NULL value in a table (MySQL-database). I can't set a var to NULL? Or is there a other possibility? My var must be variable...

Python

Bulk Insert / Update / Delete

by: Philip Boonzaaier | last post by:

I want to be able to generate SQL statements that will go through a list of data, effectively row by row, enquire on the database if this exists in the selected table- If it exists, then the colums...

PostgreSQL Database

INSERT without knowing database column order?

by: AdamM | last post by:

Currently, my code reads from a database without knowing the order of the columns like this: string name = (string)datarow; However, is there a way to write or do an INSERT back to a database...

C# / C Sharp

insert a dictionary into sql data base

by: David Bear | last post by:

I have a dictionary that contains a row of data intended for a data base. The dictionary keys are the field names. The values are the values to be inserted. I am looking for a good pythonic...

Python

Including BLOB vaules in INSERT SQL

by: Kevin Lawrence | last post by:

Hi all I want to do "INSERT INTO Table (Blob) Values('blobdataasstring')". ...rather than using the parameter driven method, is it possible? And if so what encoder do I use to convert the...

C# / C Sharp

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

How to insert these values to database in php

Similar topics