LAMP

How To Install LAMP : Linux, Apache, MySQL, PHP on...

Content - 1. Install Apache 2. Install MySQL 3. Install PHP 4. Restart Server 5. Test Apache 6. Test PHP   1. Install Apache: Apache is a free open source and cross-platform web...
LAMP

MySQL : How to Import an SQL file in Windows via...

In this article, we will discuss - How to Import an SQL file in Windows via Command line only few steps to import SQL...
LAMP

ERROR 2006: MySQL server has gone away

In this article,  we will discuss ERROR 2006: MySQL server has gone away ? you can resolve this only few change. which given below Windows : go...

how to create table in mysql with primary key and autoincrement...

Create table in mysql with primary key and autoincrement: Use Query for create table: CREATE TABLE `careers_course_exam` ( `id` int(15) NOT NULL AUTO_INCREMENT, `course_id` int(11) NOT NULL, `exam_nid`...

How to create Registration Page in Php

<?php session_start(); require 'conf.php'; error_reporting(0); $db=new db(); $msg=''; if(isset($_POST)) { //print_r($_POST);exit; $cityzenship=$_POST; $age=$_POST; $sex=$_POST; $socialdis=$_POST; $subcat=$_POST; $subcategories=implode(',', $subcat); $sql="select *from registration where email='$email'"; $run=mysql_query($sql); $num=mysql_num_rows($run); if($num!=0) { $msg="Email Already Exist"; } else { $as1="INSERT INTO registration SET cityzenship='$cityzenship', age='$age', sex='$sex',socialdis='$socialdis', fundinglook='$fundinglook',moneytext='$moneytext',idealcantext='$idealcantext',fname='$fname',lname='$lname',streetadd='$streetadd',city='$city',state='$state',zip='$zip',fphone='$fphone',mphone='$mphone',lphone='$lphone',email='$email',checkbox='$checkbox',category='$cat',subcategory='$subcategories'"; $que1=mysql_query($as1) or die(mysql_error()); if($que1){ $id=mysql_insert_id(); $_SESSION=$id; } header('location:inner_page.php'); } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML...

How to Finding duplicate values in MySQL

How to Finding duplicate values in MySQL : Get Duplicate value SELECT entity_id, COUNT(*) c FROM college_data GROUP BY entity_id HAVING c > 1;