Monday 21, May 2012
Welcome Guest, Register | Login  
      Home    |    Tutorials    |    Free Ebooks    |    Free Scripts    |    Articles    |    Blog     |    About Us    |    Contact Us

  creating new table in MySql using php

Here is an example to create a new table in mysql database.
Cut & Paste Script
<?php
//connecting to the database//
$linkID = mysql_connect('localhost', 'username', 'password');
mysql_select_db('new_db');

$query = "CREATE TABLE new_table (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, firstname VARCHAR(25), lastname VARCHAR(25))";
//executing query//
$result = mysql_query($query);
?>
 
   
     RELATED SCRIPTS
 
Uploading file using php
Here is a simple script to upload file using php. we are using move_uploaded_file function to upload file. The move_uploaded_file function needs two parameters
1. The path of the temporary file.
2. The path where it is to be moved to.
...more »
Category : PHP Examples Hits : 429
   
creating xml file using php
Here is a script to create xml file using php DOM....more »
Category : PHP Examples Hits : 555
   
Difference Between two dates using php
This function will return the number of days elapsed between two dates....more »
Category : PHP Examples Hits : 559
   
Reading xml file using php
The easiest way to read a well-formed XML file is to use the Document Object Model (DOM) library compiled into some installations of PHP. The DOM library reads the entire XML document into memory and represents it as a tree of nodes. Here is a script which reads the xml file....more »
Category : PHP Examples Hits : 756
   
Email validation using regular expression php
Here is a php script to validate email address. We are using regular expression for validation....more »
Category : PHP Examples Hits : 1010
   
   
SCRIPT CATEGORIES
 
  C Programs
C Programs scripts
  C++ Programs
C++ Programs scripts
  Java Programs
Java Programs scripts
  JavaScript Examples
JavaScript Examples scripts
  PHP Examples
PHP Examples scripts
  VBScript Examples
VBScript Examples scripts
 
 
 
POPULAR E-BOOKS
 
Download Viral Marketing Mechanics Ebook Viral Marketing Mechanics
   
Download Fundamentals of Wireless Communication Ebook Fundamentals of Wireless Communication
   
Download Make a Million with Your Mailing List  Ebook Make a Million with Your Mailing List
   
Download Income Plan Ebook Income Plan
   
Download Art of Programming Contest  Ebook Art of Programming Contest
   
 
Studiesinn.com © 2012 All Rights Reserved.
Website Designed & Developed by TechXprtz