Learning Web Design is Our Goal
The Federal Civil Service Commission (FCSC) is currently recruiting for the year 2019. FCSC seeks brave and smart young Nigerians, willing to serve the country in the field of promoting and protecting Nigeria’s security interests at home and abroad, in very challenging circumstances. Their routine includes executing tasks solely for the protection and promotion of […]
Superintendent Cadre – ASC II (Support Staff) – CONSOL 08 GENERAL REQUIREMENTS Be a Nigerian Citizen by birth or descent Applicants must be between the ages of 18-30 years Not be less than 1.7 metres in height, for male and 1.64 metres for female. Have a fully expanded chest measurement of not less than 0.87 […]
Remember me function is used to save the username and password in login form entered by the user. In this tutorial we are using COOKIES for saving preserving username and user password in the login from. Step 1 : Create a simple html form
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
<div align="center"> <form action="" method="post" id="login"> <div class="error-message"><?php if(isset($message)) { echo $message; } ?></div> <h4> PHP login with remember me function</h4> <div class="field-group"> <div><label for="login">Username</label></div> <div> <input name="username" type="text" value="<?php if(isset($_COOKIE["user_login"])) { echo $_COOKIE["user_login"]; } ?>" class="input-field"> </div> <div class="field-group"> <div><label for="password">Password</label></div> <div><input name="password" type="password" value="<?php if(isset($_COOKIE["userpassword"])) { echo $_COOKIE["userpassword"]; } ?>" class="input-field"> </div> <div class="field-group"> <div><input type="checkbox" name="remember" id="remember" <?php if(isset($_COOKIE["user_login"])) { ?> checked <?php } ?> /> <label for="remember-me">Remember me</label> </div> <div class="field-group"> <div><input type="submit" name="login" value="Login" class="form-submit-button"></span></div> </div> </form> </div> |
Step 2 : Create a SQL table tbluser
|
1 2 3 4 5 6 7 |
CREATE TABLE `tbluser` ( `id` int(11) NOT NULL, `userName` varchar(200) DEFAULT NULL, `userPassword` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ALTER TABLE `tbluser` ADD PRIMARY KEY (`id`); |
Step 3 : Create database configuration […]
Quality Assurance Auditor Location(s): • Oyo, South West — Nigeria Specialization: • Analyst/ Quality Control Industry: • Trade / Services Application Deadline: March 28, 2019 Job Type Fulltime British American Tobacco is all about freedom of choice – whether it’s our people or our products. Combined with our entrepreneurial spirit, it’s what’s driven our phenomenal […]
APPLICATION GUIDELINE 1. Click on the ‘START APPLICATION’ button on the bottom of this page. 2. You would be transferred to the Bio-Data page where you are required to fill in your personal details. 3. When completing the Bio-Data page ensure that your MOBILE NUMBER and EMAIL address are accurate, functional and accessible to you as your UserID and Password would be sent […]
Guidelines on how to apply Follow this step by step guide to a successful application: Log on to https://careers.nnpcgroup.com Select Graduate Trainees or Experienced Hires Graduate Trainees are applicants that are not more than 28 years of age graduated not earlier than 2014 have a Bachelors Degree in either of the following categories: First Class, Second Class […]
Project Name : Employee Record Management System (ERMS) Language Used : PHP Database : My SQL User Interface Design : HTML, AJAX,JQUERY,JAVASCRIPT Web Browser : Mozilla, Google Chrome, IE8,OPERA Software : XAMPP / Wamp / Mamp/ Lamp (any one) Employee […]
There are multiple pages that makes up this simple project First the: CSS style.css
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 |
* { margin: 0px; padding: 0px; } body { font-size: 120%; background: #F8F8FF; } .header { width: 40%; margin: 50px auto 0px; color: white; background: #5F9EA0; text-align: center; border: 1px solid #B0C4DE; border-bottom: none; border-radius: 10px 10px 0px 0px; padding: 20px; } form, .content { width: 40%; margin: 0px auto; padding: 20px; border: 1px solid #B0C4DE; background: white; border-radius: 0px 0px 10px 10px; } .input-group { margin: 10px 0px 10px 0px; } .input-group label { display: block; text-align: left; margin: 3px; } .input-group input { height: 30px; width: 93%; padding: 5px 10px; font-size: 16px; border-radius: 5px; border: 1px solid gray; } #user_type { height: 40px; width: 98%; padding: 5px 10px; background: white; font-size: 16px; border-radius: 5px; border: 1px solid gray; } .btn { padding: 10px; font-size: 15px; color: white; background: #5F9EA0; border: none; border-radius: 5px; } .error { width: 92%; margin: 0px auto; padding: 10px; border: 1px solid #a94442; color: #a94442; background: #f2dede; border-radius: 5px; text-align: left; } .success { color: #3c763d; background: #dff0d8; border: 1px solid #3c763d; margin-bottom: 20px; } .profile_info img { display: inline-block; width: 50px; height: 50px; margin: 5px; float: left; } .profile_info div { display: inline-block; margin: 5px; } .profile_info:after { content: ""; display: block; clear: both; } |
Function function.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 |
<?php session_start(); // connect to database $db = mysqli_connect('localhost', 'root', '', 'multi_login'); // variable declaration $username = ""; $email = ""; $errors = array(); // call the register() function if register_btn is clicked if (isset($_POST['register_btn'])) { register(); } // call the login() function if register_btn is clicked if (isset($_POST['login_btn'])) { login(); } if (isset($_GET['logout'])) { session_destroy(); unset($_SESSION['user']); header("location: ../login.php"); } // REGISTER USER function register(){ global $db, $errors; // receive all input values from the form $username = e($_POST['username']); $email = e($_POST['email']); $password_1 = e($_POST['password_1']); $password_2 = e($_POST['password_2']); // form validation: ensure that the form is correctly filled if (empty($username)) { array_push($errors, "Username is required"); } if (empty($email)) { array_push($errors, "Email is required"); } if (empty($password_1)) { array_push($errors, "Password is required"); } if ($password_1 != $password_2) { array_push($errors, "The two passwords do not match"); } // register user if there are no errors in the form if (count($errors) == 0) { $password = md5($password_1);//encrypt the password before saving in the database if (isset($_POST['user_type'])) { $user_type = e($_POST['user_type']); $query = "INSERT INTO users (username, email, user_type, password) VALUES('$username', '$email', '$user_type', '$password')"; mysqli_query($db, $query); $_SESSION['success'] = "New user successfully created!!"; header('location: home.php'); }else{ $query = "INSERT INTO users (username, email, user_type, password) VALUES('$username', '$email', 'user', '$password')"; mysqli_query($db, $query); // get id of the created user $logged_in_user_id = mysqli_insert_id($db); $_SESSION['user'] = getUserById($logged_in_user_id); // put logged in user in session $_SESSION['success'] = "You are now logged in"; header('location: index.php'); } } } // return user array from their id function getUserById($id){ global $db; $query = "SELECT * FROM users WHERE id=" . $id; $result = mysqli_query($db, $query); $user = mysqli_fetch_assoc($result); return $user; } // LOGIN USER function login(){ global $db, $username, $errors; // grap form values $username = e($_POST['username']); $password = e($_POST['password']); // make sure form is filled properly if (empty($username)) { array_push($errors, "Username is required"); } if (empty($password)) { array_push($errors, "Password is required"); } // attempt login if no errors on form if (count($errors) == 0) { $password = md5($password); $query = "SELECT * FROM users WHERE username='$username' AND password='$password' LIMIT 1"; $results = mysqli_query($db, $query); if (mysqli_num_rows($results) == 1) { // user found // check if user is admin or user $logged_in_user = mysqli_fetch_assoc($results); if ($logged_in_user['user_type'] == 'admin') { $_SESSION['user'] = $logged_in_user; $_SESSION['success'] = "You are now logged in"; header('location: admin/home.php'); }else{ $_SESSION['user'] = $logged_in_user; $_SESSION['success'] = "You are now logged in"; header('location: index.php'); } }else { array_push($errors, "Wrong username/password combination"); } } } function isLoggedIn() { if (isset($_SESSION['user'])) { return true; }else{ return false; } } function isAdmin() { if (isset($_SESSION['user']) && $_SESSION['user']['user_type'] == 'admin' ) { return true; }else{ return false; } } // escape string function e($val){ global $db; return mysqli_real_escape_string($db, trim($val)); } function display_error() { global $errors; if (count($errors) > 0){ echo '<div class="error">'; foreach ($errors as $error){ echo $error .'<br>'; } echo '</div>'; } } ?> |
Index/home Page is next index.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 |
<?php include('functions.php'); if (!isLoggedIn()) { $_SESSION['msg'] = "You must log in first"; header('location: login.php'); } ?> <!DOCTYPE html> <html> <head> <title>Home</title> <link rel="stylesheet" type="text/css" href="style.css"> </head> <body> <div class="header"> <h2>Home Page</h2> </div> <div class="content"> <!-- notification message --> <?php if (isset($_SESSION['success'])) : ?> <div class="error success" > <h3> <?php echo $_SESSION['success']; unset($_SESSION['success']); ?> </h3> </div> <?php endif ?> <!-- logged in user information --> <div class="profile_info"> <img src="images/user_profile.png" > <div> <?php if (isset($_SESSION['user'])) : ?> <strong><?php echo $_SESSION['user']['username']; ?></strong> <small> <i style="color: #888;">(<?php echo ucfirst($_SESSION['user']['user_type']); ?>)</i> <br> <a href="index.php?logout='1'" style="color: red;">logout</a> </small> <?php endif ?> </div> </div> </div> </body> </html> |
Login Page is next login.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
<?php include('functions.php') ?> <!DOCTYPE html> <html> <head> <title>Registration system PHP and MySQL</title> <link rel="stylesheet" type="text/css" href="style.css"> </head> <body> <div class="header"> <h2>Login</h2> </div> <form method="post" action="login.php"> <?php echo display_error(); ?> <div class="input-group"> <label>Username</label> <input type="text" name="username" > </div> <div class="input-group"> <label>Password</label> <input type="password" name="password"> </div> <div class="input-group"> <button type="submit" class="btn" name="login_btn">Login</button> </div> <p> Not yet a member? <a href="register.php">Sign up</a> </p> </form> </body> </html> |
Registration Page is Next register.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
<?php include('functions.php') ?> <!DOCTYPE html> <html> <head> <title>Registration system PHP and MySQL</title> <link rel="stylesheet" type="text/css" href="style.css"> </head> <body> <div class="header"> <h2>Register</h2> </div> <form method="post" action="register.php"> <?php echo display_error(); ?> <div class="input-group"> <label>Username</label> <input type="text" name="username" value="<?php echo $username; ?>"> </div> <div class="input-group"> <label>Email</label> <input type="email" name="email" value="<?php echo $email; ?>"> </div> <div class="input-group"> <label>Password</label> <input type="password" name="password_1"> </div> <div class="input-group"> <label>Confirm password</label> <input type="password" name="password_2"> </div> <div class="input-group"> <button type="submit" class="btn" name="register_btn">Register</button> </div> <p> Already a member? <a href="login.php">Sign in</a> </p> </form> </body> </html> |
Admin Session Two pages to be created, 1. create_user.php 2. home.php create_user.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
<?php include('../functions.php') ?> <!DOCTYPE html> <html> <head> <title>Registration system PHP and MySQL - Create user</title> <link rel="stylesheet" type="text/css" href="../style.css"> <style> .header { background: #003366; } button[name=register_btn] { background: #003366; } </style> </head> <body> <div class="header"> <h2>Admin - create user</h2> </div> <form method="post" action="create_user.php"> <?php echo display_error(); ?> <div class="input-group"> <label>Username</label> <input type="text" name="username" value="<?php echo $username; ?>"> </div> <div class="input-group"> <label>Email</label> <input type="email" name="email" value="<?php echo $email; ?>"> </div> <div class="input-group"> <label>User type</label> <select name="user_type" id="user_type" > <option value=""></option> <option value="admin">Admin</option> <option value="user">User</option> </select> </div> <div class="input-group"> <label>Password</label> <input type="password" name="password_1"> </div> <div class="input-group"> <label>Confirm password</label> <input type="password" name="password_2"> </div> <div class="input-group"> <button type="submit" class="btn" name="register_btn"> + Create user</button> </div> </form> </body> </html> |
home.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 |
<?php include('../functions.php'); if (!isAdmin()) { $_SESSION['msg'] = "You must log in first"; header('location: ../login.php'); } ?> <!DOCTYPE html> <html> <head> <title>Home</title> <link rel="stylesheet" type="text/css" href="../style.css"> <style> .header { background: #003366; } button[name=register_btn] { background: #003366; } </style> </head> <body> <div class="header"> <h2>Admin - Home Page</h2> </div> <div class="content"> <!-- notification message --> <?php if (isset($_SESSION['success'])) : ?> <div class="error success" > <h3> <?php echo $_SESSION['success']; unset($_SESSION['success']); ?> </h3> </div> <?php endif ?> <!-- logged in user information --> <div class="profile_info"> <img src="../images/admin_profile.png" > <div> <?php if (isset($_SESSION['user'])) : ?> <strong><?php echo $_SESSION['user']['username']; ?></strong> <strong><?php echo $_SESSION['user']['email']; ?></strong> <small> <i style="color: #888;">(<?php echo ucfirst($_SESSION['user']['user_type']); ?>)</i> <br> <a href="home.php?logout='1'" style="color: red;">logout</a> <a href="create_user.php"> + add user</a> </small> <?php endif ?> </div> </div> </div> </body> </html> |
This post about how to fetch data from database using oops concept in PHP. In previous post i explained how to insert data using OOPs concepts. Now from the same table we will fetch the data. 1.Create a apge function.php inside this page define a class DB_con. In DB_con class define a constructer for dbconnection and write […]
This is an explanation on how to insert data in database using oops concept. 1.First create a html form Index.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
<form name="insert" action="" method="post"> <table width="100%" border="0"> <tr> <th width="26%" height="60" scope="row">Full Name :</th> <td width="74%"><input type="text" name="fname" value="" class="form-control" required /></td> </tr> <tr> <th height="60" scope="row">Email :</th> <td><input type="email" name="email" value="" class="form-control" required /></td> </tr> <tr> <th height="60" scope="row">Contact no. :</th> <td><input type="text" name="contact" maxlength="10" value="" class="form-control" required /></td> </tr> <tr> <th height="60" scope="row">Gender :</th> <td><input type="radio" name="gender" value="Male" required /> Male <input type="radio" name="gender" value="Female" required /> Female</td> </tr> <tr> <th height="60" scope="row">Education :</th> <td><select name="education" class="form-control"> <option value="">Select</option> <option value="10th">10th</option> <option value="12th">12th</option> <option value="Graduate">Graduate</option> <option value="Post Graduate">Post Graduate</option> </select> </td> </tr> <tr> <th height="60" scope="row">Address :</th> <td><textarea name="address" class="form-control"> </textarea></td> </tr> <tr> <th height="60" scope="row"> </th> <td><input type="submit" value="Submit" name="submit" class="btn-primary" /></td> </tr> </table> </form> |
2. Create a database with name demos Inside demos data base create a table inserdata Sample Structure of insertdata table
|
1 2 3 4 5 6 7 8 9 10 |
CREATE TABLE IF NOT EXISTS `insertdata` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `contactno` bigint(20) NOT NULL, `gender` varchar(255) NOT NULL, `education` varchar(255) NOT NULL, `addrss` longtext NOT NULL, `posting_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; |
3. Create a php page function .php Inside this page a class DB_con define. Db_con class contain db connection and […]
SQl Table Structure for this tutorial
|
1 2 3 4 5 6 7 8 9 10 |
CREATE TABLE `tblusers` ( `id` int(11) NOT NULL, `FullName` varchar(140) DEFAULT NULL, `Education` varchar(120) DEFAULT NULL, `postingDate` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ALTER TABLE `tblusers` ADD PRIMARY KEY (`id`); ALTER TABLE `tblusers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; |
Fetch the data from database and create checkbox . Checkbox name attribute is an array.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
<form name="multipledeletion" method="post"> <div class="container"> <div class="row col-md-6 col-md-offset-2 custyle"> <h2>How to delete Multiple Record in PHP</h2> <!-- Message --> <p style="color:red; font-size:16px;"> <?php if($errmsg){ echo $errmsg; } ?> </p> <table class="table table-striped custab"> <!-- Deletion Button --> <tr> <td colspan="4"> <input type="submit" name="submit" value="Delete" class="btn btn-primary btn-md pull-left" onClick="return confirm('Are you sure you want to delete?');" ></td> </tr> <tr> <th> <!-- For Selecting All --> <li><input type="checkbox" id="select_all" /> Select all</li></th> <th>Name</th> <th>Education </th> <th>Date</th> </tr> <?php $query=mysqli_query($con,"select * from tblusers"); $totalcnt = mysqli_num_rows($query); if ($totalcnt > 0) { while ($row=mysqli_fetch_array($query)) { ?> <tr> <td><input type="checkbox" class="checkbox" name="ids[]" value="<?php echo htmlentities($row['id']);?>"/></td> <td><?php echo htmlentities($row['FullName']);?></td> <td><?php echo htmlentities($row['Education']);?></td> <td><?php echo htmlentities($row['postingDate']);?></td> </tr> <?php } } else { ?> <tr> <td colspan="4"> No Record Found</td> </tr> <?php } ?> </table> </div> </div> </form> |
On Submitting the from collect all checkbox ids and implode their ids
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
if (isset($_POST["submit"])) { if (count($_POST["ids"]) > 0 ) { // Imploding checkbox ids $all = implode(",", $_POST["ids"]); $sql =mysqli_query($con,"DELETE FROM tblusers WHERE id in ($all)"); if ($sql) { $errmsg ="Data has been deleted successfully"; } else { $errmsg ="Error while deleting. Please Try again."; } } else { $errmsg = "You need to select atleast one checkbox to delete!"; } } |
HERE IS THE FULL CODE WRITTEN DURING THIS TUTORIAL :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 |
<?php include('dbconfig.php'); error_reporting(0); if (isset($_POST["submit"])) { if (count($_POST["ids"]) > 0 ) { // Imploding checkbox ids $all = implode(",", $_POST["ids"]); $sql =mysqli_query($con,"DELETE FROM tblusers WHERE id in ($all)"); if ($sql) { $errmsg ="Data has been deleted successfully"; } else { $errmsg ="Error while deleting. Please Try again."; } } else { $errmsg = "You need to select atleast one checkbox to delete!"; } } ?> <!DOCTYPE html> <html> <head> <meta name="description" content="How to delete multiple record in PHP"> <meta name="keywords" content="How to delete multiple record in PHP"> <meta name="author" content="Anuj Kumar"> <title>How to delete Multiple Data in PHP</title> <link href="//netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css"> <script src="//netdna.bootstrapcdn.com/bootstrap/3.0.0/js/bootstrap.min.js"></script> <script src="//code.jquery.com/jquery-1.11.1.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script> <style type="text/css"> .custab{ border: 1px solid #ccc; padding: 5px; margin: 5% 0; box-shadow: 3px 3px 2px #ccc; transition: 0.5s; } .custab:hover{ box-shadow: 3px 3px 0px transparent; transition: 0.5s; } li { list-style-type: none; } </style> </head> <body> <form name="multipledeletion" method="post"> <div class="container"> <div class="row col-md-6 col-md-offset-2 custyle"> <h2>How to delete Multiple Record in PHP</h2> <!-- Message --> <p style="color:red; font-size:16px;"> <?php if($errmsg){ echo $errmsg; } ?> </p> <table class="table table-striped custab"> <!-- Deletion Button --> <tr> <td colspan="4"> <input type="submit" name="submit" value="Delete" class="btn btn-primary btn-md pull-left" onClick="return confirm('Are you sure you want to delete?');" ></td> </tr> <tr> <th> <!-- For Selecting All --> <li><input type="checkbox" id="select_all" /> Select all</li></th> <th>Name</th> <th>Education </th> <th>Date</th> </tr> <?php $query=mysqli_query($con,"select * from tblusers"); $totalcnt = mysqli_num_rows($query); if ($totalcnt > 0) { while ($row=mysqli_fetch_array($query)) { ?> <tr> <td><input type="checkbox" class="checkbox" name="ids[]" value="<?php echo htmlentities($row['id']);?>"/></td> <td><?php echo htmlentities($row['FullName']);?></td> <td><?php echo htmlentities($row['Education']);?></td> <td><?php echo htmlentities($row['postingDate']);?></td> </tr> <?php } } else { ?> <tr> <td colspan="4"> No Record Found</td> </tr> <?php } ?> </table> </div> </div> </form> <script type="text/javascript"> $(document).ready(function(){ $('#select_all').on('click',function(){ if(this.checked){ $('.checkbox').each(function(){ this.checked = true; }); }else{ $('.checkbox').each(function(){ this.checked = false; }); } }); $('.checkbox').on('click',function(){ if($('.checkbox:checked').length == $('.checkbox').length){ $('#select_all').prop('checked',true); }else{ $('#select_all').prop('checked',false); } }); }); </script> </body> </html> |
Awesome Php calendar is fully hard coded in php making full use of php native functions. I have named it awesome because I find this technique very generic and when it can be upgraded and lots of functionalities can be added. This is the first release of this mini project and licensed under MIT(open source). […]