Hi,
Does anybody have an idea on how I could install the oracle client/libraries
required to build PHP with OCI support without using the OUI.
The server is headless, and behind a firewalls, so X-Server is not an
option, it also has no local CD-Rom, just to add to the problem.
Platform :=
Thanks Walter
Sorry. I should have thought about more details.
I'm using
echo a href=\/members/members.php?$memltr#$member\$member/a;
(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.
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
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 extract
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_title
-description
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
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 with
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
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()dateTo;
The NAME indicator (#), must precede the data separator (?).
I think what you want is:
a href=\/members/members.php?$memltr=$memb\$member/a
To use the NAME indicator, your line would read: a
href=\/members/members.php#$memb?$memltr\$member/a
which I doubt is what you want.
Richard Emery
- 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 after
- 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 after
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
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:
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
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
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
Hi,
You can get the time(); or microtime(); (in linux) in the beginning and in
the endo of the code..
example:
?
$t1 = time();
code...
$t2 = time();
echo Total time is.($t2 - $t1).seconds.;
?
[]s
Ferreras
Dear all:
I have wrote a php program and use mysql database.
Is there a way to
?php
$starttime=explode(' ',microtime());
// code is here
//
//
$endtime=explode(' ',microtime());
$starttime=$starttime[1]+$starttime[0];
$endtime=$endtime[1]+$endtime[0];
$parse_time=$endtime-$starttime;
?
Try apache benchmarking tool to view what is the peak of executions per
second.
I don't
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
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
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,
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:[EMAIL
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
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
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
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: 'Jay
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
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!
?php
$mysql_access = mysql_connect(, **, *);
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
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
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
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.
--
use that counter variable. check if its equal to 2 before incrementing, if
it is then BR and reset to zero, otherwise just increment.
if ($counter==2) {
echo BR;
$counter=0;
} else {
$counter++;
}
marios
- Original Message - Original Message -
From: Matt C [EMAIL
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 BR;
$counter++;
echo img src=whatever...\n;
Just reads easier... less branching, less code. In an ideal world it'd
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
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!
|
try this :-)
echo TABLE border=1 WIDTH=\80%\ ALIGN=CENTER;
echo TR;
$row= mysql_fetch_array($result);
$count = 0;
do
echo TD ALIGN=CENTERa href=\http://www.charmed-guide.com/pictures/
.
$row[pic] .jpg\ target=_blank\n;
echo img src=\http://www.charmed-guide.com/pictures/; .
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
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
.:
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
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
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:
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
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!
--
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,
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
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
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 there.
Is there a way to know whether a variable was passed by a form or just typed from the
address bar?
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:
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:
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
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...
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
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
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
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
59 matches
Mail list logo