php - I can't define my error -
parse error: syntax error, unexpected end of file in c:\program files (x86)\easyphp-devserver-14.1vc11\data\localweb\ass1re\create database.php on line 166. can't define problem. checked 1 one can't find. sorry asking
<html> <head> </head> <body> <form action="first.php" method="post"> first name: <input type="text" name="fname"> second name: <input type="text" name="sname"> address : <input type="text" name="add"> country/region : <input type="text" name="country"> gender : <input type="radio" name="gender" value="male" checked>male <input type="radio" name="gender" value="female" checked>female ic/no : <input type="text" name="ic"> email : <input type="text" name="email"><br/> period : <input type="text" id="period" name="period"> <select name="" onchange="combo(this,'period')"> <option>4 days 3 night</option> <option>5 days 4 night</option> <option>6 days 5 night</option> </select> place : <input type="text" id="place" name="place"> <select name="" onchange="combo(this,'place')"> <option>london</option> <option>bali</option> <option>kuala lumpur</option> </select> room :<input type="text" id="room" name="room"> <select name="" onchange="combo(this,'room')"> <option>first class</option> <option>premium class</option> </select> if (period ="4 days 3 night") { if (place ="london"){ if(room="first class"){ <name="price" value="4500"> }elseif (room="premium class"){ <name="price" value="3500"> } }elseif(place ="bali") { if(room="first class"){ <name="price" value="3500"> }elseif (room="premium class"){ <name="price" value="2500"> } } }elseif(place ="kuala lumpur"){ if(room="first class"){ <name="price" value="1500"> }elseif (room="premium class"){ <name="price" value="1500"> } } } } if (period ="5 days 4 night") { if (place ="london"){ if(room="first class"){ <name="price" value="5500"> }elseif (room="premium class"){ <name="price" value="4500"> } }elseif(place ="bali") { if(room="first class"){ <name="price" value="4000"> }elseif (room="premium class"){ <name="price" value="3500"> } } }elseif(place ="kuala lumpur"){ if(room="first class"){ <name="price" value="2000"> }elseif (room="premium class"){ <name="price" value="1000"> } } } } if (period ="6 days 5 night") { if (place ="london"){ if(room="first class"){ <name="price" value="7500"> }elseif (room="premium class"){ <name="price" value="6000"> } }elseif(place ="bali") { if(room="first class"){ <name="price" value="5500"> }elseif (room="premium class"){ <name="price" value="4000"> } } }elseif(place ="kuala lumpur"){ if(room="first class"){ <name="price" value="3500"> }elseif (room="premium class"){ <name="price" value="2000"> } } } } <input type="submit" name="submit"> </form> <?php if (isset($_post['submit'])) { $con = mysqli_connect('localhost','root',''); if (!$con){ die("can not connected:" . mysql_error()); } if (mysqli_query($con,'create database booking')){ }else echo "error: " . mysql_error(); mysql_select_db($con,"booking"); $sql = 'create table book ( firstname varchar(20), secondnamee varchar(20), address varchar(20), gnder varchar(10), icno int, region varchar(20), e-mail varchar (20), day varchar (20), rmm varchar (20), plce varchar (20), prce int )'; if(mysqli_query($sql,$con)){ }else { echo"error creating table : " . mysqli_error($con); } $sql1 = "insert book(firstname,secondnamee,address,gnder,icno,region,e-mail,day,rmm,plce,prce) values('$_post(fname)','$_post(sname)','$_post(add)','$_post(email)','$_post(ic)','$_post(country)','$_post(room)','$_post(place)','$_post(period)','$_post(gender)','$_post(price)')"; mysqli_query($sql1,$con); mysqli_close($con); ?> </body> </html>
in part of code
if (isset($_post['submit'])) { $con = mysqli_connect('localhost','root',''); if (!$con){ die("can not connected:" . mysql_error()); } if (mysqli_query($con,'create database booking')){ }else echo "error: " . mysql_error(); mysql_select_db($con,"booking"); $sql = 'create table book (
i thing forgot closing }
of if (isset($_post['submit']))
Comments
Post a Comment