php - If made a login page for Mysql but it gives Parse error -



php - If made a login page for Mysql but it gives Parse error -

i made database called login table called users. says parse error, line 68

here's code:

<?php $host ='localhost'; $user = 'root'; $pass ='' ; $db = 'login'; mysql_connect($host, $user, $pass); mysql_select_db($db); if(isset($_post ['username'])) { $username = $_post['username']; $password = $_post['password']; $sql = "select * users username='".$username."' , password='".$password."' limit 1"; $res = mysql_query($sql); if (mysql_num_rows($res) == 1) { echo "you logged in"; exit(); } else { echo "password or username wrong. please seek again"; exit(); } ?> <html> <head> <title> login </title> </head> <body> <form method='post' action='login.php'> <input type='text' name='username' value="" /> <input type='password' name='password' value=''/> <input type='submit' name='submit ' value='log in' / > </form> <?php $username = "theasher"; $password = "theasher"; $hostname = "localhost"; //connection database $dbhandle = mysql_connect($hostname, $username, $password) or die("unable connect mysql"); echo "connected mysql<br>"; ?> </body> </html>

you not close if (isset($_post ['username'])) { status }

<?php $host = 'localhost'; $user = 'root'; $pass = ''; $db = 'login'; mysql_connect($host, $user, $pass); mysql_select_db($db); if (isset($_post ['username'])) { $username = $_post['username']; $password = $_post['password']; $sql = "select * users username='" . $username . "' , password='" . $password . "' limit 1"; $res = mysql_query($sql); if (mysql_num_rows($res) == 1) { echo "you logged in"; exit(); } else { echo "password or username wrong. please seek again"; exit(); } } ?> <html> <head> <title> login </title> </head> <body> <form method='post' action='login.php'> <input type='text' name='username' value="" /> <input type='password' name='password' value=''/> <input type='submit' name='submit ' value='log in' / > </form> <?php $username = "theasher"; $password = "theasher"; $hostname = "localhost"; //connection database $dbhandle = mysql_connect($hostname, $username, $password) or die("unable connect mysql"); echo "connected mysql<br>"; ?> </body> </html>

php mysql login

Comments

Post a Comment

Popular posts from this blog

c - Compilation of a code: unkown type name string -

c - Compilation of a code: unkown type name string - i have next lines of code compiler says following: "unknown type name 'string'" both in declaration , definition of function. can tell me what's wrong? thanks. #include <stdio.h> #include <stdlib.h> #include <string.h> void frecognizeclient(string *actualclient) there no string type in c. need utilize array so: char array[10]; then can pass in function: void frecognizeclient(char *actualclient); c arrays string compilation
Read more

ubuntu - Bash Script to Check That Files Are Being Created -

ubuntu - Bash Script to Check That Files Are Being Created - we have amazon ec2 instance upload output our security cameras. every , then, cameras have issue, stop uploaded, , need rebooted. easy way determine seeing if files not beingness created. problem creates lots , lots of files. if utilize find -ctime, takes long time script run. there faster way check see if files have been created since yesterday? need capture result, (yes there files, or not there not,) , email message, nice have didn't take half hr run. #!/bin/bash find /vol/security_ftp/west -ctime -1 find /vol/security_ftp/backentrance -ctime -1 find /vol/security_ftp/boardroomdoor -ctime -1 find /vol/security_ftp/mainentrance -ctime -1 find /vol/security_ftp/north -ctime -1 find /vol/security_ftp/south -ctime -1 using find natural solution, if must avoid it, can see newest file in directory using ls , sorting output according ctime, eg. ls /vol/security_ftp/west -clt | head --lines=1 ...
Read more

Php operator `break` doesn't stop while -

Php operator `break` doesn't stop while - have weird issue, break doesn't break while loop , maintain rotating. logically should break cycle , set output while ($c++ != 5) { // here curl request, doesn't relevant have removed preg_match("!<.*?>(\s*)[^<>]*?{$to}<!", $resp, $result) ; // echo 'cnt = ' .count($result).'<br>'; if(!count($result)) { $amount = 0; echo 'sleep called'; sleep(4); exit; continue; } else { $amount = trim(@$result[1]); $amount = round($amount + $amount * $exchange_ratio, $precision); echo 'break happen<br>'; break; } } so output cnt = 2 break happen cnt = 0 sleep called so skipped break , maintain rotating. how so? edit works fine on localhost issue php version? ...
Read more