Level 39
Did you start a Laravel app?
1 like
Mar 1, 2022
23
Level 1
How to to chek user email and phone Already In database email & phone validation
<?php
$connect = mysqli_connect("localhost","root","", "connect_my");
if(isset($_POST['send'])){
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$dept = $_POST['dept'];
$email_select = "SELECT * FROM insert_data WHERE email = '$email'";
$exc = mysqli_query($connect, $email_select);
$count =mysqli_num_rows($exc);
if($count>0){
echo "<script>alert('Email Already In') </script>"."<script>alert('phone Already In') </script>";
}
else{
$query = "INSERT INTO insert_data (name,email,phone,dept)
VALUES ('$name','$email','$phone','$dept')";
$insert = mysqli_query( $connect ,$query );
if($insert){
echo "<script>alert('data send success')</script>";
}
else{
echo "<script>alert('data send failed')</script>";
}
}
}
?>`Preformatted text`
Level 1
@sr57 no bro row php iam working it
Level 102
@sr57 pretty sure this has nothing to do with laravel. Just plain php :)
1 like
Level 1
@Sinnbeck right , how to both of validation email & phone please tell me advance thanks
Level 39
@Sinnbeck I agree but wated to be sure.
Level 39
@sultanwebdev and what's your pb, you have so many way of doing what you want to do ...
Level 1
@sr57 i need both of validation email & phone in my database first check if no data previous then data insert
Level 39
how to both of validation email & phone
You can use OR in your sql
SELECT * FROM insert_data WHERE email = '$email' OR phone='$phone'
Level 1
@sr57 write me the correct code please
Level 39
@sultanwebdev Did you test my previous answer?
Level 1
@sr57 thanks bro solve
Level 102
I hope this code is just for learning php as I could drop your database very easy using your code as it is now
Level 39
@Sinnbeck Only if the app is on line :-)
Level 102
@sr57 of course :). I meant, I hope this won't be used in production
Level 39
@Sinnbeck I understood, at the end @sultanwebdev should understand that it's better to use Laravel ...
Level 1
@sr57 laravel easy to to work Bro? or plan PHP?
Level 102
@sultanwebdev learning php is an excellent idea but laravel is without a doubt the best php framework that exists and there are tons of tutorials
Level 102
@sr57 agreed. Or at least pdo with bound parameters. https://xkcd.com/327/
Level 1
@Sinnbeck okay bro thanks
Level 39
@sultanwebdev Ok the code works but did you understand last messages from @sinnbeck ?
Level 1
@sr57 production iam not use this database right>
Level 39
@sultanwebdev No pb with your db, but with your code.
https://laravel.com/docs/8.x/queries#introduction
The Laravel query builder uses PDO parameter binding to protect your application against SQL injection attacks.
Level 1
@sr57 okay bro thanks
Please or to participate in this conversation.