Created
June 2, 2018 04:20
-
-
Save yondonjamts1/bcbf693a5864290cd7ad9cafa9d46290 to your computer and use it in GitHub Desktop.
lol sux AF
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!-- daalgavar 1 --> | |
| <?php | |
| //DBMS - tei xolbogdox uildel | |
| $connect = mysqli_connect("localhost", "root", ""); | |
| //Database uusgex | |
| $sql = "CREATE DATABASE trans"; | |
| //$sql var - d xadgalagdsan query - g ajilluulax | |
| mysqli_query($connect, $sql); | |
| //Database - iin neriig todorxoilj ugux, tsaashid PHP code tuxain database - tei xaritsax | |
| $dbname = "trans"; | |
| //bus nertei table uusgex | |
| $sql1 = "CREATE TABLE bus (busNo VARCHAR(7), ownerComp CHAR(20))"; | |
| //$sql1 var - d xadgalagdsan query - g ajilluulax | |
| mysqli_query($connect, $sql1); | |
| //route nertei table uusgex | |
| $sql2 = "CREATE TABLE route (routeNo VARCHAR(10), routeName CHAR(30), chosenDate DATE);"; | |
| //$sql2 var - d xadgalagdsan query - g ajilluulax | |
| mysqli_query($connect, $sql2); | |
| //post - oor orj irex ugugdliig bus xusnegtiin element bolgoj oruulax query duudaj ajilluulax | |
| if(isset($_POST['bus'])){ | |
| $sql3 = "INSERT INTO bus (busNo, ownerComp) | |
| VALUES ('".$_POST["busNo"]."','".$_POST["ownerComp"]."')"; | |
| } | |
| //$sql3 var - d xadgalagdsan query - g ajilluulax | |
| mysqli_query($connect, $sql3); | |
| //post - oor orj irex ugugdliig route xusnegtiin element bolgoj oruulax query duudaj ajilluulax | |
| if(isset($_POST['route'])){ | |
| $sql4 = "INSERT INTO route (routeNo, routeName, chosenDate) | |
| VALUES ('".$_POST["routeNo"]."','".$_POST["routeName"]."','".$_POST["chosenDate"]."')"; | |
| } | |
| //$sql4 var - d xadgalagdsan query - g ajilluulax | |
| mysqli_query($connect, $sql3); | |
| ?> | |
| <!-- daalgavar 2 --> | |
| <?php | |
| //DBMS-tei xolbogdoj trans Database-iig songoj route xusnegtees | |
| //routeName - uudiig shuuj avch delgetslex uildeluud | |
| $connect = mysqli_connect("localhost", "root", ""); | |
| $dbname = "trans"; | |
| $sql = "SELECT routeName from route"; | |
| $result = mysqli_query($connect, $sql); | |
| var_dump($results); | |
| ?> | |
| <!-- daalgavar 3 --> | |
| <?php | |
| ?> | |
| <!-- daalgavar 4 --> | |
| <?php | |
| //DBMS-tei xolbogdoj trans Database-iig songoj route xusnegtees | |
| //xamgiin suuld songoson routeNumber - iig cookie - d xadgalax uildeluud | |
| $connect = mysqli_connect("localhost", "root", ""); | |
| $dbname = "trans"; | |
| $sql = "SELECT routeNo from route WHERE route.chosenDate IN (SELECT chosenDate from route ORDER BY DESC LIMIT 1);" | |
| $results = mysql_query($connect,$sql) | |
| $temp = var_dump($results) | |
| setcookie("routeNo",$temp); | |
| ?> | |
| <!-- daalgavar 5 --> | |
| <?php | |
| ?> | |
| <!-- daalgavar 6 --> | |
| <?php | |
| ?> | |
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <title> | |
| Web programming mid-term test by Yondonjamts_14B1SEAS3732 | |
| </title> | |
| </head> | |
| <body> | |
| <!-- bus table - d garaas utga avax post method ashiglasan form --> | |
| <form method="post"> | |
| <label> Bus Number</label><br/> | |
| <input type="text" name="busNo"><br/> | |
| <label>Owner Company Name</label><br/> | |
| <input type="text" name="ownerComp"><br/> | |
| <button type="submit" name="bus">submit</button> | |
| </form><br><br><br> | |
| <!-- route table - d garaas utga avax post method ashiglasan form --> | |
| <form method="post"> | |
| <label> Route Number</label><br/> | |
| <input type="text" name="routeNo"><br/> | |
| <label>Route Name</label><br/> | |
| <input type="text" name="routeName"><br/> | |
| <label>Chosen Date</label><br/> | |
| <input type="text" name="chosenDate"><br/> | |
| <button type="submit" name="route">submit</button> | |
| </form> | |
| </body> | |
| </html> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment