mysql - Simple Register Form in php -

mysql - Simple Register Form in php -

i'm trying write login/register system, got login downwards need help registration

could not come in data: have error in sql syntax; check manual corresponds mysql server version right syntax utilize near '' @ line 1

my written code

<?php $dbhost = ''; $dbuser = ''; $dbpass = ''; $conn = mysql_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('could not connect: ' . mysql_error()); } $sql = 'insert members '. '(id,username,password) '. 'values ( 2, test, test'; mysql_select_db(''); $retval = mysql_query( $sql, $conn ); if(! $retval ) { die('could not come in data: ' . mysql_error()); } echo "registered\n"; mysql_close($conn); ?>

also need checker see if username taken , assign id, going whats in db, db table called members, within table id(ascending number(currently @ 1)) username, password.

i don't need password encrypted, have in place elsewhere.

try :

// first check if username exist or not $rows = "select * members username='" . $_post['username'] . "'"; $chk = mysql_query($rows); if (mysql_num_rows($chk) >= 1) { $userexist = "* user exist"; die(); // if not exist add together db } else { $sql = "insert members (id,username,password) values ( 2, '" . $_post['username'] . "', '" . $_post['password'] . "')"; $result = mysql_query($sql,$conn); }

php mysql