<html> <?php include 'header.php'; ?> <body> <form method="post" action="add_customer.php"> Name: <input type="text" name="name" value="" required><br> Surname: <input type="text" name="surname" value="" required><br> Contact: <input type="text" name="contact_number" value="" required><br> E-mail: <input type="text" name="email" value="" required><br> RSA ID: <input type="text" name="sa_id_number" value=""><br> Address: <input type="text" name="address" value="" required><br> <input type="submit"> </form> <?php $dbconn = new mysql_database(); if (!empty($_POST)) { $name = $_POST["name"]; $surname = $_POST["surname"]; $contact_number = $_POST["contact_number"]; $email = $_POST["email"]; $sa_id_number = $_POST["sa_id_number"]; $address = $_POST["address"]; $sql = "INSERT INTO customer (name, surname, contact_number, email, sa_id_number, address) \n\t\tvalues ('" . $name . "', '" . $surname . "', '" . $contact_number . "', '" . $email . "', '" . $sa_id_number . "', '" . $address . "')"; $result = $dbconn->insert($sql); echo $result; } ?> <form action="customer.php" method="post"><input type="submit" value="Return"></form> </body>
?> </td></tr> </table> <form method="post" action="add_order.php"> <label>Add new Order</label><br> Customer ID: <input type="text" name="customer_id" value="" required><br> DVD ID: <input type="text" name="dvd" value="" required><br> <input type="submit"> </form> <!-- need to add an dvd_order for every dvd added--> <?php $dbconn = new mysql_database(); if (!empty($_POST)) { //print_r($_POST); $customer_id = $_POST["customer_id"]; $dvd_id_array = $_POST["dvd"]; $sql = "INSERT INTO orders (customer_id, rent_date, due_date, actual_return_date) \n\t\tvalues ('" . $customer_id . "', curdate(), adddate(curdate(),2) , '' )"; $result = $dbconn->insert_order($sql); $dvd_id_array = explode(",", $dvd_id_array); foreach ($dvd_id_array as $key => $dvd_id) { $sql = "insert into dvd_orders (dvd_id, order_id) values ('" . $dvd_id . "', '" . $result . "')"; $result = $dbconn->insert_order($sql); } } ?> <form action="order.php" method="post"><input type="submit" value="Return"></form> </body>
<html> <?php include 'header.php'; ?> <body> <?php $dbconn = new mysql_database(); if (!empty($_GET)) { $ID = $_GET["order_id"]; $sql = "DELETE FROM orders WHERE orders_ID=" . $ID . ""; $result = $dbconn->delete_order($sql); echo $result; } ?> <form action="order.php" method="post"><input type="submit" value="Return"></form> </body> </html>
<html> <?php include 'header.php'; ?> <body> <table> <tr><td>ID</td> <td>Name</td> <td>Description</td> <td>Release Date</td> <td>Category name</td></tr> <?php $dbconn = new mysql_database(); $result = $dbconn->fetch("select * from dvd inner join category on category.Category_ID=dvd.category_id"); if ($result->num_rows > 0) { // output data of each row while ($row = $result->fetch_assoc()) { echo "<tr>" . "<td>" . $row["ID"] . "</td>" . "<td>" . $row["name"] . "</td>" . "<td>" . $row["description"] . "</td>" . "<td>" . $row["release_date"] . "</td>" . "<td>" . $row["category_name"] . "</td>" . "<td><form action=edit_dvd.php?ID='" . $row["ID"] . "' method='post'><input type='submit' value=edit></form></td>" . "<td><form action=delete_dvd.php?dvd_id='" . $row["ID"] . "' method='post'><input type='submit' value='delete'></form></td>"; } } ?> </td></tr> </table> <form action="add_dvd.php" method="post"><input type="submit" value="Add DVD"></form> </body> </html>
<?php include_once 'mysql_database.php'; $title = isset($_POST['title']) ? $_POST['title'] : ''; $author = isset($_POST['author']) ? $_POST['author'] : ''; $statement = isset($_POST['statement']) ? $_POST['statement'] : ''; $explanation = isset($_POST['explanation']) ? $_POST['explanation'] : ''; $solution_code = isset($_POST['solution_code']) ? $_POST['solution_code'] : ''; $category = isset($_POST['category']) ? $_POST['category'] : ''; $title = htmlspecialchars($title); $author = htmlspecialchars($author); $statement = htmlspecialchars($statement); $explanation = htmlspecialchars($explanation); $solution_code = htmlspecialchars($solution_code); $category = htmlspecialchars($category); $mysql = new mysql_database(); $mysql->connect_mysql(); $mysql->insert_table_solved_problems_mysql($title, $author, $statement, $explanation, $solution_code, $category); $mysql->disconnect_mysql();
<html> <?php include 'header.php'; ?> <?php $dbconn = new mysql_database(); if (!empty($_POST) && !empty($_GET)) { $ID = $_GET["ID"]; $name = $_POST["name"]; $surname = $_POST["surname"]; $contact_number = $_POST["contact_number"]; $email = $_POST["email"]; $sa_id_number = $_POST["sa_id_number"]; $address = $_POST["address"]; $sql = "UPDATE customer SET name='" . $name . "', surname='" . $surname . "', contact_number='" . $contact_number . "', email='" . $email . "', sa_id_number='" . $sa_id_number . "', address='" . $address . "' WHERE id='" . $ID . "'"; $result = $dbconn->update($sql); echo $result; } ?> <form action="customer.php" method="post"><input type="submit" value="Return"></form> </body> </html>
$dbconn = new mysql_database(); $result = $dbconn->fetch("select * from orders where orders_ID=" . $id . ""); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { echo '<form method="post" action="edit_order.php?order_id=' . $row["orders_ID"] . '"> Rental Date: <input type="text" name="rent_date" value="' . $row["rent_date"] . '" required><br> Due Date: <input type="text" name="due_date" value="' . $row["due_date"] . '" required><br> Return Date: <input type="text" name="actual_return_date" value="' . $row["actual_return_date"] . '" required><br> Customer ID: <input type="text" name="customer_id" value="' . $row["customer_id"] . '" required><br> <input type="submit"> </form>'; } } } else { //echo "<p>not clicked"; } $dbconn = new mysql_database(); if (!empty($_POST) && !empty($_GET)) { $orders_ID = $_GET["order_id"]; $rent_date = $_POST["rent_date"]; $due_date = $_POST["due_date"]; $actual_return_date = $_POST["actual_return_date"]; $customer_id = $_POST["customer_id"]; $sql = "UPDATE orders SET rent_date='" . $rent_date . "', due_date='" . $due_date . "', due_date='" . $due_date . "', actual_return_date='" . $actual_return_date . "' WHERE orders_ID='" . $orders_ID . "'"; $result = $dbconn->update_order($sql); echo $result; } ?> <form action="order.php" method="post"><input type="submit" value="Return"></form> </body> </html>
<html> <?php include 'header.php'; ?> <body> <?php if (!empty($_GET)) { $ID = $_GET["ID"]; $dbconn = new mysql_database(); $id = octdec($ID); $result = $dbconn->fetch("SELECT * FROM dvd where ID={$id}"); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { echo '<form method="post" action="edit_dvd.php?ID=' . $row["ID"] . '"> Name: <input type="text" name="name" value="' . $row["name"] . '" required><br> Description: <textarea name="description" value required>"' . $row["description"] . '"</textarea><br> Release Date: <input type="text" name="release_date" value="' . $row["release_date"] . '" required><br> Category ID: <input type="text" name="category_id" value="' . $row["category_id"] . '" required><br> <input type="submit"> </form>'; } } } else { //echo "<p>not clicked"; } if (!empty($_POST) && !empty($_GET)) { $ID = $_GET["ID"]; $name = $_POST["name"]; $description = $_POST["description"]; $release_date = $_POST["release_date"]; $category_id = $_POST["category_id"];
<?php include_once 'mysql_database.php'; $category = isset($_GET['category']) ? $_GET['category'] : ''; $mysql = new mysql_database(); $mysql->connect_mysql(); $mysql->show_solved_problems($category); $mysql->disconnect_mysql();
require_once $base['dir'] . 'data/config.php'; require_once $base['dir'] . 'source/core.func.php'; require_once $base['dir'] . 'source/mysqldb.class.php'; $base['post'] = paddslashes($_POST); $base['get'] = paddslashes($_GET); $base['cookie'] = paddslashes($_COOKIE); unset($_POST); unset($_GET); unset($_COOKIE); $langset = $base['cookie']['lang'] ? $base['cookie']['lang'] : $config['lang']; require_once $base['dir'] . 'lang/langset.php'; $langset = in_array($langset, array_keys($all_lang)) ? $langset : $base['cookie']['lang']; require_once $base['dir'] . 'lang/' . $langset . '/all.lang.php'; $base['lang'] = $lang; unset($lang); $base['config'] = $config; unset($config); $db = new mysql_database(); if (!$db->connect($base['config']['db'])) { error_report($base['lang']['db_connect_error']); } if ($base['get']['mod'] == '') { $base['get']['mod'] = 'index'; } if (!empty($_FILES)) { $base['get']['mod'] = 'upload'; } if (!in_array($base['get']['mod'], array('index', 'upload', 'show', 'admin'))) { error_report(str_replace('\\1', '<code>' . htmlspecialchars($base['get']['mod']) . '</code>', $base['lang']['mod_not_found'])); } require_once $base['dir'] . 'source/' . $base['get']['mod'] . '.mod.php';
<html> <?php include 'header.php'; ?> <body> <form method="post" action="add_dvd.php"> <label>Add new DVD</label><br> Name: <input type="text" name="name" value="" required><br> Description: <textarea name="description" value="" required></textarea><br> Release Date: <input type="text" name="release_date" value="" required><br> Category ID: <input type="text" name="category_id" value="" required><br> <input type="submit"> </form> <?php $dbconn = new mysql_database(); if (!empty($_POST)) { $name = $_POST["name"]; $description = $_POST["description"]; $release_date = $_POST["release_date"]; $category_id = $_POST["category_id"]; $sql = "INSERT INTO dvd (name, description, release_date, category_id) \n values ('" . $name . "', '{$description}', '" . $release_date . "', '" . $category_id . "')"; $result = $dbconn->insert_dvd($sql); echo $result; } ?> <form action="dvd.php" method="post"><input type="submit" value="Return"></form> </body> </html>
<?php include_once 'mysql_database.php'; include_once 'short_url.php'; $db = new mysql_database(); $url = new short_url(); $user_short_url = isset($_GET['short_code']) ? $_GET['short_code'] : ''; //take the $short_code from the url using the .htaccess file $db->connect(); $url->selectUrl($user_short_url); $db->close();
<?php include 'header.php'; ?> <body> <form action="add_order.php" method="post"><input type="submit" value="Add order"></form> <table> <tr><td>Order ID</td> <td>Customer ID</td> <td>Rental Date</td> <td>Return Date</td> <td>Actions</td></tr> <?php $dbconn = new mysql_database(); $result = $dbconn->fetch("SELECT * FROM orders INNER JOIN customer on customer.ID=orders.customer_id ORDER BY orders_ID DESC"); if ($result->num_rows > 0) { // output data of each row while ($row = $result->fetch_assoc()) { echo "<tr>" . "<td>" . $row["orders_ID"] . "</td>" . "<td>" . $row["ID"] . "</td>" . "<td>" . $row["rent_date"] . "</td>" . "<td>" . $row["actual_return_date"] . "</td>" . "<td><form action='edit_order.php?order_id=" . $row["orders_ID"] . "' method='post'><input type='submit' value='edit'></form></td>" . "<td><form action='delete_order.php?order_id=" . $row["orders_ID"] . "' method='post'><input type='submit' value='delete'></form></td>"; } } ?> </td></tr> </table> </body>
echo $row["category_name"]; ?> </td> <td><?php echo $row["Category_ID"]; ?> </td> <td><form action="delete_category.php?ID=<?php echo $row["Category_ID"]; ?> " method="post"><input type="submit" value="delete"></form></td></tr> <?php } } ?> <form method="post"> Category name: <input type="text" name="name" value="" required><br> <input type="submit"> </form> <?php $dbconn = new mysql_database(); if (!empty($_POST)) { $name = $_POST["name"]; $sql = "INSERT INTO category (category_name) values ('" . $name . "')"; $result = $dbconn->insert_category($sql); echo $result; } ?> <form action="index.php" method="post"><input type="submit" value="Return"></form> </body>
<html> <?php include 'header.php'; ?> <body <?php $dbconn = new mysql_database(); if (!empty($_GET)) { $ID = $_GET["ID"]; echo $ID; $sql = 'DELETE FROM customer WHERE ID=' . $ID . ''; $result = $dbconn->delete($sql); echo $result; } ?> <form action="customer.php" method="post"><input type="submit" value="Return"></form> </body> </html>
<html> <?php include 'header.php'; ?> <body> <?php $dbconn = new mysql_database(); if (!empty($_GET)) { $ID = $_GET["dvd_id"]; $sql = 'DELETE FROM dvd WHERE ID=' . $ID . ''; $result = $dbconn->delete_dvd($sql); echo $result; } ?> <form action="dvd.php" method="post"><input type="submit" value="Return"></form> </body> </html>
<?php include_once 'mysql_database.php'; $category = isset($_GET['category']) ? $_GET['category'] : ''; $title = isset($_GET['title']) ? $_GET['title'] : ''; $mysql = new mysql_database(); $mysql->connect_mysql(); $mysql->show_solution_problem($category, $title); $mysql->disconnect_mysql();
<html> <?php include 'header.php'; ?> <body> <table> <tr><td>ID</td> <td>Name</td> <td>Surname</td> <td>Contact Number</td> <td>Email</td> <td>SA ID Number</td> <td>Address</td> <td>Actions</td></tr> <?php $dbconn = new mysql_database(); $result = $dbconn->fetch("select * from customer"); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { ?> <tr><td><?php echo $row["ID"]; ?> </td> <td><?php echo $row["name"]; ?> </td> <td><?php echo $row["surname"]; ?>