Syllabus Lecture Sessions Chapter 1: Introduction to Internet and WWW Chapter 2: Web Hosting and FTP Chapter 3: Websites Design Issues Chapter 4: Website Navigation Chapter 5: Blogging Chapter 6: Search Engine Optimization Chapter 7: Content Management System Chapter 8: Deploying Your Website Chapter 9: Promoting the Website through Social Media Chapter 10: Maintaining the Website Computer Lab Sessions Lab 1: Basic HTML and tags Lab 2: Bullets and Numbering Lab 3: Table Lab 4: Forms Lab 5-10: CMS using Joomla! Lab 11-14: Website Development Installer 1. XAMPP Installer 2. Joomla Installer (http://joomla.org/download.html) |
This PHP code is a simple search example. It needs the user to enter a name and the PHP script will to the searching by the name provided by the user in the text box. <form name='search' method='get' action=''> Insert the firstname <input type='text' name='txtname'> <input type='submit' value='search name'> </form> <?php //database connect $db=mysqli_connect("localhost","root","","mycompanyhr"); //checking database connection if ($db==false) { echo "Connect failed: ". mysqli_connect_error($db); exit(); } else { echo "Connection successful"; } $n=$_GET['txtname']; $sql="select EMPNO, FIRSTNAME, LASTNAME, WORKDEPT, PHONENO from employee where FIRSTNAME like '%$n%' "; $rs=mysqli_query($db,$sql); if($rs==false){ echo ("Query cannot be executed!<br>"); echo ("SQL Error : ".mysqli_error($db)); } else...
You’re truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you’ve got here.
ReplyDeleteWeb Survey