javafreak's Profile
Reputation: 11
Tradesman
- Group:
- Contributors
- Active Posts:
- 97 (0.07 per day)
- Joined:
- 21-September 09
- Profile Views:
- 3,678
- Last Active:
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
Posts I've Made
-
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(); ?> -
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"; ?> -
In Topic: Uploading Images with PHP
Posted 27 Sep 2011
please show me tutorial to upload on server lol -
In Topic: Creating a DLL to store common methods in C#
Posted 7 Sep 2011
how to merge it with exe i mean dll+exe=exe -
In Topic: PHP - Uploading a File
Posted 28 Aug 2011
thanks aloat very great code !!
My Information
- Member Title:
- D.I.C Head
- Age:
- 25 years old
- Birthday:
- September 5, 1987
- Gender:
Contact Information
- E-mail:
- Click here to e-mail me
- Website URL:
-
http://
- Yahoo:
-
saurabhvashist40@yahoo.com
Friends
javafreak hasn't added any friends yet.
|
|


Find Topics
Find Posts
View Reputation Given
|
Comments
ankit2829
07 Jul 2012 - 05:29