Jump to content

working with 2 tables


BluwAngel

Recommended Posts

hi

 

i have problem with connecting databases hope you can help me out

 

i have 2 tables

1. table named nastavnici - coloms:id_nastavnik(primary key, auto inc), ime_prezime

2. table named predmeti  - coloms:id_predmet (primary key, auto inc),  naziv, nastavnik, sati_tjedno

 

id_nastavnik is number

ime_prezime is text

 

i created box so i get names to choose... but heres my problem how can i connect id_nastavnik (number) with 2nd table nastavnik

 

result needs to be

when i choose ime_prezime and input naziv then in table predmeti i need to get same number of ime prezime

 

example

1. table    -  1    ; John

2. table    -  3(autoincrement number isnt important) ,  Test, 1 (THIS NUMBER IS IMPORTATNT TO BE SAME AS IN 1ST  TABLE), 7 (any input number)

 

 

now i created

 

<html>
<body>
<form action="upis_predmeta.php" method="post">
<table>
<tr><td>Predmet: <td><input name="naziv" type="text" /> <br>
<tr><td>Nastavnik: <td>
<?php
include "spoj.php";
$result = mysql_query('SELECT * FROM nastavnici');
echo "<select name='predavac'>";
while($row = mysql_fetch_array($result))
{
echo "<option>". $row['ime_prezime']. "</option>";
echo"<br>";
}
echo "</select>";
?>
<tr><td>Sati tjedno (broj): <td><input name="sati_tjedno" type="text" /> <br>
</table>
<br>

<input type="submit" />
<br><a href="index.php">Povratak</a>
</form>
</body>
</html> 

 

and other file

 

<?php
include "spoj.php";

$SQL="INSERT INTO predmeti (naziv , sati_tjedno)
VALUES ('$_POST[naziv]', '$_POST[sati_tjedno]')";

$SQL="INSERT INTO predmeti (nastavnik) FROM nastavnici
VALUES ('$_POST[id_nastavnik]')";

if (mysql_query($SQL))
{
echo "Novost je uspješno pohranjena";
} else {
echo "Novost nije pohranjena<br />" . mysql_error();
}

?>

 

 

with 2 errors (not sure its correctly since im new in this area)

Notice: Undefined index: id_nastavnik in F:\xampp\htdocs\popp\upis_predmeta.php on line 8    (2nd code)

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 'FROM nastavnici VALUES ('')' at line 1

Link to comment
Share on other sites

$SQL="INSERT INTO predmeti (nastavnik) FROM nastavnici
VALUES ('$_POST[id_nastavnik]')";

problem is with the above query. 

 

1st you don't build an insert query using a FROM clause (unless you have a SELECT  to go with it)

2nd you have not inserted the $_POST variable within the string properly.

 

Try this

$SQL="INSERT INTO predmeti (nastavnik) VALUES ('{$_POST['id_nastavnik']}')";

 

On another note, you really should not insert form varibles directly into your sql.  It is a huge security risk.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.