PHP + SQL connection sqlsrv_query

This site is best viewed in a modern browser with JavaScript enabled.

ballball

hi i'm trying to insert a query on sql db but its not successful

<?php
$se9rverName = ".";
$connectionInfo = array( "UID"=>"WebsitePhp","PWD"=>"WebsitePhp", "Database"=>"php");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn )
{
    echo "Connection established.\n";
}
else
{
    echo "Connection could not be established.\n";
    die( print_r( sqlsrv_errors(), true));
}

//-----------------------------------------------
// Perform operations with connection.
//-----------------------------------------------

/* Close the connection. */
//sqlsrv_close( $conn);
?>

<?php
include("connect.php");
?>

<?php
if($_POST['submit']){
    $sql="insert into dbo.Loan (Lon_FirstName,Lon_SurName) values (?,?)"; 
    $params= array("$_POST[fname]","$_POST[lname]");
    $test=sqlsrv_query($conn,$sql,$params);

//header('Location: index.php');


sqlsrv_close($conn);
}
//$test = sqlsrv_query('select * from loan');
?>
<form method="POST" action="index.php">
<table>
<tr>
<td>FirstName:<input type="textbox" name="fname"/></td>
<td>LastName:<input type="textbox" name="lname"/></td>
</tr>
<tr>
<td colspan=2><input type="submit" name="submit" value="submit"></td>
</tr>

</table>
</form>

ginerjm

Sorry to hear it is unsuccessful, but could you give US some idea in what way it is failing? You have error messages in this code - are you getting any of them?

btw - I don't think you need quotes around the vars in the array.

ballball

ginerjm;1310775 wrote:
Sorry to hear it is unsuccessful, but could you give US some idea in what way it is failing? You have error messages in this code - are you getting any of them?

btw - I don't think you need quotes around the vars in the array.

if($_POST['submit']){
   // $sql="insert into dbo.Loan (Lon_FirstName,Lon_SurName) values (?,?)"; 
   // $params= array("$_POST[fname]","$_POST[lname]");
    //$test=sqlsrv_query($conn,$sql,$params);

//header('Location: index.php');
$sql = "INSERT INTO loan (LoanID,Lon_FirstName, Lon_SurName) VALUES (?,?, ?)";
$params = array('',$_POST[fname], $_POST[lname]);

$stmt = sqlsrv_query( $conn, $sql, $params);
if( $stmt === false ) {
    die( print_r( sqlsrv_errors(), true));
}

}

this is the current code that i did...
somehow i manage to insert the data on the sql database, but
the LoanID requires me to insert the ID which is not what i want to happen, i already set the LoanID COLUMN into autoincrement.. but it give's me this error if i did not set any data on the column.

Array ( [0] => Array ( [0] => 23000 [SQLSTATE] => 23000 [1] => 2627

 => 2627 [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PK_Loan'. Cannot insert duplicate key in object 'dbo.Loan'. The duplicate key value is (5). [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PK_Loan'. Cannot insert duplicate key in object 'dbo.Loan'. The duplicate key value is (5). ) [1] => Array ( [0] => 01000 [SQLSTATE] => 01000 [1] => 3621 [code] => 3621 [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated. [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated. ) )

ginerjm

Don't include loaned in your query statement then.

ballball

if($POST['submit']){
// $sql="insert into dbo.Loan (Lon_FirstName,Lon_SurName) values (?,?)";
// $params= array("$POST[fname]","$_POST[lname]");
//$test=sqlsrv_query($conn,$sql,$params);

//header('Location: index.php');
$sql = "INSERT INTO loan (Lon_FirstName, Lon_SurName) VALUES (?, ?)";
$params = array($_POST[fname], $_POST[lname]);

$stmt = sqlsrv_query( $conn, $sql, $params);
if( $stmt === false ) {
    die( print_r( sqlsrv_errors(), true));
}

}
i already remove the Primary Key column, still it throws me this..

Array ( [0] => Array ( [0] => 23000 [SQLSTATE] => 23000 [1] => 515

 => 515 [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'LoanID', table 'php.dbo.Loan'; column does not allow nulls. INSERT fails. [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'LoanID', table 'php.dbo.Loan'; column does not allow nulls. INSERT fails. ) [1] => Array ( [0] => 01000 [SQLSTATE] => 01000 [1] => 3621 [code] => 3621 [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated. [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated. ) )

ginerjm

Are you sure you defined that column as auto-increment in your structure?

ballball

hi, i check the table, i thought it was already save once you switch the No to yes on autoincrementation setting, yep its already working, thanks,

sql studio is a bit complicated compared to phpmyadmin