SQL PHP Insert issue

by

There are several problems with the code as you have it. First of all, in this line, you want the value of a form-field called name_object.

 $name_object =$_POST['name_object'];

but there is no such form name. So either change that code to use the correct field name, or change the form to use this name. Spot the difference:

<select name="object">

In here:

echo "<option value=\"cust_name1\">" . $row['cust_name'] . "</option>";

and here:

echo "<option value=\"name_object1\">" . $row['name_object'] . "</option>";

you’re setting the value for every drop-down to be the same value, both of them text strings, which are almost certainly not in your other tables. Just do a “view source” on the form when it’s displayed to see what I mean.

Change the above to use the unique-id for each table, which will pass them through to your form processing code. Once in there, all you need to do is

 $sql = "INSERT INTO files (id_cust, register_date, id_object) 
         VALUES ($cust_name, $register_date, $name_object)";

after you’ve done some validation of the various values and fixed the field name issue.

Of course, once it’s working, you’ll want to change it to use prepared statements rather than just concatenating strings into the query.

More Related Contents:

  1. How to Update one column (point) in php sql [duplicate]
  2. 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 ‘WHERE `id` [closed]
  3. how to get client’s IP address in sql database [closed]
  4. Combine multiple sql / mysql queries in one query
  5. How can create Database using url or other method [duplicate]
  6. Php foreach give 2 users random value
  7. Cleansing User Passwords
  8. SELECT COUNT(*) AS count – How to use this count
  9. selecting unique values from a column
  10. Simple PHP Pagination script [closed]
  11. I cannot get my login form to connect interact properly with mySQL database [closed]
  12. mysql_num_rows(): supplied argument is not a valid MySQL result resource [duplicate]
  13. Increment value in MySQL update query
  14. Create a dynamic mysql query using php variables
  15. How to separate DATE and TIME from DATETIME in MySQL?
  16. Do SQL connections opened with PDO in PHP have to be closed
  17. CodeIgniter MSSQL connection
  18. MySQLi prepared statements with IN operator [duplicate]
  19. Laravel Advanced Wheres how to pass variable into function?
  20. How to convert ISO8601 to Date format in php
  21. MySQL skipping first row
  22. How to execute my SQL query in CodeIgniter
  23. Fatal error: Call to a member function query() on null
  24. How would I implement a simple site search with php and mySQL?
  25. Get orders total purchases amount for the day in Woocommerce
  26. Do I have to use mysql_real_escape_string if I bind parameters?
  27. PDO and MySQL ‘between’
  28. Get Return Value from SQL Stored Procedure using PHP
  29. MySQL Join Multiple Rows as Columns
  30. PDO Return All Rows [duplicate]

Leave a Comment