I see the answer has already been given on php-install.
A suggestion which hasn't been made is to use PHP's new oci8
interface in preference to the old one called oracle whenever
possible.
To quote from a note on Oracle's PHP forum (see
http://forums.oracle.com/forums/forum.jsp?forum=178 )
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 12:07 PM
Subject: [PHP] INSERT into mysql from dynamic drop down
Hi all,
Right now i would like to INSERT the values from a dynamic drop
down
menu into
you have to fetch results from query
use:
mysql_fetch_field
http://si2.php.net/manual/sl/function.mysql-fetch-field.php
Jeroen Wasteels [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I'm studying PHP now woth this manual, but it's rather fuzzy on how to
show
data on screen obtained
I did not see an answer on php-install. I have also tried oci8,
but I get the error mentioned at the bottom of my post. I have
the ORA_HOME set, both on the shell level and the makefile level.
I look under the ORA_HOME root with 'find ORA_HOME -name oci.h
-print', and I get nothing. When I look
I'm having a problem with a standard html form. I'm using a php function to
populate a drop down menu on a standard form. I want the contents of the
submitted form to insert into a mysql table. All of the variables are
inserted correctly except for the data from the drop down menu. For some
On 07 January 2004 15:12, Duane Barnes contributed these pearls of wisdom:
I'm having a problem with a standard html form. I'm using a
php function to
populate a drop down menu on a standard form. I want the
contents of the
submitted form to insert into a mysql table. All of the
variables
Hello Irin,
Not sure where you problem is but here is what I would check first.
After you open the page that has the drop down list, view the source and
See if the OPTION VALUE= has any value assigned to it. If you are using
IE, on the menu bar click on View - Source.
Second, if that is fine,
Hello list,
Greetings,
Cilfa
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
From: Duane Barnes [EMAIL PROTECTED]
$output .= option value=$category$category/option;
Put quotes around your values...
If you have
option value=This and ThatThis and That/option
how do you expect HTML to know you mean This and That as you're entire
value? It's not. It's going to take This
Douglas B. Jones wrote:
I did not see an answer on php-install.
http://lists.php.net/article.php?group=php.installarticle=12457
I have also tried oci8,
but I get the error mentioned at the bottom of my post. I have
the ORA_HOME set, both on the shell level and the makefile level.
It's
Hello Everyone,
Can anyone tell me how to insert a file, say a .doc, .txt or a .rtf file into a table
from an upload form??
Thanks in advance,
~~Will~~
hi
there are several ways of saving the data within a file.
you can save it plain or binary. if you want to save a file in the db i
suggest using the field-type BLOB
short example:
to create the table:
CREATE TABLE `files` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`fileName`
hi!
just to add:
use file() only if you run php 4.3.0 or higher.
if this is not the case use this syntax (its binary safe):
$fp = fopen($_FILES['myFile']['tmp_name'], 'r'); # on windows use 'rb'
instead of 'r'
$data = fread($fp, file_size($_FILES['myFile']['tmp_name']));
fclose($fp);
instead
I still can't see what exactly I'm supposed to do... could someone please
write me a little piece of code that enters colomn soandso row soandso and
then stores what's there in a variable that's ready to print or so? I copied
the example from php.net, changing of course names of databases and
hi!
no problem... people should help each other ;)
so: no there is no difference. if you want people to have the possibility to
download the file there are certain things to remember of. just a short
example:
?php
$con = mysql_connect(...);
mysql_select_db();
$file = $_GET['file'];
$qry
Will W wrote:
Can anyone tell me how to insert a file,
say a .doc, .txt or a .rtf file into a table from an upload form??
How about just this:
$query = INSERT INTO Table (orig_name, size, mime_type, data) VALUES
('{$_FILES['userfile']['name']}', '{$_FILES['userfile']['size']}',
hi!
just a question: don't know it exactly: isn't it possible that the sql-user
on the server may not have enough rights to read the file?
anyway, i would save the file elsewhere on the server, because there are
remarkable performance-issues with big data (tried it once with storing
images for a
ma wrote:
just a question: don't know it exactly: isn't it possible that the sql-user
on the server may not have enough rights to read the file?
Yeah, could be. The uploaded file is already somewhere that PHP can
write to, though, so it's more than likely available for reading by any
other
hi!
thx for your feedback! just wondered about the sql-documentation saying that
the file must be readable t all users. (at least session-files are only
read/write-able to the php-user. so i was uncertain.. imho your solution is
much nicer for saving the file in the db (allthough it may be a bad
Douglas,
To try and reduce confusion, a Client install refers to the option
of that name in the Oracle9i Database Release installer. (The other
options are Database, Mgt Intg, and Cluster Mgt).
This will install the headers needed to link PHP, if your previous
installer choice didn't load them.
20 matches
Mail list logo