Skip to main content

searchdelete.php (list records of table to delete)

<form name='search' method='get' action=''> 

Insert the firstname
<input type='text' name='txtname'>
<input type='submit' value='search name'>


//database connect

//checking database connection
if ($db==false) {
echo "Connect failed: ". mysqli_connect_error($db);

else {
echo "Connection successful";


from employee
where FIRSTNAME like '%$n%' ";

echo ("Query cannot be executed!<br>");
echo ("SQL Error : ".mysqli_error($db));

echo "<table border=1>";
echo "<tr>";
echo "<td></td>";
echo "<td>Employee no</td>";
echo "<td>First name</td>";
echo "<td>Last name</td>";
echo "<td>Department</td>";
echo "<td>Phone ext</td>";
echo "</tr>";
echo "<tr>";
echo "<td> <a href='delete.php?id=$empno'>
delete </a> </td>";
echo "<td>".$empno."</td>";
echo "<td>".$rekod['FIRSTNAME']."</td>";
echo "<td>".$rekod['LASTNAME']."</td>";
echo "<td>".$rekod['WORKDEPT']."</td>";
echo "<td>".$rekod['PHONENO']."</td>";
echo "</tr>";
}//end while

}//end null

echo "</table>";



Popular posts from this blog

Several English proverbs and the Malay pair

Or you could download here for the Malay proverbs app – English proverbs and the Malay pair Corpus Reference: Amir Muslim, 2009. Peribahasa dan ungkapan Inggeris-Melayu. DBP, Kuala Lumpur CTRL+F to search Proverbs in English Definition in English Similar Malay Proverbs Definition in Malay 1 Where there is a country, there are people. A country must have people. Ada air adalah ikan. Ada negeri adalah rakyatnya. 2 Dry bread at home is better than roast meat home's the best hujan emas di negeri orang,hujan batu di negeri sendiri Betapa baik pun tempat orang, baik lagi tempat sendiri. 3 There's no accounting for tastes We can't assume that every people have a same feel Kepala sama hitam hati lain-lain. Dalam kehidupan ini, setiap insan berbeza cara, kesukaan, perangai, tabia

WebDev PHP DEVELOPMENT TOOLS Download the XAMPP latest version from . This installation file contains the Apache web server, PHP 5 and 4 interpreter, and the MySQL 5 Community edition. - download latest version MozillaFireFox (OpenSource web browser firefox) – download latest version Google Chrome – fastest web browser on earcth – fast download chrome here TEACHING PLAN Download the teaching plan here for Web/Internet Programming ( download ) NOTES HTML references HTML Editor - Lab 1: HTML Basics - Lab 2: Responsive Design: Lab 3: HTML Forms Lab 4: HTML 5 Lab 5: Bootstrap for responsive Web -

Contact Us at

Powered by EMF HTML Contact Form

Bootstrap Template for PHP database system - MyCompanyHR

HTML without framework is dull. Doing hard-coded CSS and JS are quite difficult with no promising result on cross platform compatibility. So I decided to explore BootStrap as they said it is the most popular web framework. What is BootStrap? - Bootstrap is the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first web sites. (   ) Available here - Why you need Flat-UI? Seems like a beautiful theme to make my site look professional. Anyway you could get variety of BootStrap theme out there, feel free to select here Flat-UI is from DesignModo - Web Programming MyCompanyHR – PHP & MySQL mini project (with Boostrap HTML framework) Template 1: Template for the Lab Exercise. This is a project sample of a staff record management system. It has the PHP structured co

Login JSON Android using Login Activity

I’ve been trying to release this tutorial quite a while. At last after a long hard effort. Since HttpClient is not supported any more in Android SDK 23, I have to resort to org.json.JSONObject and library to do online database with JSON. The objective of this tutorial is to log-in from a mobile client with the username and password stored in an online database facility. STEP 1: Create a new Android project, this time choose the LoginActivity .