As suggested by David, save the excel file as CSV file then you can
insert the data into database through command like LOAD INFILE for MYSQL
with best wishes
balwant
On Tue, 2005-01-25 at 12:34, David Robley wrote:
On Tuesday 25 January 2005 08:07, Novice Learner wrote:
Hello,
I have
Hello all,
As a beginner I have been trying to send two attachments from my HTML form.
Below is the code I have been using. The problem is, I seem to only be able
to send one or the other, when I send both, although they go through, the
text I want displayed tags 6110 etc, is also sent as an
Ben wrote:
Hello all,
As a beginner I have been trying to send two attachments from my HTML form.
the code you posted has no baring on DB stuff. so probably you question was
better aimed at php-generals, anyways
Below is the code I have been using. The problem is, I seem to only be able
to
Many thanks to all
-
Do you Yahoo!?
All your favorites on one personal page Try My Yahoo!
neil wrote:
Thanks Peter
The reason I was wanting to do it in php was because the sql query is quite
complex and variable depending on the input from a form.
When the result page is presented I want to provide a link to the last
record at the top of the page.
After connecting and selecting the
Quick question...
I am hoping some could explain this to me. I have an array like this:
$completed = array($value1, $value2, $value3);
where the values are sent via a form.
input type=checkbox name=completed[] value=value1
when I do print_ r() to see what's in the array I get this:
Array ( [0] =
Craig Hoffman wrote:
Quick question...
I am hoping some could explain this to me. I have an array like this:
$completed = array($value1, $value2, $value3);
where the values are sent via a form.
input type=checkbox name=completed[] value=value1
when I do print_ r() to see what's in the array I get
On Tuesday 25 January 2005 07:38 am, Craig Hoffman wrote:
Quick question...
I am hoping some could explain this to me. I have an array like this:
$completed = array($value1, $value2, $value3);
where the values are sent via a form.
input type=checkbox name=completed[] value=value1
when I
I have stored a .jpg image in a database, then when I make a sql statement
to display that image on a web page all I get is the cryptic code in place
of the image. I am storing it in a row configured as a blob, mime type
image/jpeg and binary (using phpMyAdmin). What am I doing wrong?
Regards,
Does Crystal Reports work with MY-SQL? Are there any open source tools that
are like Crystal Reports?
Hi, I am new to the mailing list and to PHP / MySQL. I am facing an
unususal problem. I am trying to insert some data into MySQL DB through
via Web. The code is executed OK - no errors but the same record gets
inserted TWICE. I have checked the code and simplified it as much as
possible and tried
http://sourceforge.net/projects/datavision/
you can use cyrstal with mysql...
bastien
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Any recomendations on a report writer to use with MY-SQL
Date: Tue, 25 Jan 2005 12:20:00 EST
Does Crystal Reports work with MY-SQL? Are there any
post code...can't read minds, you know
;-)
Bastien
From: [EMAIL PROTECTED] (PHPDiscuss - PHP Newsgroups and mailing lists)
To: php-db@lists.php.net
Subject: [PHP-DB] Double Inserts
Date: 25 Jan 2005 17:32:28 -
Hi, I am new to the mailing list and to PHP / MySQL. I am facing an
unususal
Please post ALL relevant code.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 25, 2005 12:32 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Double Inserts
Hi, I am new to the mailing list and to PHP / MySQL. I am facing an
unususal problem. I
Another dimension to the problem --- I am running my code on two separate
machines (Desk top a laptop) the desktop (faster?) has this problem,
notebook (slower?) doesn't. I have code that checks for duplicate inserts
and warns user. Even this fails and the database ends up with two
identical
Any report writer that supports ODBC.
As far as I know, there are no open source report writers like CR. (Gawd,
I'd hope they'd be better; my relationship with CR is sort of love-hate.)
Love it when the job's done, hate having to touch a working report because
everything's binary when it
Could be lots of things, improper/missing headers is most likely, although
it's not clear from your statement if you're displaying the binary data
directly in the page or are you calling an image output script in an image
tag. (as you should)
Show some code and the answer will be clear.
you can not ouput html and binary data at the same time. you need to have
image headers sent to the browser to show the image properly.
the best way to do this is to move the image processing code to a separate
page and include it like this
echo 'img src=./path/to/image.php?id=$id';
then the
Bastien Koert wrote:
post code...can't read minds, you know
;-)
cant-help-myself style=no-disrespect-to: bastien;
well yes, you have to understand Bastien is only an apprentice has not
yet been initiated into the inner mind-readers circle.
I on the other hand can tell you with utmost certainty
I am but your padawan
Bastien
From: Jochem Maas [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], php-db@lists.php.net
Subject: Re: [PHP-DB] Double Inserts
Date: Tue, 25 Jan 2005 19:41:43 +0100
Bastien Koert wrote:
post code...can't read minds, you know
;-)
Bastien Koert wrote:
I am but your padawan
Bastien
[snip]
From: Jochem Maas [EMAIL PROTECTED]
cant-help-myself style=no-disrespect-to: bastien;
well yes, you have to understand Bastien is only an apprentice has not
yet been initiated into the inner mind-readers circle.
I on the other hand can tell
I thank you deeply for your kind words.
Drink up, the worlds about to end.
Bastien
From: Martin Norland [EMAIL PROTECTED]
Reply-To: php-db@lists.php.net
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Double Inserts
Date: Tue, 25 Jan 2005 13:01:40 -0600
Bastien Koert wrote:
I am but your padawan
I am having trouble with my session data on Microsoft IIS.
Here is a little background of the problem:
1) I am not personally in control of our web server. Our IT
department manages it. They have IIS running on their sever and use MS SQL
Server, but they have allowed me to use PHP
Martin Norland wrote:
Bastien Koert wrote:
I am but your padawan
brilliant.
Bastien
[snip]
From: Jochem Maas [EMAIL PROTECTED]
cant-help-myself style=no-disrespect-to: bastien;
well yes, you have to understand Bastien is only an apprentice has not
yet been initiated into the inner mind-readers
Thanks Bastien,
In testing this I have added the code samples to a page and have it
working except the path statement is not correct. For now, I've just added
all the code to one page, rather than including a second page. The
statement - echo 'img src=id=$id'; is resulting in this error - The
Its not src='id=$id' that will defnintely blow up
echo 'img src=./path/to/image.php?id=$id';
where $id is the id of the record you are trying to get the image to...
Bastien
From: Chip Wiegand [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: php-db@lists.php.net
Subject: RE: [PHP-DB] storing images
Perry, Matthew (Fire Marshal's Office) wrote:
I am having trouble with my session data on Microsoft IIS.
Here is a little background of the problem:
1) I am not personally in control of our web server. Our IT
department manages it. They have IIS running on their sever and use MS SQL
And how are you feeding the $id?are you setting a value for that
element?
In the sample code the default is the record_id that corresponds back to the
id of the row with the image blob field.
Bastien
From: Chip Wiegand [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: PHP DB
Perry, Matthew (Fire Marshal's Office) wrote:
I am having trouble with my session data on Microsoft IIS.
[snip]
2) I have Apache running on a local web server in our office (not the
IT department). It accesses the SQL Server database remotely. I have
register_global turned OFF and use the
Perry, Matthew (Fire Marshal's Office) wrote:
2) I have Apache running on a local web server in our office (not the
IT department). It accesses the SQL Server database remotely. I have
register_global turned OFF and use the following code on each page:
session_start();
Bastien Koert wrote:
Its not src='id=$id' that will defnintely blow up
echo 'img src=./path/to/image.php?id=$id';
where $id is the id of the record you are trying to get the image to...
Bastien
From: Chip Wiegand [EMAIL PROTECTED]
[snip]
In testing this I have added the code samples to a page
I have a new installation of php on an existing apache 2 server, and
something strange is happening. The file 'test.php' works and connects to
the database when run through the command line, but when run from the web
server (http://server/test.php) produces a segmentation fault:
child pid
I have done it an easier way, and probably a better way all-around anyway.
I am storing the images in a directory and have the script call the
file/alt text/title text and a description text in a paragraph below the
image. It works quite well this way.
What I'm doing is on this home page there
On Tuesday 25 January 2005 20:20, Perry, Matthew (Fire Marshal's Office)
wrote:
I am having trouble with my session data on Microsoft IIS.
Here is a little background of the problem:
1) I am not personally in control of our web server. Our IT
department manages it.
oh dear! ;-)
Filesystem is easier, by far since it avoids the content header. Glad you
solved it
bastien
From: Chip Wiegand [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: PHP DB php-db@lists.php.net
Subject: RE: [PHP-DB] storing images in database
Date: Tue, 25 Jan 2005 14:32:11 -0800
I have done it an easier
Just to polish the topic off, below are the two files that have been tested
on my machine (xp, apache2, php 4.3.9, mysql4.0.1x)
?php
//show_image.php
require(conn.php);
//check to see if the id is passed
if(isset($_GET['id'])) {
$id=$_GET['id'];
$query = select bin_data, filetype from
try users@httpd.apache.org list
On Tue, 25 Jan 2005 14:21:25 -0800, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I have a new installation of php on an existing apache 2 server, and
something strange is happening. The file 'test.php' works and connects to
the database when run through the
37 matches
Mail list logo
