PHP Snippets
Name:MySQL Match
Description: This will check your MySQL database for possible match, useful if you dont want two or more of same value on your database like an email address.
Code below...
>
<?php
//Value you want to check
$something = "item";
//Connect to your database
$db = mysql_connect("localhost","username","pass");
//Select Database
mysql_select_db("database") or die("Cannot connect to database");
//Select table
$check = mysql_query("SELECT field FROM table WHERE field='$something'");
//Check for any rows
$check = mysql_num_rows($check);
if ($check > 0) {
echo "This item already exist";
}
mysql_close($db);
?>
//Value you want to check
$something = "item";
//Connect to your database
$db = mysql_connect("localhost","username","pass");
//Select Database
mysql_select_db("database") or die("Cannot connect to database");
//Select table
$check = mysql_query("SELECT field FROM table WHERE field='$something'");
//Check for any rows
$check = mysql_num_rows($check);
if ($check > 0) {
echo "This item already exist";
}
mysql_close($db);
?>
