Código PHP:
<?php
$serverName = "host\SQLEXPRESS"; //serverName\instanceName
$connectionInfo = array( "Database"=>"db", "UID"=>"sa", "PWD"=>"pas");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
echo "Connection established.<br />";
}else{
echo "Connection could not be established.<br />";
die( print_r( sqlsrv_errors(), true));
}
if ((eregi("[^a-zA-Z0-9_-]", stripslashes($_POST['RUser']))) || (eregi("[^a-zA-Z0-9_-]", stripslashes($_POST['RPass']))) || (eregi("[^a-zA-Z0-9_-]", stripslashes($_POST['RCorreo']))))
{
echo("<style type='text/css'>
<!--
body {
background-color: #B0C0EC;
}
-->
</style>Error solo letras y numeros");
exit();
}
else
{
$usuario = $_POST['RUser'];
$pass = $_POST['RPass'];
$correo = $_POST['RCorreo'];
$sqlselect = "select memb___id from MEMB_INFO where memb___id = '$usuario'";
$paramsselect = array();
$optionsselect = array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
$stmtselect = sqlsrv_query( $conn, $sqlselect , $paramsselect, $optionsselect );
$row_count = sqlsrv_num_rows( $stmtselect );
if ($row_count == 0)
{
echo "El Usuario No Existe";
$sql = "insert into dbo.MEMB_INFO (memb___id,memb__pwd,memb_name,sno__numb,bloc_code,ctl1_code) Values ('$usuario','$pass','$correo',1,0,1)";
$params = array(1, "some data");
$stmt = sqlsrv_query( $conn, $sql, $params);
exit();
}
else
{
echo "El Usuario Si Existe";
exit();
}
}
?>
modifique el script ahora si registra los registros y valida si están ya en la base de datos que podría mejorar ? o lo dejo así ?
ahora voy a poner una if para valores nulos