Databases
StackOverflow2013
Postsdbo
POmysql insert problem
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POmysql insert problem
    primarykey
    data
    text
    <p>ive got a really weird problem. i have no clue why its not working. i create an user and get the id and insert a row based on that id in another table. the row gets inserted with that id but the other values however for that row are not inserted!</p> <pre><code> $user_id = mysqli_insert_id($this-&gt;connection); $query = "INSERT INTO selections (user_id, language_id, country_id, region_id, city_id, gender_id, age_id, category_id) VALUES ($user_id, 1, 1, 0, 0, 0, 20, 0)"; </code></pre> <p>so the user_id gets inserted, but not the other values (they are all 0 in the table). i have really checked the columns and deleted all foreign keys to debug this problem. but i have no clue at all.</p> <p>the columns are all INT. the weird part is sometime when i replace $user_id with a literal number it works, sometimes it doesnt. but the row is always created. and i have checked that $user_id is an integer.</p> <p>i know this is a hard problem and that it can be caused of a lot of things, but i have tried to solve this tiny issue for 3 hours now. so would be great if someone just gave me something i could do to debug this problem.</p> <p>UPDATE: even when i have set default values and just insert the first column (user_id) it doesnt work. every other field is 0. So weird!</p> <pre><code>| selections | CREATE TABLE `selections` ( `user_id` int(11) NOT NULL, `language_id` int(11) NOT NULL DEFAULT '1', `country_id` int(11) NOT NULL DEFAULT '1', `region_id` int(11) NOT NULL DEFAULT '0', `city_id` int(11) NOT NULL DEFAULT '0', `gender_id` int(11) NOT NULL DEFAULT '0', `age_id` int(11) NOT NULL DEFAULT '0', `category_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | $query = "INSERT INTO selections (user_id) VALUES ('$user_id')"; </code></pre> <p>the user_id shows 178 and other fields are 0:(</p> <h2>UPDATE:</h2> <p>It worked in the sql command line. but not in php. but mysqli generated no error and the row was indeed inserted but why are the other fields 0?</p> <p>ANSWER: My fault. i had a jquery script that changed it back to 0 0 0 0 0 0 0. There's a lot of AJAX on my page so it was tricky to find it...sorry my bad!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USajsie
    1. USajsie
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COCan you get us the result of SHOW CREATE TABLE selections; in MySQL?
      singulars
      1. POmysql insert problem
      1. USEmil Vikström
    2. COHave you checked that the `mysqli_query()` or whatnot calls actually *succeed*?
      singulars
      1. POmysql insert problem
      1. USIgnacio Vazquez-Abrams
    3. COHave you tried to append the user id via `( " .$userid . ",....`?
      singulars
      1. POmysql insert problem
      1. USAnthony Forloney
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload