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

form help
this doesn't work. i want the form action to go the location.href of the submit button chosen.. how

Registration
ok so i have a site where people can register and login which works now thanks to someone on here th

Schedule editor
Hi,

I have a question related to Schedule editor.
If we schedule a BLS for every 30

Empty text file when there is over XXXX lines of text.

define("RANDOM_FILE","/public_html/random.txt");
$randomEntry = "

help retrieiving results and doing pagination
Having some trouble trying to get the results to show on more than just one page.

What is ha

I need some help with the IF command...
I have a large number of images in one section of my website with the .jpg format. I'm adding a bun

convert static html data into dynamic
hi all

i need to convert a website which has static above 2000 articles into dynamic and add

Include with Parameters
In a particular page I would like to include a file that requires $_GET parameters.

when I go

Problem with Subscreen
Dear Experts ,
I am facing a problem with the subscreens. My senario is as follows :

DataTable Help Required
Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at vario