how 2 maintain database 4 php & how 2 connect database inphp
Moderator: General Moderators
how 2 maintain database 4 php & how 2 connect database inphp
Please guys,
tell me how can I maintain database for php...
I want to import the data/records from excel sheet in my database....
I am using phpMyadmin with WAMP.
Secondly, how to connect with my database...
On searching in google, I find this code suggested by developers...
I jst want to know where to add this...
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
// some code
?>
tell me how can I maintain database for php...
I want to import the data/records from excel sheet in my database....
I am using phpMyadmin with WAMP.
Secondly, how to connect with my database...
On searching in google, I find this code suggested by developers...
I jst want to know where to add this...
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
// some code
?>
Re: how 2 maintain database 4 php & how 2 connect database inphp
Have you read this already: viewtopic.php?f=1&t=106696
Re: how 2 maintain database 4 php & how 2 connect database inphp
Mike, I appreciate your reply but I don't want particular cell range and I don't want the valueMike2009 wrote:Have you read this already: viewtopic.php?f=1&t=106696
to be get stored in any array
I just want my data to be transferred from excel file to my database...
I want it to be work as tool........
1000 records in one shot......
Re: how 2 maintain database 4 php & how 2 connect database inphp
phpmyadmin has import functions.
-
satishbhawra42
- Forum Newbie
- Posts: 2
- Joined: Thu Oct 01, 2009 2:50 pm
Re: how 2 maintain database 4 php & how 2 connect database inphp
On searching in google, I find this code suggested by developers...
I jst want to know where to add this...
I jst want to know where to add this...
Re: how 2 maintain database 4 php & how 2 connect database inphp
Click on databases, click your database.... click the import tab, once youre on this screen the next steps are pretty self evident.
Re: how 2 maintain database 4 php & how 2 connect database inphp
JOSH, I try uploading excel file using import function, but its giving mejosh wrote:Click on databases, click your database.... click the import tab, once youre on this screen the next steps are pretty self evident.
invalid field count on file ....... on line 1................
I stuck at every step........
Re: how 2 maintain database 4 php & how 2 connect database inphp
I am using csv file only but.....josh wrote:use csv
Invalid field count in CSV input on line 1
Re: how 2 maintain database 4 php & how 2 connect database inphp
your field count must be invalid then
Re: how 2 maintain database 4 php & how 2 connect database inphp
can you send me a sample file, I will make amendments in that..josh wrote:your field count must be invalid then
Re: how 2 maintain database 4 php & how 2 connect database inphp
Meaning it differs from the field count of your table.