Activity Stream
48,167 MEMBERS
65470 ONLINE
besthostingforums On YouTube Subscribe to our Newsletter besthostingforums On Twitter besthostingforums On Facebook besthostingforums On facebook groups

Results 1 to 6 of 6
  1.     
    #1

    Thumbs up what's worng this code ? help

    hi all friends
    i code in php for a multipage registration form like
    first page :first name, last name
    2nd pagearental details
    .
    .
    last will submit all data to mysql database
    the code is here by page but after last page that will submit data to database got a problem.
    the problem is
    Code: 
    Error: You have an error in your SQL syntax; check the manual that  corresponds to your MySQL server version for the right syntax to use  near '='shalah',                 email_addres=  'uddin',                 membership_' at line 2
    here code for all page

    page1:
    PHP Code: 
    <form method="post" action="page2.php">
    First Name:<input type="text" name="first_name" /><br>
    Last Name:<input type="text" name="last_name"  /><br>
    <
    input type="submit" name="submit" />
    </
    form
    page2:
    PHP Code: 
    <?php
    $fname
    =$_POST['first_name'];
    $lname=$_POST['last_name'];
    ?>
    <html>
    <head></head>
    <body>
    <form method="post" action="page3.php">
    <input type="hidden" name="first_name" value="<?php echo $fname;?>" />
    <input type="hidden" name="last_name" value="<?php echo $lname;?>" />
    Education:<input type="text" name="education" /><br>
    School:<input type="text" name="school" /><br>
    <input type="submit" name="submit" />
    </form>
    </body>
    </html>
    page3:
    PHP Code: 
    <?php
    $fname
    =$_POST['first_name'];
    $lname=$_POST['last_name'];
    $education=$_POST['education'];
    $school=$_POST['school'];
    ?>
    <html>
    <head></head>
    <body>
    <form method="post" action="page4.php">
    <input type="hidden" name="first_name" value="<?php echo $fname;?>" />
    <input type="hidden" name="last_name" value="<?php echo $lname;?>" />
    <input type="hidden" name="education" value="<?php echo $education;?>" />
    <input type="hidden" name="school" value="<?php echo $school;?>" />
    Experience:<input type="text" name="experience" /><br>
    <input type="submit" name="submit" />
    </form>
    </body>
    </html>
    page3:
    PHP Code: 
    <?php
    $fname
    =$_POST['first_name'];
    $lname=$_POST['last_name'];
    $education=$_POST['education'];
    $school=$_POST['school'];
    $expe=$_POST['experiance'];
    //let's create the query
    $insert_query "insert into subscriptions (
                    name='
    $fname',
                    email_addres=  '
    $lname',
                    membership_type= '
    $education',
                    terms_and_conditions='
    $school',
                    name_on_card='
    $expe')";
    //let's run the query
    $connect=mysql_connect("localhost","root","");
    if(!
    $connect)
    {
    die(
    'Could not connect: ' mysql_error());
    }
        
    mysql_select_db("reg",$connect);
    if (!
    mysql_query($insert_query,$connect))
      {
      die(
    'Error: ' mysql_error());
      }
    echo 
    "1 record added";

    mysql_close($con);
    ?>
    please anybody help me to fix this.
    thanks in advance
    shakac Reviewed by shakac on . what's worng this code ? help hi all friends i code in php for a multipage registration form like first page :first name, last name 2nd page:parental details . . last will submit all data to mysql database the code is here by page but after last page that will submit data to database got a problem. the problem is Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='shalah', email_addres= 'uddin', Rating: 5

  2.   Sponsored Links

  3.     
    #2
    Respected Member
    Website's:
    DL4Everything.com Soft2050.in
    The problem is with your mysql query syntax

    PHP Code: 
    $insert_query "insert into subscriptions (
                    name='
    $fname',
                    email_addres=  '
    $lname',
                    membership_type= '
    $education',
                    terms_and_conditions='
    $school',
                    name_on_card='
    $expe')"
    It should be like this:

    PHP Code: 
    $insert_query "INSERT INTO subscriptions (name, email_addres, membership_type, terms_and_conditions, name_on_card)
                    VALUES (
    $fname$lname$education$school$expe) "
    It should fix your problem

    Just replace page3 with this:

    PHP Code: 
    <?php
    $fname
    =$_POST['first_name'];
    $lname=$_POST['last_name'];
    $education=$_POST['education'];
    $school=$_POST['school'];
    $expe=$_POST['experiance'];
    //let's create the query
    $insert_query "INSERT INTO subscriptions (name, email_addres, membership_type, terms_and_conditions, name_on_card)
                    VALUES (
    $fname$lname$education$school$expe) ";
    //let's run the query
    $connect=mysql_connect("localhost","root","");
    if(!
    $connect)
    {
    die(
    'Could not connect: ' mysql_error());
    }
        
    mysql_select_db("reg",$connect);
    if (!
    mysql_query($insert_query,$connect))
      {
      die(
    'Error: ' mysql_error());
      }
    echo 
    "1 record added";

    mysql_close($con);
    ?>
    Regards

  4.     
    #3
    Member
    Website's:
    premium-links.net wanted-programs.com
    depending on ur Table data type add those....

    PHP Code: 
    $insert_query "INSERT INTO subscriptions(name, email_addres, membership_type, terms_and_conditions, name_on_card) VALUES ('$fname', '$lname', '$education', '$school', '$expe')"
    single quotes are needed for string / VarChaR type field !

  5.     
    #4
    Member
    if the strings come from user input, you should escape them before putting it into queries... http://www.tizag.com/mysqlTutorial/m...-injection.php

  6.     
    #5
    Member
    Website's:
    premium-links.net wanted-programs.com
    Quote Originally Posted by deliteblogger View Post
    if the strings come from user input, you should escape them before putting it into queries... http://www.tizag.com/mysqlTutorial/m...-injection.php
    ty, i was to mention that but got lazy !!

  7.     
    #6
    Member
    i think the first one reply its correct

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 3rd Apr 2012, 09:50 AM
  2. Looking for a code fix
    By Divvy in forum Web Application/Script Support
    Replies: 1
    Last Post: 15th Dec 2011, 05:51 PM
  3. Replies: 1
    Last Post: 27th Aug 2011, 01:45 PM
  4. code [url] BB-code ?
    By Emperor in forum vBulletin
    Replies: 3
    Last Post: 16th Sep 2010, 10:55 PM
  5. [vBulletin BB Code] Moderated Message: (Like W-BB's Staff BB Code!)
    By Ghost Dog 13 in forum Webmaster Resources
    Replies: 13
    Last Post: 26th Sep 2009, 06:19 PM

Tags for this Thread

BE SOCIAL