javafreak's Profile User Rating: -----

Reputation: 11 Tradesman
Group:
Contributors
Active Posts:
97 (0.06 per day)
Joined:
21-September 09
Profile Views:
3,947
Last Active:
User is offline Apr 19 2013 02:10 AM
Currently:
Offline

Previous Fields

Country:
IN
OS Preference:
Windows
Favorite Browser:
FireFox
Favorite Processor:
Intel
Favorite Gaming Platform:
PC
Your Car:
Who Cares
Dream Kudos:
25

Latest Visitors

Icon   javafreak has not set their status

Posts I've Made

  1. In Topic: Php header is not working

    Posted 10 Jul 2012

    The simple solution is to use

    you call ob_start() at the very beginning of the file and ob_end_flush() at the end


    
    <?php 
        ob_start();
    
    //your php code here
    
    ob_end_flush();
    
    ?>
    
    
  2. In Topic: Problem in inserting data from excel sheet to php myadmin by using php

    Posted 7 Jul 2012

    try this code

    <?
        /********************************************************************************************/
        /* Code at http://legend.ws/blog/tips-tricks/csv-php-mysql-import/
        /* Edit the entries below to reflect the appropriate values
        /********************************************************************************************/
        $databasehost = "localhost";
        $databasename = "test";
        $databasetable = "sample";
        $databaseusername ="test";
        $databasepassword = "";
        $fieldseparator = ",";
        $lineseparator = "\n";
        $csvfile = "E:\Webcache\AA ONLINE\test1\english1.csv";
        /********************************************************************************************/
        /* 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 = "output.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";
        ?>
    

My Information

Member Title:
D.I.C Head
Age:
26 years old
Birthday:
September 5, 1987
Gender:

Contact Information

E-mail:
Click here to e-mail me
Website URL:
Website URL  http://
Yahoo:
Yahoo  saurabhvashist40@yahoo.com

Friends

javafreak hasn't added any friends yet.

Comments

Page 1 of 1
  1. Photo

    ankit2829 Icon

    07 Jul 2012 - 05:29
    thanks sir
Page 1 of 1