CODEWITHSUNDEEP
phpsqldatabase
user1385694
user1385694

Reputation: 25

PHP UserID to database

First I get the BedrijfID out of the session

$Deals = $_SESSION['login'];
$sSql = "SELECT BedrijfID FROM tblBedrijf WHERE Email  = '$Deals'";     
$res = $conn->query($sSql); 
return $res;

Than I need to put it in an other Table

$sql = "INSERT INTO tblDeal (Dealnaam, Dealkeuze, Dealbeschrijving,BedrijfID) 
                                    VALUES 
                                    (
                                    '" . $conn -> real_escape_string($this -> m_sNaamdeal) . "', 
                                    '" . $conn -> real_escape_string($this -> m_sAantal) . "',
                                    '" . $conn -> real_escape_string($this -> m_sBeschrijving) . "',
                                    '" . $conn -> real_escape_string($res) . "'
                                    );";

Error:

Warning: mysqli::real_escape_string() expects parameter 1 to be string, object given in /

Upvotes: 0

Views: 105

Answers (1)

webbiedave
webbiedave

Reputation: 48897

You need to fetch a row first:

$Deals = $_SESSION['login'];
$sSql = "SELECT BedrijfID FROM tblBedrijf WHERE Email  = '$Deals'";     
$res = $conn->query($sSql);

$row = $res->fetch_assoc();

$sql = "INSERT INTO tblDeal (Dealnaam, Dealkeuze, Dealbeschrijving,BedrijfID) 
        VALUES 
        (
        '" . $conn -> real_escape_string($this -> m_sNaamdeal) . "', 
        '" . $conn -> real_escape_string($this -> m_sAantal) . "',
        '" . $conn -> real_escape_string($this -> m_sBeschrijving) . "',
        '" . $conn -> real_escape_string($row['BedrijfID']) . "'
        );";

Upvotes: 2

Related Questions