Is there a standard for inserting data into Oracle tables from a user input
field in PHP?
Most Oracle tables will have a limit on the amount characters such as
Name VARCHAR2(60 BYTE) - this means the maximum amount of characters allowed is
60.
If you use special characters in PHP such as
geekgirl1 wrote:
First time poster.
This is the problem. I want to add the value of $_POST[review] to the
reviews table where the unique id from the reviews table equals the
review id on my form. The statement below does not work. Should I
use UPDATE instead?
INSERT INTO reviews
Chris Payne wrote:
Hi there everyone,
I'm using FTP to upload a file from a form, the information is stored in a
MySQL DB and then FTP'd to the server. Is it possible - without altering
the php.ini file as I don't have access to this on my clients server - to be
able to upload large files
check the length of your vairables before you insert...if its web based app,
then you should limit the input anyway and validate it that it matches the
desired data
Bastien
From: David Skyers [EMAIL PROTECTED]
To: php-db php-db@lists.php.net
Subject: [PHP-DB] inserting data into Oracle
You also need to consider your character
set. VARCHAR2(60 BYTE) means it only allows 60 bytes not 60 characters.
Some character sets use multiple bytes (2 or 3) for some characters.
You could define your table as VARCHAR2(60 CHAR) or set your nls_length_semantics
to CHAR.
I would also suggest
I'm trying to figure out if running mysql_connect or mysql_pconnect
would be faster.
Can someone explain the difference?
Picking one for a very high traffic website with a 10 G database.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Read the comments following the formal description at
http://www.php.ca/mysql_pconnect
They're pretty illuminating, and probably resulted from hard-earned experience.
Miles
At 11:47 AM 12/8/2005, Benjamin Adams wrote:
I'm trying to figure out if running mysql_connect or mysql_pconnect
would
Is that a syntax supported by MySQL? That is, an INSERT with WHERE clause?
I tried it against Oracle, and it doesn't work (can you imagine how
upsetting it would have been to have learned that, after having worked with
SQL for several years, one can do an update using an INSERT statement?).
I'm
In full agreement here. I scratched my head this morning, then looked up
INSERT in the MySQL Docs for a sanity check. It must be an UPDATE
statement to work as indicated below.
David
Sorry David Mitchell
==
Is that a
Hi there everyone,
How do I set the following items with ini_set()? I looked at the manual but
when I try nothing happens:
* file_uploads
* upload_max_filesize
* max_input_time
* memory_limit
* max_execution_time
* post_max_size
Basically I need to
ini_set('max_execution_time', 9600);
that's how you set the max_execution_time, i would assume the rest follow
the same format.
notice the time is in seconds.
--
Joseph Crawford Jr.
Zend Certified Engineer
Codebowl Solutions, Inc.
1-802-671-2021
[EMAIL PROTECTED]
I keep getting the following, can someone from the staff rectify this please
Your message
To:
Subject: Re: [PHP-DB] Restricting What's Retreived
Sent: Thu Dec 08 09:56:44 2005
did not reach the following recipient(s):
[EMAIL PROTECTED] on Thu Dec 08 09:56:44 2005
The
snip
How about:
$review = $_POST['review'];
$sql = SELECT * FROM reviews WHERE review_id = '$id';
$res = mysql_query($sql) or die (Query failed: . mysql_error());
if (mysql_num_rows($res) 0)
{
$sql_upd = UPDATE reviews
SET review_text = '$review'
If I have
$variable = play_time;
how may I remove play_ from $variable and just have $variable equal to
time?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
str_replace
$var = play-time;
$var = str_replace(play-,,$var);
regex
$var = eregi_replace([play-],,$var);
B
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Manipulating text
Date: Thu, 08 Dec 2005 21:25:39 -0500
If I
Hi there everyone,
I found the PERFECT JAVA Applet for my PHP needs, it allows me to drag and
drop and it uploads via FTP to the server very nicely with progress bar etc
however, with this it doesn't send the file name to PHP which is what I
urgently need.
How can I list a directory
16 matches
Mail list logo