Check before inserting in DB ???

Posted on 16th Feb 2014 07:03 pm by admin

This is my code
---------------
if ( $_POST ['Submit'])
{{
$username = $_POST ['usernm'];
$userpassword = $_POST ['userpw'];
}
/*insert data from the form into the db table*/

$querypost = mysql_query ("INSERT INTO users (usernm, userpw) VALUES ('$username','$userpassword')");
}
?>

How do I check before inserting whether that username and password is already inserted. I have an id assigned to every entry.

Your Answer:

Login to answer

Other forums

Getting number of affected rows in SQLPLUS..
Hi everyone,
I have a shell script where i am invoking sqlplus, running a query and saving t

Remove directories not empty
hi,
i have an array that contains some names (1,4,6,56...). Every integer is a name of a folder.<

Kill a process
I have a question - how can I kill a process from a command line or by using Oracle SQL Developer? I

PHP Upload issue
Hi guys,

I have stumble across an interesting issue with my script and is doing my head in.

javascript in php code causes page to display white
Hi All,

Odd one this, I've got the following code (below) which is a simple log in form. The

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

How to display random record from table?
I have the following code:

Code: <?php
$display_block .= "<input type=

Advice on how to delete a mysql row using my form
Hi,

I am very new to php and am struggling to work out how to delete a portfolio item (a row

Pagination
Hi All,

I think I'm finally getting somewhere with pagination!

I can now submit a quer

PHP form authentication
Hi guys,

what am trying to achieve is this: Whenever a user tries to login to my website, an