if there is a value in $HTTP_POST_VARS["variable_name"] then it came via a
form with method="POST", if there's a value in
$HTTP_GET_VARS["variable_name"] then it came from querystring or a form with
method="GET"
beau
// -Original Message-
// From: J-E-N [mailto:[EMAIL PROTECTED]]
// Sent
Hello there.
Is there a way to know whether a variable was passed by a form or just typed from the
address bar?
Hello...
I just installing RedHat linux 7.1, i have problem in starting mysql
server
the Mysql hadbeen installed throgh RedHatPackageManager...but when i
start it and error message "can't connect throgh port server."
issued .
when i use command >safe_mysqld & , it runs just a second
Hello !
I'd like to automatically delete old entries from my MySQL
Is there any special funcion in PHP or MySQl for doing that ?
For that purpose, I've created a PHP script (form) that delete old entries
when I submit a form ... but I'd like the scrip to do the job
periodically(for instance
I am trying to install the mcrypt libraries on a Windows 98 computer running
Apache1.3.20 and PHP 4.0.6. I cant really find anywhere on the net that
goes over the installation process, and the readme doesnt describe
installation. Does anyone know how to do this, or where I can find a site
that d
On 22-Aug-2001 Jay Paulson wrote:
> I've checked and the ROOT user has access to everything... but still no
> luck.. when i run the mysql -u root -p < 'all_databases.sql' it gets to the
> first table and tries to insert some information into it and says "blah
> table is read only" and it stops...
On 22-Aug-2001 Jay Paulson wrote:
> I've checked and the ROOT user has access to everything... but still no
> luck.. when i run the mysql -u root -p < 'all_databases.sql' it gets to the
> first table and tries to insert some information into it and says "blah
> table is read only" and it stops...
Dear all ^^ :
Thank for help!
The methods which had provided are test single php script page.
If I want to test performance of hole site (the site was constructed by php)
,
how should I do?
Thank for help again!
haheho
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mai
"Matthew Loff" <[EMAIL PROTECTED]> wrote in message
002b01c12b64$92e1cc80$0100a8c0@bang">news:002b01c12b64$92e1cc80$0100a8c0@bang...
>
> This has been covered countless times on the list... :)
>
> http://www.php.net/manual/en/function.mysql-insert-id.php
I figured as much. Thanks guys!
--
This has been covered countless times on the list... :)
http://www.php.net/manual/en/function.mysql-insert-id.php
-Original Message-
From: Grant Boggs [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 7:24 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Getting key of row just i
mysql_insert_id()
Grant Boggs wrote:
> What's the best way to get the primary key of a row just inserted into a
> mySQL database?
--
Chris Hobbs Silver Valley Unified School District
Head geek: Technology Services Coordinator
webmaster: http://www.silvervalley.k12.ca.
What's the best way to get the primary key of a row just inserted into a
mySQL database?
If the primary key is autoincrement, I insert a row. It's successful,
but now how to do I read back the key of this table?
Right now I'm adding a md5 hash of the session id into the row I'm
inse
Joe,
I built PHP with oracle and oci8 extensions. I built it as a static module for
Apache 1.3.20.
If you are getting errors from running 'configure' (something like it can't
locate the Oracle libraries) its because the Oracle 8 library searched for is
hard coded as libclntsh.so.8.0 corresponding
I know nothing about this, but did you investigate 'SHOW TABLE STATUS'
for any clues?
In article <018601c12b3c$2c2970b0$6e00a8c0@webdesign>,
[EMAIL PROTECTED] (Jay Paulson) wrote:
> I've checked and the ROOT user has access to everything... but still no
> luck.. when i run the mysql -u root -p
dang, messed up the order of statements, sorry.
of course it must read:
select count(*) from posts where category = 'foobar' group by category
regards, mike.
--
mfG, Michael Kumar (michael.kumar_at_nme.at, m.kumar_at_hushmail.com)
PGP: 30FE 3AB9 5077 C554 5D9E B5CC 0B0F CFB2 55D6 AA75
.: kno
Hi all,
I have Php 4.0.6 on Linux with Informix Dynamic Server 7.31.UD1.
I try to use the function ifx_num_rows after afx_query and the value
returned is always "0", but i can see
the result with ifx_fetch_row.
Does Anyone know if there is a bug with this function "ifx_num_rows" ?
Thanks in adv
try this :-)
echo "";
echo "";
$row= mysql_fetch_array($result);
$count = 0;
do
echo "http://www.charmed-guide.com/pictures/ "
.
$row["pic"] ".jpg\" target=_blank>\n";
echo "http://www.charmed-guide.com/pictures/"; .
$row["thumbnail"] . "_th.jpg\"border=0>\n";
echo "";
$coun
you do not need a counter, just use a 2 column table
| Thats my code!
|
| What I want to be able to do is have it so instead of one column there are
| two columns of pictures:
|
|
| pic1 | pic2
| pic3 | pic4
|
| etc..
|
|
| How can I do this?
|
| Thanks in advance!
|
|
select count(*), category from posts group by category
or
select count(*) from posts group by category where category = 'foobar'
should do the trick.
regards, mike.
--
mfG, Michael Kumar (michael.kumar_at_nme.at, m.kumar_at_hushmail.com)
PGP: 30FE 3AB9 5077 C554 5D9E B5CC 0B0F CFB2 55D6 AA75
I realize this is trivial... but if you're using things like the code
below alot it can clean things up a bit by using:
if (($counter % 2) == 0 && ($counter != 0))
echo "";
$counter++;
echo "\n";
Just reads easier... less branching, less code. In an ideal world it'd
optimize into machin
use that counter variable. check if its equal to 2 before incrementing, if
it is then "" and reset to zero, otherwise just increment.
if ($counter==2) {
echo "";
$counter=0;
} else {
$counter++;
}
marios
- Original Message - Original Message -
From: "Matt C" <[EMAIL PROT
On Wed, 22 Aug 2001, Tim O'Brien wrote:
> What is the best method to move data from access tables to postgreSQL?
>
> Are there are php functions that are available?
>
Unfortunately, only Access reads Access very well, but you can use ODBC
and linked tables in Access to copy it to PostgreSQL.
--
Running on RH, Apache. I had this working on Win2K, then switched to Linux
by running the mysqldump then moving over the dump file and runing the
mysql -u root -p < 'add_databases.sql'. It creates the database then the
table and then it tries to populate the table and i get an ERROR 1036: Table
'
What is the best method to move data from access tables to postgreSQL?
Are there are php functions that are available?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administr
unset($variable);
-Original Message-
From: Scott Fletcher [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 2:42 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] What's the PHP function for clearing out the garbage
code inside the variable?
Hi!
When I receive the data from the
Hi!
When I receive the data from the database, when it is empty and assigned
to a variable. I found that the variable contain garbage data in it. So,
what's the PHP function that will flush it out before I can assign it to the
variable?
Thanks,
Scott
--
PHP Database Mailing List (http
Thats my code!
What I want to be able to do is have it so instead of one column there are
two columns of pictures:
pic1 | pic2
pic3 | pic4
etc..
How can I do this?
Thanks in advance!
http://www.charmed-guide.com/pictures/$row[2].jpg\";
target=_blank>\n");
printf("htt
What module did you build PHP with? We tried rebuilding PHP 4.06 with oci8
after upgrading to 9i and apparently the client libraries were missing. Am I
missing something?
Tom Tsongas wrote:
> Hi folks.
>
> My group recently switched from an 8i to a 9i database. I recompiled
> PHP4.0.6 against Or
actually the owner of the tables/files that "all_databases.sql" creates is
mysql.mysql.. and it still says read only.. and they are chmod'ed to 660...
like i said before i'm really lost as to why it's doing this.
jay
- Original Message -
From: "Brunner, Daniel" <[EMAIL PROTECTED]>
To: "'
I've checked and the ROOT user has access to everything... but still no
luck.. when i run the mysql -u root -p < 'all_databases.sql' it gets to the
first table and tries to insert some information into it and says "blah
table is read only" and it stops...
jay
- Original Message -
From: "
There are a few different things you can test here...
I. Server Performance (overall)
I don't have the name of any specific tool off hand, but basically you
would request a slew of .php pages off of the server via HTTP and record
how many pages/second actually are served up. This is really the
Hi folks.
My group recently switched from an 8i to a 9i database. I recompiled
PHP4.0.6 against Oracle 9i and everything went smoothly. However, when I
attempt to execute my PHP code, I get the following error:
ORA-12541: TNS:no listener
My database admin says that the connection information is
This would probably be a better question for a MySQL newsgroup...
Anyway, I am just talking off the top of myhead since I never did
anything like this, but i don't think copying DB files is the proper way
to move databases. I believe there is some MySQL dump utility you need
to create one tra
Hello!!!
Make sure that the ownership of the files are
mysql.mysql
This as happened to me too!!!
I might be wrong but it worked for me
Dan
> --
> From: Jay Paulson
> Reply To: Jay Paulson
> Sent: Wednesday, August 22, 2001 11:29 AM
> To: [EMAIL PR
Are your privileges in MySQL set correctly? If ROOT doesn't have read/write
access, the script will crash.
rick
-Original Message-
From: Jay Paulson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 11:29 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] restoring
Also, I should mention that I have glanced at two methods:
iODBC and OpenRDA, but I'd like to know if I can use PHP's dl() function to
simply load them when needed, instead of having to recompile...
- Jonathan
"Jonathan Hilgeman" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAI
Hi,
I have this code after a user submits a form with name, description and
image file upload fields:
images/people/preview is simply a unix link to /tmp/phptempimg-ian.grant
The problem is, when this script is run, the image show is that from the
previous operation. If you refresh the page, the
I'm not exactly sure how to go about using PHP on a FreeBSD box to connect
to an Access database on a Windows NT/2000 machine. I tried odbc_connect and
just got an "undefined function" error. But beyond that, all I have is a URL
to the database file, and a username and password.
I've heard some s
Hello everyone-
I have done the mysqldump function and got the db in a all_database.sql
file. Now I am running this command at the shell prompt of my Linux
machine:
mysql -u root -p -e 'all_databases.sql'
When I do that it works fine until it starts to insert the information into
the database.
Hi everyone,
Does anyone knows how i can create a job in oracle to go to a specify url
or send a email
Thanks a lot.
Fernando Ferreras
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact
Try apache benchmarking tool to view what is the peak of executions per
second.
I don't use linux but think that the name of the executable is 'ab'
Andrey Hristov
http://www.icygen.com
99%
- Original Message -
From: "haheho" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday,
Hi,
You can get the time(); or microtime(); (in linux) in the beginning and in
the endo of the code..
example:
[]s
Ferreras
> Dear all:
>
> I have wrote a php program and use mysql database.
> Is there a way to test its performance?
> Thanks.
>
> haheho
>
>
>
> --
> PHP Database Mailin
Dear all:
I have wrote a php program and use mysql database.
Is there a way to test its performance?
Thanks.
haheho
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrato
Anyone know why a MySQL table is set to read only? I'm logged in as the
root user of MySQL and I have checked the privalages of the root user in the
MySQL table and everything is set to "Yes" and I'm able to add and delete
users in the MySQL table.
Here's what I did... I had a database on my Win
Does anyone know how to get the _binary_ extensions for PHP installed with
SuSE 7.2 ?
I think it needs to recompile... But I wanted a easier way to solve it...
Thanks,
Ridai Govinda
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional c
I'm not sure what any of the posted sample code is really trying to get at
... but from what I gather you want:
a) Links at the top of the page, allowing somebody to jump to the
beginning of the section of people's who's last name begins with that
letter.
b) The names all come from the databas
Hi
Does anyone knows if the latest stable version of MySQL 3.23.41 can work
smootly with a PHP 3.0.16 application?
I have successfully upgraded the MySQL but the PHP application could not
connect the DB.
Venelin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMA
Hi,
is there a way to treat the output of ibase_blob_echo?
I want to do some str_replace with its content before displaying it.
thank you,
yves
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To con
- Original Message -
From: Russ Michell <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 10:16 PM
Subject: [PHP-DB] Query construction (again)
> Hey there folks - similar problem - different project!
>
> I want to select some records for a period of 7days afte
- Original Message -
From: Russ Michell <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 10:16 PM
Subject: [PHP-DB] Query construction (again)
> Hey there folks - similar problem - different project!
>
> I want to select some records for a period of 7days afte
The NAME indicator (#), must precede the data separator (?).
I think what you want is:
$member
To use the NAME indicator, your line would read: $member
which I doubt is what you want.
Richard Emery
-Original Message-
From: Howard Picken [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, Augu
Hey there folks - similar problem - different project!
I want to select some records for a period of 7days after their insert [dateFrom] date.
Last time I asked you guys for help I was helped toward the following solution:
$sql = "SELECT * FROM $Tpostings WHERE now()>=dateFrom AND now()http://ww
What do you mean when you say "...with accents out of the database, the
charactes don't come out correctly"?
Can you show example of data in database and that which is output?
Richard Emery
Excel Communications, Inc.
IT Sr. Project Manager
(972) 478-3398
(972) 944-0542 (pager)
There is no "try
On Wednesday 22 August 2001 14:34, Patrik Wallstrom wrote:
> On Wed, 22 Aug 2001, Yves Glodt wrote:
> > Hello,
> >
> > I'm in trouble with my current project which uses Interbase as
> > backend. (php.ini: magic_quotes_sybase = On)
> > When I insert a string containing a ', like Beverly D'Angelo,
>
On Wed, 22 Aug 2001, Yves Glodt wrote:
> Hello,
>
> I'm in trouble with my current project which uses Interbase as backend.
> (php.ini: magic_quotes_sybase = On)
> When I insert a string containing a ', like Beverly D'Angelo,
> php saves it with two '
> When I insert it with two ', it gets saved
Hello,
I'm in trouble with my current project which uses Interbase as backend.
(php.ini: magic_quotes_sybase = On)
When I insert a string containing a ', like Beverly D'Angelo,
php saves it with two '
When I insert it with two ', it gets saved with four '
Short: php multiplies all the ' by facto
I guess it depends on the ODBC driver. If it lets you pass commands
directly to the database, something like s SQL_PASSTHRU, use that faciity.
Otherwise use the SELECT command to fetch the first record. Normally this
is a two step process: execute the select, then use a while loop to step
thro
that would generally work on the assumption that many photos can belong to
many albums. possibly a bad thing.
> table 1
> > -userid (primary key)
> > -username
> > -password
> > -album_title
> > -creation_date
>
> table 2
> > -photoid (primary key)
> > -photo (jpg or gif)
> > -date
> > -photo_tit
With Interbase functions I have to make 2 select.
"SELECT count(*).. to count valid record
and
"SELECT * .. to extract the records
There is a simple solutions to have unique Select ?
I use Pgsql too but here I Have the pg_numrows variable.
Someone sau to me:
just make the "SELECT * .. to extrac
Im using mysql together with php. When I get words that contain characters
with accents out of the database, the charactes don't come out correctly.
The characters are stored correctly in the database, when I print the
contents of a table, the characters are displayed correctly...
What could be t
Can someone tell me where I can find already done benchmarks of Oracle
compared to other RDBMSes like DB2, MySQL,PostgreSQL or how many connection
will get oracle8i on a machine with 512 or 1024MB RAM, dual CPU PIII 500 or
dual PIII 1.1Ghz.
Sincerely : Andrey Hristov
IcyGEN Corporation
http://ww
Thanks Walter
Sorry. I should have thought about more details.
I'm using
echo "$member";
(within php4 code)
When I try this it just goes to the first letter (A) page
because I've used an Isset on $memltr in members.php setting it
to A if empty.
It seems to be having trouble parsing out the p
Where do you have this "a href" tag?
?
?>
2: ?
===
If 1)
print "$member";
if 2)
Should work
> -Original Message-
> From: Howard Picken [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 22, 2001 10:50
> To: [EMAIL PROTECTED]
> Subj
Hi
I'm trying to use the A NAME tag on a php4 generated page.
The pages being generated are alphabetically list
(e.g. Page just lists people with surname starting with A)
$member
It doesn't work of course. Anyone have any ideas?
Howard Picken
--
PHP Database Mailing List (http://www.php.ne
Please help me !
How to move recordset to the first record (i use to connect to database
using ODBC).
Thank you !
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administr
65 matches
Mail list logo
