How to upload excel file to php server Drupal 7

How to upload excel file to php server Drupal 7: Step 1-  create Menu callback. /** * Implements hook_menu(). */ function my_module_menu() { $items = array(); $items = array( 'title' => '', 'page...

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 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;

billing

<?php session_start(); error_reporting(0); include_once('dbconnect/dbconnection.php'); date_default_timezone_set('Asia/calcutta'); if($_SESSION=='') { header("Location:index.php"); exit; } if(isset($_GET)){ $id=$_GET; //echo $id;die; $sql = "SELECT * FROM `temp_billing` WHERE `id`='$id'"; $result=mysql_query($sql); $row=mysql_fetch_array($result); $tempQty=$row; $tempmetre=$row; $productId=$row; $sql = "SELECT * FROM `products` WHERE `id`='$productId'"; $result=mysql_query($sql); $row1=mysql_fetch_array($result); $productQty=$row1; $totalQty=$tempQty+$productQty; $metreqty=$row1; $totalmetre=$tempQty+$metreqty; if($productQty>=0){ $query_run2=mysql_query("update products set qty='$totalQty' where id='$productId'") or die(mysql_error()); }else if($row1>=0){ $query_run2=mysql_query("update...

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...
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...