registering php data in SQL server database 2008

Question

I have a question... I don’t know if I’m putting the Cód right, I’m a beginner in php and I need a help... I already managed to make the form I have to write in Mysql ... but now I’m working on an SQL Server and I can’t get it to record the data... I don’t know if something is missing ... I don’t know... but I needed a help... come on...

conex.php

<?
$con = mssql_connect("000.000.000.00,1111", "user", "senha");
mssql_select_db("BANCO",$con);
?>

That’s the connection I’m making ... until then it’s quiet n of error ...

this is the file that records:

writes.php

<?php require_once('Connections/conex.php'); ?>
<?php
$CPF =                       $_POST['CPF'];
...
$TITULO_3 =                  $_POST['TITULO_3'];

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "cpf-form")) {
  $insertSQL = sprintf("INSERT INTO BASE_EY (
  CPF,
  ...
  TITULO_3) VALUES (
  $CPF,
  ...
  $TITULO_3)");

  $insertGoTo = "index.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
?>

and that’s the form...

php form.

<form action="testego.php" id="camposform" method="post" name="cpf-form" target="_self">
      <div class="medium-8 columns">
        <label for="NOME">Nome<span class="red-red">*</span></label>
        <input name="NOME" id="NOME" value="" type="text" required="required">
      </div>
      <div class="medium-4 columns">
        <label for="SEXO">Sexo<span class="red-red">*</span></label>
        <select name="SEXO" id="SEXO" value="" required="required">
          <option selected="selected" disabled="disable">-- Selecione --</option>
          <option>MASCULINO</option>
          <option>FEMININO</option>
        </select>
      </div>

...

      <div class="medium-2 columns">
        <label for="ANO_GRADUACAO">Ano da Graduação<span class="red-red">*</span></label>
        <input name="ANO_GRADUACAO" id="ANO_GRADUACAO" value="" type="text" required="required">
      </div>
      <div class="div-fix"><input type="submit" class="button medium-4 columns clearfix"></div>
       <input type="hidden" name="MM_insert" value="cpf-form" />
    </form>

No error appears Cód goes straight as if everything is ok... but when I check the bank ... NOTHING... I don’t know where I’m going wrong... does anyone give me a light?? Plz :D

--------------------------------------------------- V-Edited V-V ---------------------------------------------------

I made some changes to the Cód. as per the instructions ... but it didn’t go very well... happened the same thing jumps straight as if he had registered but n cadastra... Cod was like this...

Connection file

conex.php

<?
$con = mssql_connect("000.000.000.00,5033", "user", "senha");
mssql_select_db("banco",$con);
if( $con === false )
      { die( FormatErrors( sqlsrv_errors() ) ); }
?>

cadastra.php

<?php require_once('Connections/conex.php'); ?>
<?php
$CPF =                       $_POST['CPF'];
...
$TITULO_3 =                  $_POST['TITULO_3']; //crm 02 OBS

  $insertSQL = mssql_execute("INSERT INTO BASE_EY (
  CPF,
  ...
  TITULO_3) VALUES (
  $CPF,
  ...
  $TITULO_3)");

  $insertGoTo = "index.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header("Location: $insertGoTo");
mssql_free_result($insertSQL)
?>

Any more lights out there?? rsrs

Answer 1

To insert data into SQLSRV, it is more boring than Mysql.

Here is an example of how SQLSRV should be used:

$sql = "INSERT INTO [RDO].[dbo].[funcionarios] (usuario, email, senha) VALUES (?,?,?)";

$params = array($nome, $email, $senha);

$stmt = @sqlsrv_query( $conn, $sql, $params);

Answer 2

In your code failed to call the function mssql_query() who is responsible for executing the query. To resolve Add this line:

mssql_query('INSERT INTO ....') or die(mssql_get_last_message());

When working with the database functions (mssql_, mysql_, pg_, etc) remember to call the function that displays the error in the case mssql_get_last_message(), in new projects in preference to PDO or sqlsrv