Thanks for telling me the 'explode' command. Ron
On Fri, 2005-12-09 at 08:07 +0530, Amol Hatwar wrote:
> On Thu, 2005-12-08 at 21:25 -0500, Ron Piggott (PHP) wrote:
> > If I have
> >
> > $variable = "play_time";
> >
> > how may I remove "play_" from $variable and just have $variable equal to
>
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 an
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
Subject: [PHP-DB] Manipulating text
Date: Thu, 08 Dec 2005 21:25:39 -0500
If I have
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
Geekgirl,
Let me expand on the answers so far...
There are two things you can do here: add a new record or update an
existing one. In SQL this makes a big difference and in your
question you've confused the two (MySQL has a trick which kind of
mixes the two and it is limited). I'm not ex
** Comments Inline **
*chop*
> Basically I need to be able to upload 1gig files via FTP which is based on
Whoa! Did I read ONE GIG? By FTP I understand *the* File Transfer
Protocol. How is it based on PHP?
> PHP, when the file uploads successfully it then adds the info to a mysql
> database so t
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'
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
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]
you can try this
select SUBSTRING(field,0,100) from table
--
Joseph Crawford Jr.
Zend Certified Engineer
Codebowl Solutions, Inc.
1-802-671-2021
[EMAIL PROTECTED]
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 b
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
Does anyone know when you get info from a DB, can you restrict how many
characters it gets from it? say you had a paragraph 1,000 letters but you
only wont it to get 100 how would you do that?
Based on my understanding of pconnect, it is a poor man's implementation
of connection pooling. Connection pooling requires a mediator server
between the client and database in order to maintain a connection for
reuse by another client. PHP does not provide such a server, so it uses
the web server
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 pr
great article at www.phpbuilder.com
http://phpbuilder.com/columns/ying2602.php3?aid=19
Bastien
From: Craig Hoffman <[EMAIL PROTECTED]>
To: [email protected]
Subject: [PHP-DB] Session handler - Info wanted
Date: Thu, 8 Dec 2005 11:04:29 -0600
Hi There,
I'm going to write my own session
Hi There,
I'm going to write my own session handler for an upcoming project.
I would like to store the session data in MySQL. I've never written
one before; so if anyone has any tips, suggestions, in-sight, etc...
please share.
Thanks,
Craig
___
Craig Hoffman
www.ecl
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 b
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
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
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"
Subject: [PHP-DB] inserting data into Oracle tables
Date: Thu, 8
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 r
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 (review
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 ente
24 matches
Mail list logo
