Archive for the ‘ PHP ’ Category

How to insert CSV data to mysql database using php


<?php

/********************************/
/* Database configuration
/********************************/
$databasehost = "localhost";
$databasename = "your database name";
$databasetable = "database table name";
$databaseusername ="username";
$databasepassword = "password";
$fieldseparator = ",";
$lineseparator = "\n";
$csvfile = "customers.csv"; //CSV file that you want to insert
/********************************/
/* Would you like to add an ampty field at the beginning of these records?
/* This is useful if you have a table with the first field being an auto_increment integer
/* and the csv file does not have such as empty field before the records.
/* Set 1 for yes and 0 for no. ATTENTION: don't set to 1 if you are not sure.
/* This can dump data in the wrong fields if this extra field does not exist in the table
/********************************/
$addauto = 0;
/********************************/
/* Would you like to save the mysql queries in a file? If yes set $save to 1.
/* Permission on the file should be set to 777. Either upload a sample file through ftp and
/* change the permissions, or execute at the prompt: touch output.sql && chmod 777 output.sql
/********************************/
$save = 1;
$outputfile = "csvinput.sql";
/********************************/


if(!file_exists($csvfile)) {
 echo "File not found. Make sure you specified the correct path.\n";
 exit;
}

$file = fopen($csvfile,"r");

if(!$file) {
 echo "Error opening data file.\n";
 exit;
}

$size = filesize($csvfile);

if(!$size) {
 echo "File is empty.\n";
 exit;
}

$csvcontent = fread($file,$size);

fclose($file);

$con = @mysql_connect($databasehost,$databaseusername,$databasepassword) or die(mysql_error());
@mysql_select_db($databasename) or die(mysql_error());

$lines = 0;
$queries = "";
$linearray = array();

foreach(split($lineseparator,$csvcontent) as $line) {

 $lines++;

 $line = trim($line," \t");

 $line = str_replace("\r","",$line);

 /************************************
 This line escapes the special character. remove it if entries are already escaped in the csv file
 ************************************/
 $line = str_replace("'","\'",$line);
 /*************************************/

 $linearray = explode($fieldseparator,$line);

 $linemysql = implode("','",$linearray);

 if($addauto)
 $query = "insert into $databasetable values('','$linemysql');";
 else
 $query = "insert into $databasetable values('$linemysql');";

 $queries .= $query . "\n";

 @mysql_query($query);
}

@mysql_close($con);

if($save) {

 if(!is_writable($outputfile)) {
 echo "File is not writable, check permissions.\n";
 }

 else {
 $file2 = fopen($outputfile,"w");

 if(!$file2) {
 echo "Error writing to the output file.\n";
 }
 else {
 fwrite($file2,$queries);
 fclose($file2);
 }
 }

}

echo "Found a total of $lines records in this csv file.\n";


?>

for more magento tutorial visit: http://blog.free-extension.com/

How to get all data from database in code Igniter

function get_all_students()
{
$query = $this->db->get(‘students’);
if ($query->num_rows() > 0)
{
$result = $query->result_array();
return $result;
}
else
{
return ‘0’;
}
}

// students is the table name of database

For details you may visit  http://codeigniter.com/user_guide/database/active_record.html

How to Insert data to database in code Igniter

function add($input)
{
$student_data = array(
‘name’ => $input[‘name’],
‘roll’ => $input[‘roll’]
);
$test = $this->db->insert(‘students’, $student_data);

// Produces: INSERT INTO student (name, roll) VALUES (‘name’, ‘roll’)

How to create form in Code Igniter Framework

/*
<form method="post" 
action="<?= site_url('Controller_name/
Controller_function').'/'.$student['id']; ?>">
<h1>Add information of Data</h1>
<input type="text" name="name"> <lable>Name</label>
<input type="text" name="roll"> <label>roll</label>
<input type="submit" name="submit" value="submit">
</form>
*/

PHP Tutorial for Beginner (It is very easy)

Hello, and welcome to my ultimate guide to PHP! I’m going to start from the beginning, and hopefully towards the end you’ll be able to know a lot of the basics of PHP, which will help you along the way to programming in the PHP language.

Chapters
Chapter 1 – The Basics
Chapter 2 – Variables
Chapter 3 – Operators
Chapter 4 – If, Else, Switch
Chapter 5 – Functions
Chapter 6 – Arrays
Chapter 7 – Forms & Inputs
Chapter 8 – While, For, Foreach
Chapter 9 – Advanced Operators
Chapter 10 – Files
Chapter 11 – MySQL
Chapter 12 – External Files
Chapter 13 – E-Mail
Chapter 14 – Sessions
Chapter 15 – Date
Conclusion

Continue reading

How to make a blog site

Suppose you need a blog site where you want to add a new page like  wordpress then you need to follow the following tips.

Continue reading

How to change content without loading the page in php

It is very important to build a simple website.. and It is nice to look. and it reduce the time complexity to load a page.

Suppose we want to build a website where header, footer, sidebar all will be fix but only page body( content-discription)  will be changed then you need to follow the following tips.

suppose your website is very simple look like as below

Here there is only three part of website just for tutorial at the top of the table is header and last part of table is  footer which will not be changed . and at the midle part of  the table we will include all page here.

Continue reading