Like this code?
Show the author your appreciation.
<?php
= "localhost" ;
$user_name = "username" ;
$password = "password" ;
$db = "databasename" ;
define ( "DB" , $db );
define ( "HOST" , $host );
define ( "USERNAME" , $user_name );
define ( "PASSWORD" , $password );
?>
<?php
class exportFile
{
$Query_ID = 0 ;
$connection = 0 ;
connect ()
$this -> connection == 0 ) {
$this -> connection = mysql_connect ( HOST , USERNAME , PASSWORD ) or die( "<b>Database Error</b><br>" . mysql_error ());
$SelectResult = mysql_select_db ( DB , $this -> connection ) or die( "Couldnot Select Database" . mysql_error ());
"Connection Couldnot be Established" ;
query ( $sql ) {
$this -> Query_ID = mysql_query ( $sql , $this -> connection );
$this -> Query_ID ) {
"Query Failed" . mysql_error ();
$this -> Query_ID ;
exportFileToDatbase ( $filename , $de , $mode , $tablename , $fieldno )
$fd = fopen ( $filename , " $mode " );
feof ( $fd )) {
$line = fgets ( $fd , 5000 );
$f = explode ( $de , $line );
$i = 0 ; $i < $fieldno ; $i ++) {
$a []= trim ( "' $f [ $i ] '" );
$value = implode ( "," , $a );
$a );
$sql = "insert into $tablename values( $value )" ;
//echo $sql;
$this -> query ( $sql );
?>
Suraj~123
<?php
include( "config.php" );
"fileClass.php" );
$objFile =new exportFile ;
$objFile -> connect ();
$objFile -> exportFileToDatbase ( "text.txt" , "~" , "r" , "user" , 2 );
// File name,Seprator,mode,tablename,field
?>
usercounter class Categories : PHP , PHP Classes , Databases , MySQL , Environment Variables Sort the results from a SELECT query (any number of columns) into an array automatically. Categories : PHP , PHP Classes , Arrays , Databases , MySQL MySQL Class to ease Database connectivity Categories : MySQL , PHP Classes , Databases , PHP Link Manager for Link Exchangers Categories : PHP , PHP Classes , Databases , MySQL , CURL A script to generate a report from a valid mysql connection. The user has to supply which fields he wants to display in table. All properties are changable.
Categories : PHP , PHP Classes , Databases , MySQL , HTML and PHP Simple pipe delimited file export program that downloads to a local machine Categories : PHP , Filesystem , Databases , MySQL , HTTP Simple database class Categories : PHP , PHP Classes , MySQL , Databases Powerful php/mysql Pagination for up to 6 URL Params Categories : PHP , PHP Classes , Databases , MySQL , Navigation This class splits the results of the query into multiple pages like what the search engine does. Categories : PHP Classes , PHP , MySQL , Databases Convert SQL from oracle,mysql,mssql,sqlite and odbc to SQL compatible Categories : PHP , PHP Classes , Databases , MySQL , MS SQL Server MySQL Handler Categories : PHP , Databases , MySQL , Classes and Objects , PHP Classes Simple Mini Poll class library (SimPoll) Categories : PHP , PHP Classes , Databases , MySQL , Complete Programs Setting up InnoDB on MySQL and using Transactions Begin, Commit, Rollback in PHP. Categories : PHP Classes , Databases , PHP , MySQL , InnoDB Simple usersOnline class - keep track of how many users are online on your site Categories : PHP , PHP Classes , Databases , MySQL PostGreSQL and MySQL 2 in 1 db Manager Categories : PHP , PHP Classes , Databases , PostgreSQL , MySQL
achmad syaifuri wrote : 1888
Great thanks for the code.
karthik s wrote : 1895
karthik s wrote : 1896
Hi Great.... example....
