Insert values in mssql table via php

Question

Tell the syntax to insert a value into the table.
simple table
you need to insert the value of the variable

$sql = " INSERT INTO Pcontent ([Ptittle])VALUES('$Ptittle')" ; echo "<br>";

but nothing is entered in the table

here is the listing:

 $sql = " INSERT INTO dbo.Pcontent ([Ptittle])VALUES('$Ptittle')" ; echo "<br>"; $result = sql_query($sql)or die('Error querying MSSQL database');

when sql query error appears:

 PHP Fatal error: Uncaught Error: Call to undefined function sql_query() in C:\inetpub\wwwroot\technet\admin\scripts\gen_page.php:51 Stack trace: #0 {main} thrown in C:\inetpub\wwwroot\technet\admin\scripts\gen_page.php on line 51

progmb progmb 700 eight 33 · Answer 1 · 2016-12-01T09:08:47

 $query = "INSERT INTO TABLENAME (id,name) VALUES ('$id','$name')"; $result = mssql_query($query,$dbc)

$query - query $dbc - connection to the database

progmb

700 eight 33

crashes with this output PHP Fatal error: Uncaught Error: Call to undefined function mssql_query () in C: \ inetpub \ wwwroot \ technet \ admin \ scripts \ gen_page.php: 51 Stack trace: # 0 {main} thrown in C: \ inetpub \ wwwroot \ technet \ admin \ scripts \ gen_page.php on line 51 - qaz qaz
@qazqaz, stackoverflow.com/a/17103976/4827341 - aleksandr barakin

|

qaz qaz qaz qaz 83 eight · Answer 2 · 2016-12-01T12:35:06

figured out, it was necessary to use instead of mssql ssqlsrv

This is not an answer, it is rather a comment. Complete and expand your answer. - AK ♦

Insert values in mssql table via php

2 answers 2

More articles:

Insert values ​​in mssql table via php

2 answers 2

More articles:

Insert values in mssql table via php