how can i write my data from text file into database

hi..
i m trying to write data from txt file onto database but when i am executing my php code for it the empty record will be inserted in the database not the data written on txt file will be entered.plz help me out

Expand|Select|Wrap|Line Numbers

 
 <html>

<?
 
$con=mysql_connect("localhost","root","root");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }
 
mysql_select_db('test',$con);

//(1) Read the text file into a variable

$file = "testfile.txt";

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

$data = fread($fp, filesize($file));

fclose($fp);
 
//(2) Then we can get rid of the tabs in there:
 
$output = str_replace("\t|\t", "|", $data);
 
//(3) Then we explode it at every line break
 
$output = explode("\n", $output);
 
//(4) Then we loop through all the array elements and explode them again and insert them into mysql
 
foreach($output as $var)

$tmp = explode("|", $var);

$FirstName = $tmp[0];

$LastName = $tmp[1];

$Age = $tmp[2];

$sql = "INSERT INTO student SET FirstName='$FirstName', LastName='$LastName',Age='$Age'";

mysql_query($sql);
 
echo "Done!";

mysql_close($con);

?>     </html>

Jan 28 '10 #1

Subscribe Post Reply

2499

Atli

5,058

Expert 4TB

Hey.

First of all, your foreach loop is - undoubtedly - not working as you want it to. Anything that should belong to a loop should be put inside brackets following the loop.

If the foreach is not followed by brackets ({}), it will assume only the very first line following it belongs to the loop. Therefore you should ALWAYS use brackets. Even if there is only one line. (For the sake of consistency)

Expand|Select|Wrap|Line Numbers

 <?php

// Some random values to loop through.

$values = array("first", "second", "third");
 
// This only prints one value: "third"

foreach($values as $_value)

    $value = $_value; // This is inside the loop

    echo $value; // This is OUTSIDE the loop.
 
// This prints all three values.

foreach($values as $_value) {

    $value = $_value;

    echo $value;

}

?>

Also, you should verify that the data is valid before using it in the query. Make sure the values you are using aren't empty, and that they contain the data you expect them to contain.

And as always, when dealing with MySQL queries: run ALL values through mysql_real_escape_string before putting it into the query. Otherwise your database is open for SQL Injection attacks. (If you think the data you are using is secure... you are wrong! :P)

Jan 28 '10 #2

dgreenhouse

250

Expert 100+

I see said the blind man... :-) I didn't notice the brackets... :-)

Is that really how the data is delimited?
i.e. with \t|\t

Expand|Select|Wrap|Line Numbers

 
<?php

// This works...

$b = "\t|\t";

$input = "John\t|\tSmith\nMary\t|\tJohnson";

$output = str_replace($b,'|',$input);

$output = explode("\n",$output);

foreach($output as $var) {

  $tmp = explode("|",$var);

  echo $tmp[0] . ' ' . $tmp[1] . '<br>';

}
 
?>

Also, if the file isn't very large, you can use the 'file()' command to create an array of lines. Then you can explode each line (as you're doing) on your replaced delimiter ('|').

Jan 28 '10 #3

puneetmca

thanx for d help..........

Feb 1 '10 #4

by: john | last post by:

I need to produce a RTF-document which is filled with data from a database. I've created a RTF-document in WordPad (a template, so to speak) which contains 'placeholders', for example '<dd01>',...

C# / C Sharp

how can i write in a database

by: belange | last post by:

I try to create a little web application with c# and visual studio.net. With this application, a student can reserved a computer station, the day and the hour. I want to write these informations in...

ASP.NET

Read & Write XML

by: marcmc | last post by:

Hi, I hope to create a XML file that will hold my Connection data to a SQL Db. I want to write an XML file from 4 Text Box named UserName, Password, Database & Server and later read from it. My...

Visual Basic .NET

Write Formatted text in a doc file

by: sonu | last post by:

I am getting some data 'strData' from database through reader object. The data 'strData' is sent to a doc using FilesystemObject line by line in doc file located on a specific location. 1.Code...

C# / C Sharp

Some advice needed on an Tkinter app that I try to write

by: Svenn Bjerkem | last post by:

Hi, Armed with Programming Python 3rd Edition and Learning Python 2nd edition I try to write an application which I at first thought was simple, at least until I was finished with the GUI and...

Python

ASP Write Method - How to Position the Cursor

by: Billy | last post by:

Hi all, I'm building a text file from a database table using the ASP Write Method and would like to position the cursor in a specific column position before writing the fields. As I loop through...

ASP / Active Server Pages

Write to an Access database

by: =?Utf-8?B?Smlt?= | last post by:

I have code that reads and parses a text file using a schema.ini file. Works great. When I see the dataGrid it's exactly what I want. Dim CString As String = _...

Visual Basic .NET

Web Server Read/Write

by: Ross | last post by:

Hello, I am trying to Read and Write to a text file on a web server using Microsoft Visual Basic 2005 Express Edition. So far I have managed to complete my testing with a local text file using...

Visual Basic .NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

how can i write my data from text file into database

Similar topics