Php mysqli

Question

Is it necessary to join two tables in which one has a foreign key before it’ll be possible to insert data from different pages into the tables?

Answer 1

usualy we join two tables for the purpuse of view, and the insert statement work on a table or a simple view from one table, not on a view from multiple tables

Answer 2

the insert works when the foreign key isnt set on the child table. i dont know why

Answer 3

the child table have to contain the foreign key, and also your insert statement on the child table must contain the foreign key in order to work

Answer 4

i tried that but didnt work. could there be another reason?

Answer 5

sure that could be another reason

Answer 6

could it be that because they’re on different pages? the values don’t insert on the page with the foreign key table

Answer 7

send me your two tables structure and your insert request, and i will have a look later

Answer 8

ok

Answer 9

$sql=“INSERT INTO users (username, fname)VALUES(‘$username’, ‘$fname’);
mysqli_query($link, $sql);

on the child insert on the other page:

$sql=“INSERT INTO relationship (user_id, relationship_type)VALUES(‘$user_id’, ‘$relationship_type’);
mysqli_query($link, $sql);

table structure relationship
relationship_id int(11) primary key
relationship_type varchar(255)
user_id foreign key reference (users)

Answer 10

you think i should include the mysqli_insert_id() ?

Answer 11

to find if your query contain to right values before the execution, try to print it on the screen and see if every value is correct

Answer 12

how do you mean?

Answer 13

you can use mysqli_insert_id() if the INSERT INTO users is the last query before the INSERT INTO relationship query

Answer 14

echo $sql;

Answer 15

the user-id which is the foreign key only prints out as zero as the value

Answer 16

sorry for the late answer, you have to assign the right value to $user-id before using it in the query

Answer 17

i did assign it by using the mysqli_inser_id(), but still didnt work

Answer 18

did you verify the query with echo $sql after using the mysqli_insert_id

Answer 19

yeah, and the value for the userid was ‘0’

Answer 20

so you are not assigning the right value to $user_id, you have to make sure to transfert the value of the user ID to the page of relationship query by using a POST or GET method, or by retreving it directly from the DB