Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder Andy92's Avatar
    Join Date
    Nov 2005
    Location
    Horsham, West Sussex, UK
    Posts
    363
    Thanks
    7
    Thanked 1 Time in 1 Post

    Submiting data into a mysql table from a form

    Hi there,

    I have 2 files called add.php and create.php

    In create.php i have...

    Code:
    <form action="/admin/news/add.php" method="post" name="news" id="news">
     <table width="100%">
          <tr>
            <td><div><div class="text_bold">Id: <span class="text_link_colour">*</span></div></div></td>
            <td width="83%"><input name="id" type="text" id="id" style="width: 475px;" maxlength="11" /></td>
          </tr>
       <tr>
            <td><div><div class="text_bold">Title: <span class="text_link_colour">*</span></div></div></td>
            <td width="83%"><input name="title" type="text" id="title" style="width: 475px;" maxlength="100" /></td>
          </tr>
          <tr>
            <td><div><div class="text_bold">Mini: <span class="text_link_colour">*</span></div></div></td>
            <td><input name="mini" type="text" id="mini" style="width: 475px;" maxlength="200" /></td>
          </tr>
          <tr>
            <td><div><div class="text_bold">Full: <span class="text_link_colour">*</span></div></div></td>
            <td rowspan="2"><textarea name="full" rows="10" id="full" style="width: 475px;"></textarea></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
          </tr>
       <tr>
            <td><div><div class="text_bold">Image: <span class="text_link_colour">*</span></div></div></td>
            <td><input name="image" type="text" id="image" style="width: 475px;" value="http://www.allsortshop.com/images/news/image.jpg" /></td>
          </tr>
       <tr>
            <td><div><div class="text_bold">Posted: <span class="text_link_colour">*</span></div></div></td>
            <td><input name="posted" type="text" id="posted" style="width: 475px;" value="00/00/0000" maxlength="50" /></td>
          </tr>
          <tr>
            <td><div><div class="text_bold">Full Story: <span class="text_link_colour">*</span></div></div></td>
            <td><input name="full_story" type="text" id="full_story" style="width: 475px;" value="The url of the news story" maxlength="500" /></td>
          </tr>
       <tr>
            <td><div>
              <div class="text_bold">Name: <span class="text_link_colour">*</span></div>
            </div></td>
            <td><input name="news_name" type="text" id="news_name" style="width: 475px;" value="The name of the news company" maxlength="300" /></td>
          </tr>
       <tr>
            <td><div><div class="text_bold">News Url: <span class="text_link_colour">*</span></div></div></td>
            <td><input name="news_url" type="text" id="news_url" style="width: 475px;" value="The news companys url address" maxlength="200" /></td>
          </tr>
       <tr>
            <td><div><div class="text_bold">Posted By: <span class="text_link_colour">*</span></div></div></td>
            <td><input name="user" type="text" id="user" style="width: 475px;" maxlength="200" /></td>
          </tr>
       <tr>
            <td><div><div class="text_bold">Day: <span class="text_link_colour">*</span></div></div></td>
            <td><input name="day" type="text" id="day" style="width: 475px;" maxlength="3" /></td>
          </tr>
          <tr>
            <td height="17" colspan="2"><span class="text_link_colour">*</span> = Required Field </td>
            </tr>
          <tr>
            <td height="23" colspan="2"><div align="center">
              <input name="Send" type="submit" id="Send" value="Send!" />
            </div></td>
          </tr>
        </table>
     </form>
    Then in add.php i have the following php code...

    PHP Code:
    <?php 
    $server 
    "localhost"// server to connect to.
    $database "my database"// the name of the database.
    $db_user "database user"// mysql username to access the database with.
    $db_pass "my password"// mysql password to access the database with.
    $table "news";  // the table that this script will set up and use. 
    // connect to the mysql server
    $link mysql_connect($server$db_user$db_pass)
    or die (
    "Could not connect to mysql because ".mysql_error());
    // select the database
    mysql_select_db($database)
    or die (
    "Could not select database because ".mysql_error());
    // insert the data
    $insert mysql_query("insert into $table values ('".$_POST['id']."','".$_POST['title']."',
    '"
    .$_POST['mini']."','".$_POST['image']."','".$_POST['full_story']."','".$_POST['news_name']."','".$_POST['news_url']."','".$_POST['user']."','".$_POST['day']."','NULL','".$_POST['full']."','".$_POST['posted']."')")
    or die(
    "Could not insert data because ".mysql_error());
    // print a success message
    echo "Your news story has been added to the allsortshop news database! Have a look on the site to see your news post!";  
    ?>
    Then when i fill in the form and press submitt, it goes to add.php and displays this error...

    Could not insert data because Column count doesn't match value count at row 1

    How can i fix this so that it will add it to the mysql database???


  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    You are using either more or less columns than your table contains on your insert statement. Also don't use '' around NULL or it will store the string NULL which isn't the same thing as NULL.

  • #3
    Regular Coder Andy92's Avatar
    Join Date
    Nov 2005
    Location
    Horsham, West Sussex, UK
    Posts
    363
    Thanks
    7
    Thanked 1 Time in 1 Post
    Ok, ive got it all working now.

    Thanks!


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •