PHP - Execute SQL calling function does not work

Question

I'm new to PHP, I have no clue what I'm doing. I'm trying to perform an insert into my MSSQL database. Not really sure why this is not working.

function Register_WBG_Tester($Email, $FullName, $ChatHandle, $Product, $PreferedGenre, $PreviousTester, $AgeGroup, $PlayTime, $Discord, $NDA)
{
    sqlsrv_configure('WarningsReturnAsErrors',0);
    $query;
    $result;

    $query = (string)"
    DECLARE @Response AS BIT = 0;
    IF NOT EXISTS(SELECT Email FROM [dbo].[WBG_Tester] WHERE [Email] = $Email) BEGIN
    INSERT INTO [dbo].[WBG_Tester]
               ([Email]
               ,[Full_Name]
               ,[Chat_Handle]
               ,[Product]
               ,[Prefered_Genre]
               ,[Previous_Tester]
               ,[Age_Group]
               ,[Play_Time]
               ,[Discord]
               ,[NDA_Agreement])
         VALUES
               ($Email
               ,$FullName
               ,$ChatHandle
               ,$Product
               ,$PreferedGenre
               ,$PreviousTester
               ,$AgeGroup
               ,$PlayTime
               ,$Discord
               ,$NDA
               )

        SET @Response = 1
    END ELSE BEGIN
        SET @Response = 0
    END

    SELECT @Response"

    $result =(bool)mssql_query($query);

    return $result;        
}

I've never worked with PHP before, mostly work with .Net I would prefer to exec calling a stored proc rather then string query. Any help would be great. Everything I've found was for MySQL. seems to be preferred for PHP.

You should upgrade your driver and use error reporting. `$Email` and all other strings would need to be quoted. Also `mssql_*` is in the same boat at `mysql_*`, `Warning This function was REMOVED in PHP 7.0.0.` — user3783243, Apr 09 '20 at 17:19
There's a syntax error in the code you posted. Have you turned on error reporting? If you're unsure how to check for errors, see [this post](https://stackoverflow.com/questions/1053424/how-do-i-get-php-errors-to-display). — El_Vanja, Apr 09 '20 at 17:22
@user3783243 They are not using mysql_, but MSSQL. Different animal ;-) — Funk Forty Niner, Apr 09 '20 at 17:22
Using Word press would I still have a php.ini file? Using blue host — mholmes, Apr 09 '20 at 17:29
@FunkFortyNiner But the same in PHP 7 terms because both have been removed. — user3783243, Apr 09 '20 at 17:38
Might be dumb question do you have try & catch in PHP and print the error? — mholmes, Apr 09 '20 at 17:40
In my previous comment I gave you a link to a post that contains instructions on displaying errors, did you check that out? — El_Vanja, Apr 09 '20 at 18:02
@El_Vanja I did but this is for Wordpress I asked does wp have a php.ini file no response. According to research because its wp it may not have one. — mholmes, Apr 09 '20 at 18:12
Sorry, I overlooked that. The answer there specifies you can do this in `htaccess` instead. You're missing `;` at the end of your SQL string, did you accidentally leave it out in the question or is this error in live code too? — El_Vanja, Apr 09 '20 at 18:16

score 0 · Answer 1 · answered Apr 09 '20 at 17:27

This is how you can execute store procedures in php

sqlsrv_prepare ( resource $conn , string $sql [, array $params [, array $options ]] ) : mixed

Prepares a query for execution. This function is ideal for preparing a query that will be executed multiple times with different parameter values.

$sql = "EXEC stp_Create_Item @Item_ID = ?, @Item_Name = ?";
$stmt = sqlsrv_prepare($conn, $sql, $procedure_params);
if (!sqlsrv_execute($stmt)) {
    echo "Your code is fail!";
    die;
}
while($row = sqlsrv_fetch_array($stmt)){
    //Stuff
}

For more details please visit, php official documentation.

PHP - Execute SQL calling function does not work

1 Answers1