problem with sql querry in php script

Posted on 16th Feb 2014 07:03 pm by admin

Hello guys,

What I want to do is I want to read out a csv file and then but te conent ot the file in a msql datbase .
So far it works but the problem I haven that if I want to let te script to the typing for me so that I dont have to fill in the Values of the MySQL query myself It doesn't work

This is my code so far :

<?php
$dbhost = 'localhost';
$dbuser = 'y';
$dbpass = 'x';
$dbname = 'test';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die;
mysql_select_db($dbname);


$file = fopen("test.csv", "r") or exit("Unable to open file!");
//Output a line of the file until the end is reached
while(!feof($file))
{

echo fgets($file). "<br />";
}
fclose($file);

mysql_query("INSERT INTO test
(Naam,Geboortedatum, Leeftijd,woonplaats, Geslacht) VALUES('$file','$file', '$file','$file','$file' ) ")
or die(mysql_error());


if (!mysql_query($sql,$conn))
{
die('Error: ' . mysql_error());

echo "Gegevens toegevoegd";
}
mysql_close($conn)
?>

Your Answer:

Login to answer

Other forums

php wont update my db
hello,

sorry for posting in mysql forum but i dont know where exactly is the problem but here

Open link with largest int string first
I have the following links i would like to open either all at once or one-by-one. How would i procee

Auto install
Hi I have a directory lets say "apps" that I then have more folders ie "email",

Mysterious Timeouts
I've deployed a few simple AJAX-enabled web page to a local server that is accessed through the Inte

Simple Variable Question
Hi everyone.... again,

I am really getting into php still. Learning more every day. I love it

Image resize
Hi again fellers

I managed to sort out the issues with the folder,

Final hurdle is th

Grids not displaying decimals, and behaving differently on different PCs?
Hello,

I coded a relatively simple MII application that allows data from a form to be add

How to give the privillege for triggers?
Hi,

How to give the privillage for triggers to particular user?

Please let me

Problem with Sending Mail by PHP
hello all,
I m new to php, can u plz provide me the code to send mail by php having CAPTC

search function
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t