Using "Select" in "Insert" statement in MYSQL with PHP

Question

I have created a form that I link with PHP. I need the foreign key number to be the same with id of another table.

There is no problem of extracting data from the form and I test this on Error Session. Also no problem with foreign key connection on the database.

However, Select statement does not work. Is it about syntax in the insert statement ? Thanks.

$Connection=mysqli_connect('localhost','root','','databasename'); 

$Query="INSERT INTO musteri_ekle(tarih,musteri_ismi,urun_id) 
VALUES('$Now','$Musteri_ismi',(SELECT urun_id from urun_ekle WHERE urun_ismi='$Urun_ismi'))";

$Execute=mysqli_query($Connection,$Query);

        if($Execute){

            $_SESSION["SuccessMessage"]= "Müşteri Eklendi.";
            redirect_to("musteri_ekle.php");


} else {

     $_SESSION["ErrorMessage"]= $Urun_ismi." -- ".$Musteri_ismi;
     redirect_to("musteri_ekle.php");
        }
}

flyingfox · Accepted Answer · 2018-06-12 11:01:34Z

3

You can not use select inside values.

Change your code from

$Query="INSERT INTO musteri_ekle(tarih,musteri_ismi,urun_id) 
VALUES('$Now','$Musteri_ismi',(SELECT urun_id from urun_ekle WHERE urun_ismi='$Urun_ismi'))";

to below:

$Query="INSERT INTO musteri_ekle(tarih,musteri_ismi,urun_id) 
SELECT '$Now','$Musteri_ismi',urun_id from urun_ekle WHERE urun_ismi='$Urun_ismi'";

answered Jun 12, 2018 at 11:01

flyingfox

13.5k4 gold badges30 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jefffy Over a year ago

Works perfect ! Thanks !!

SynapseIndia · Accepted Answer · 2018-06-12 11:14:58Z

1

Alternate syntax

$Query="INSERT INTO musteri_ekle SET tarih = '$Now' ,musteri_ismi = '$Musteri_ismi' ,urun_id = (SELECT urun_id from urun_ekle WHERE urun_ismi='$Urun_ismi')";

This type of problem is discussed here MySQL INSERT INTO ... VALUES and SELECT

answered Jun 12, 2018 at 11:14

SynapseIndia

4502 silver badges10 bronze badges

Collectives™ on Stack Overflow

Using "Select" in "Insert" statement in MYSQL with PHP

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related