www.webdeveloper.com
Results 1 to 2 of 2

Thread: Problem with PHP script for uploading to DB

  1. #1
    Join Date
    Aug 2011
    Posts
    2

    Question Problem with PHP script for uploading to DB

    Title says it all. Here is the error I get:

    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 '','1-11-111-11-11-11111','',now())' at line 1


    Upload script looks like this:

    PHP Code:
    if($_POST['doSubmit'] == 'Add Distributor')
    {

    if (!
    $link)
    {
    die(
    'Could not connect: ' mysql_error());
    }

    $name_dist=mysql_real_escape_string($_POST['name_dist']);
    $address_dist=mysql_real_escape_string($_POST['address_dist']);
    $city_dist=mysql_real_escape_string($_POST['city_dist']);
    $state_dist=mysql_real_escape_string($_POST['state_dist']);
    $zip_dist=mysql_real_escape_string($_POST['zip_dist']);
    $phone_dist=mysql_real_escape_string($_POST['phone_dist']);
    $ffl_dist=mysql_real_escape_string($_POST['ffl_dist']);
    $dob_dist=mysql_real_escape_string($_POST['dob_dist']);
    $sql="INSERT INTO `distributors` (name_dist,address_dist,city_dist,state_dist,zip_dist,phone_dist,ffl_dist,dob_dist,dateAdded_dist) VALUES ('$name_dist','$address_dist','$city_dist','$state_dist','$zip_dist',$phone_dist','$ffl_dist','$dob_dist',now())"

    if (!
    mysql_query($sql,$link)) {
    die(
    'Error: ' mysql_error());
    }
    echo 
    "<div class=\"msg\">New Distributor Added....done.</div>";             

    Form looks like this:

    HTML Code:
              <p><?php 
    	  				   if(!empty($msg)) {
    	  					 	 echo $msg[0];
    	  					 } ?></p>
          <table width="100%" border="0" cellpadding="5" cellspacing="2" class="myaccount">
            <tr>
              <td style="text-align:right"><form name="addNew" id="addNew" method="post" action="distributors.php">Name of Distributor or Consignor:&nbsp;</td>
              <td style="text-align:left"><input name="name_dist" type="text" id="name_dist" size="40" class="required"></td>
            </tr>
            <tr>
            	<td style="text-align:right">Street:&nbsp;</td>
              <td style="text-align:left"><input name="address_dist" type="text"  size="40" class="required" id="address_dist"></td>
    				</tr>
            <tr>
            	<td style="text-align:right">City:&nbsp;</td>
              <td style="text-align:left"><input name="city_dist" type="text"  size="40" class="required" id="city_dist"></td>
    				</tr>
            <tr>
            	<td style="text-align:right">State:&nbsp;</td>
              <td style="text-align:left"><input name="state_dist" type="text"  size="40" class="required" id="state_dist"></td>
    				</tr>
            <tr>
            	<td style="text-align:right">Zip:&nbsp;</td>
              <td style="text-align:left"><input name="zip_dist" type="text"  size="40" class="required" id="zip_dist"></td>
    				</tr>
            <tr>
            	<td style="text-align:right">Phone Number:&nbsp;</td>
              <td style="text-align:left"><input name="phone_dist" type="text" id="phone_dist" size="40" class="required"></td>
    				</tr>
            <tr>
            	<td style="text-align:right">FFL:&nbsp;</td>
              <td style="text-align:left"><input name="ffl_dist" type="text" id="ffl_dist" size="40"></td>
    				</tr>
            <tr>
            	<td style="text-align:right">DOB if no FFL:&nbsp;</td>
              <td style="text-align:left"><input name="dob_dist" type="text" id="dob_dist" size="40"></td>
    				</tr>        
            <tr>
            	<td colspan="2" style="text-align:center"><input name="doSubmit" type="submit" id="doSubmit" value="Add Distributor"></form></td>
    				</tr>        
          </table>
    DB table looks like this:

    Code:
      `id_dist` int(11) NOT NULL AUTO_INCREMENT,
      `name_dist` varchar(255) COLLATE latin1_general_ci NOT NULL,
      `address_dist` text COLLATE latin1_general_ci NOT NULL,
      `city_dist` varchar(100) COLLATE latin1_general_ci NOT NULL,
      `state_dist` varchar(2) COLLATE latin1_general_ci NOT NULL,
      `zip_dist` int(5) NOT NULL,
      `phone_dist` varchar(255) COLLATE latin1_general_ci NOT NULL,
      `ffl_dist` varchar(255) COLLATE latin1_general_ci NOT NULL,
      `dob_dist` varchar(10) COLLATE latin1_general_ci NOT NULL,
      `dateAdded_dist` date NOT NULL DEFAULT '0000-00-00',
      PRIMARY KEY (`id_dist`),
      UNIQUE KEY `name_dist` (`name_dist`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=9 ;
    Any ideas on why I am getting that error? I have other forms that use this same setup and they work fine so I am not sure what I am missing or have done wrong. Any help would be appreciated.

    Thanks,

    Clint

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    22,326
    looks like you left out a single quote before $phone_dist in the SQL string.
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

Thread Information

Users Browsing this Thread

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

Posting Permissions

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

"

"

X vBulletin 4.2.2 Debug Information

  • Page Generation 0.15237 seconds
  • Memory Usage 2,872KB
  • Queries Executed 15 (?)
More Information
Template Usage (35):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)bbcode_code
  • (1)bbcode_html
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (2)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (1)navbar_moderation
  • (1)navbar_noticebit
  • (1)navbar_tabs
  • (2)option
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (26):
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/functions_navigation.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_facebook.php
  • ./includes/functions_calendar.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (72):
  • init_startup
  • friendlyurl_resolve_class
  • init_startup_session_setup_start
  • database_pre_fetch_array
  • database_post_fetch_array
  • init_startup_session_setup_complete
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • load_show_variables
  • load_forum_show_variables
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • strip_bbcode
  • friendlyurl_clean_fragment
  • friendlyurl_geturl
  • forumjump
  • cache_templates
  • cache_templates_process
  • template_register_var
  • template_render_output
  • fetch_template_start
  • fetch_template_complete
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • build_navigation_data
  • build_navigation_array
  • check_navigation_permission
  • process_navigation_links_start
  • process_navigation_links_complete
  • set_navigation_menu_element
  • build_navigation_menudata
  • build_navigation_listdata
  • build_navigation_list
  • set_navigation_tab_main
  • set_navigation_tab_fallback
  • navigation_tab_complete
  • fb_like_button
  • showthread_complete
  • page_templates