Bem pessoal, já tentei de tudo…estou desenvolvendo um app com o cordova as requisições em Ajax, certo…Porem, o exemplo que tenho é ainda com a clausula MYSQL, não roda no PHP7 até aí beless…converti para MSQLI,…bem não está dando certo, gostaria que alguém pudesse dar uma olhada e ver o que há de errado. grato!!
Segue: o JS
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
$(document).ready(function(){
var url="http://192.168.1.3/www/autoriza/cordovas/registrar.php?callback=?";
//signup function
$("#signup").click(function(){
var fullname=$("#fullname").val();
var email=$("#email").val();
var password=$("#password").val();
var dataString="fullname="+fullname+"&email="+email+"&password="+password+"&signup=";
if($.trim(fullname).length>0 & $.trim(email).length>0 & $.trim(password).length>0)
{
$.ajax({
type: "POST",
url: url,
data: dataString,
crossDomain: true,
cache: false,
beforeSend: function(){ $("#signup").val('Connecting...');},
success: function(data){
if(data=="success")
{
alert("Deu certo for Registering with us! you can login now");
}
else if(data="exist")
{
alert("Se for seu primeiro registro houve um erro!!");
}
else if(data="failed")
{
alert("Something Went wrong");
}
}
});
}return false;
});
});
Aqui o form html:
<body>
<div class="bar bar-header">
<h1 class="title">Ciar conta</h1>
<a href="login.html" class="button button-clear button-royal">Login</a>
</div>
<div class="padding" style="margin-top:75px;">
<label class="item-input">
<span class="input-label">Full Name</span>
<input type="text" placeholder="Sundaravel" id="fullname">
</label>
<label class="item-input">
<span class="input-label">Email</span>
<input type="email" placeholder="email@domain.com" id="email">
</label>
<label class="item-input">
<span class="input-label">Password</span>
<input type="password" placeholder="password" id="password">
</label>
<label class="item-input">
<button class="button button-block button-positive" id="signup">Create an Account</button>
</label>
</div>
Agora o .php
<?php
header(“Access-Control-Allow-Origin: *”);
include('config.php');
if(isset($_POST['signup'])){
$fullname=$_POST['fullname'];
$email=$_POST['email'];
$password=$_POST['password'];
$query=$conn->query("select * from cordova where email='$email'");
if ($query->num_rows>0){
echo "usuario já existe";
}
elseif (!preg_match("/^[a-zA-Z0-9_]*$/",$fullname)){
echo "usuario invalido";
}
elseif (!preg_match("/^[a-zA-Z0-9_]*$/",$password)){
echo "senha invalida";
}
elseif (!preg_match("/^[a-zA-Z0-9_]*$/",$email)){
echo "email invalido";
}
else{
$password=md5($password);
$date=date("d-m-y h:i:s");
$conn->query("insert into cordova (reg_date,email,fullname, password) values ('$date','$email','$fullname', '$password')");
echo "Registrado";
}
}
?>
Como era:
if(isset($_POST['signup'])) {
$fullname=mysql_real_escape_string(htmlspecialchars(trim($_POST['fullname'])));
$email=mysql_real_escape_string(htmlspecialchars(trim($_POST['email'])));
$password=mysql_real_escape_string(htmlspecialchars(trim($_POST['password'])));
$login=mysql_num_rows(mysql_query("select * from `phonegap_login` where `email`='$email'"));
if($login!=0)
{
echo "exist";
}
else
{
$date=date("d-m-y h:i:s");
$q=mysql_query("insert into `phonegap_login` (`reg_date`,`fullname`,`email`,`password`) values ('$date','$fullname','$email','$password')");
if($q)
{
echo "success";
}
else
{
echo "failed";
}
}
echo mysql_error();
}