Re: [PHP-DB] Connecting to database fails

2016-08-15 Thread Rich Shepard
On Sat, 13 Aug 2016, Lester Caine wrote: Do you actually have the postgresql PHP driver installed. Database drivers are not installed by default as you only really need the ones you are actually using. Should be installed: /usr/lib/php/extensions/pgsql.so

Re: [PHP-DB] Connecting to database fails

2016-08-13 Thread Lester Caine
On 14/08/16 00:00, Rich Shepard wrote: > Ah, yes. Pat likes MySQL/MariaDB so he does not build php to support > postgres. I'll rebuild it and that should solve the problem. I've been with Firebird/Interbase since before PHP existed ;) -- Lester Caine - G8HFL -

Re: [PHP-DB] Connecting to database fails

2016-08-13 Thread Rich Shepard
On Sat, 13 Aug 2016, Rich Shepard wrote: Not installed. I'll search the Web to learn how to install it. Ah, yes. Pat likes MySQL/MariaDB so he does not build php to support postgres. I'll rebuild it and that should solve the problem. Thanks again, Rich -- PHP Database Mailing List

Re: [PHP-DB] Connecting to database fails

2016-08-13 Thread Rich Shepard
On Sat, 13 Aug 2016, Lester Caine wrote: Do you actually have the postgresql PHP driver installed. Database drivers are not installed by default as you only really need the ones you are actually using. Lester, Well, that would make a difference. I did not know how to check for this.

Re: [PHP-DB] Connecting to database fails

2016-08-13 Thread Lester Caine
On 13/08/16 21:23, Rich Shepard wrote: > With no other PHP applications installed here I have no experience in > determining where this stoppage occurs. Pointers on how to isolate the > source of the problem, than how to fix it, are needed. Do you actually have the postgresql PHP driver

[PHP-DB] Connecting to database fails

2016-08-13 Thread Rich Shepard
I'm trying to install and run an abandoned PHP-based application (xrms found on sourceforge.net last updated a decade ago) on Slackware-14.1 running httpd-2.4.16, php-5.6.24, adodb-5.14, and postgresql-9.3.4. When I try to load the install.php script in firefox-45.3 I see this error: Syntax

RE: [PHP-DB] [PHP] PHP Database Problems -- Code Snippets - Any more Ideas?

2012-05-04 Thread Gavin Chalkley
2012 15:10 To: php-db-lists.php.net; php-gene...@lists.php.net Subject: [PHP-DB] [PHP] PHP Database Problems -- Code Snippets - Any more Ideas? I am sending this again to see if more ideas for solution of this problem are available. Ethan === Dear list - Sorry for the attachment. Here

[PHP-DB] Seeking PHP database talks

2011-08-09 Thread Joshua D. Drake
Hey folks, PostgreSQL Conference West is closing its CFP this week. Would love to see some PHP talks there this year! https://www.postgresqlconference.org/talk_types Sincerely, JD -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services

[PHP-DB] Updating MySQL Database after install

2010-05-04 Thread Karl DeSaulniers
Hi, I am wanting to get some pointers on how to update my MySQL database after there is already members. For eg, I am trying to set some foreign keys that were not part of my database when I installed it. There are members in that database. Can I update the database with the new .sql file

Re: [PHP-DB] Updating MySQL Database after install

2010-05-04 Thread kesavan trichy rengarajan
You need to use the ALTER statement. doc: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html http://dev.mysql.com/doc/refman/5.1/en/alter-table.htmlexample: http://www.1keydata.com/sql/sql-foreign-key.html On Wed, May 5, 2010 at 8:21 AM, Karl DeSaulniers k...@designdrumm.comwrote: Hi, I

[PHP-DB] Access a database on another domain

2009-08-02 Thread Neil Jackson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I host a number of running clubs websites. They are all hosted on different domains on a hosting service. They all share a common database table of fixtures. At present I have copied the database table to each domain but this time consuming. I

Re: [PHP-DB] Access a database on another domain

2009-08-02 Thread Chris
Neil Jackson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I host a number of running clubs websites. They are all hosted on different domains on a hosting service. They all share a common database table of fixtures. At present I have copied the database table to each domain but

Re: [PHP-DB] Access a database on another domain

2009-08-02 Thread Bastien Koert
On Sun, Aug 2, 2009 at 10:15 PM, Chrisdmag...@gmail.com wrote: Neil Jackson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I host a number of running clubs websites. They are all hosted on different domains on a hosting service. They all share a common database table of

[PHP-DB] backup of database record before update

2007-10-28 Thread Ronald Wiplinger
I need some hints how to do that. Maybe there is a template or an easy function available. I have a MySQL database with some tables. Everytime a table record changes, I want also put the old record to a history database. The history table and the original only differs that the key of the

[PHP-DB] Question about database design

2007-10-24 Thread Jason Pruim
I sent this to the MySQL list but didn't receive any response, My apologies if you have already received this. Hi Everyone, So having learned my lesson with the last application, I am trying to plan out the addition of a feature to my database application. Basically, some of my

Re: [PHP-DB] Question about database design

2007-10-24 Thread Tim McGeary
Hi Jason, There are a couple ways you could do this. Yes, this would make it a relational database. If you go with a second table, you'll want to be sure to include the UID from the main address table in the SnowBirds table so that they are linked. The UID in the second table would

RE: [PHP-DB] Question about database design

2007-10-24 Thread Bastien Koert
in the addresses to be able to pull the correct one based on date bastien To: php-db@lists.php.net From: [EMAIL PROTECTED] Date: Wed, 24 Oct 2007 09:06:29 -0400 Subject: [PHP-DB] Question about database design I sent this to the MySQL list but didn't receive any response, My apologies if you have

Re: [PHP-DB] Question about database design

2007-10-24 Thread Jason Pruim
Hi Tim, Right now the customer I have has about 1,000 records which I know isn't alot for MySQL to handle, but if people like the application we could end up with 15 to 20 all having around 1,000 or more records which would add up more on the database. Although right now I plan to have a

Re: [PHP-DB] Question about database design

2007-10-24 Thread Jason Pruim
to be able to pull the correct one based on date bastien To: php-db@lists.php.net From: [EMAIL PROTECTED] Date: Wed, 24 Oct 2007 09:06:29 -0400 Subject: [PHP-DB] Question about database design I sent this to the MySQL list but didn't receive any response, My apologies if you

Re: [PHP-DB] Question about database design

2007-10-24 Thread Tony Grimes
A second address table is definitely the way to go (the '*' signifies the primary key): People Table *user_id first_name last_name etc Address Table (compound primary key) = *user_id (fk to People Table) *address_id *obs_no (you can skip this if you don't want to keep an

RE: [PHP-DB] Question about database design

2007-10-24 Thread Bastien Koert
Nope, you got it Bastien CC: php-db@lists.php.net From: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Question about database design Date: Wed, 24 Oct 2007 15:18:05 -0400 To: [EMAIL PROTECTED] I think I understand what you are saying here... On the main table just

RE: [PHP-DB] Forking and database connections

2007-04-23 Thread Dwight Altman
), so it is already closed. Regards, Dwight -Original Message- From: Chris Verges [mailto:[EMAIL PROTECTED] Sent: Saturday, April 21, 2007 12:21 PM To: php-db@lists.php.net Subject: [PHP-DB] Forking and database connections Hey all, I'm writing a PHP script that queries a database

RE: [PHP-DB] Forking and database connections

2007-04-23 Thread Dwight Altman
To: 'php-db@lists.php.net' Subject: RE: [PHP-DB] Forking and database connections http://php.he.net/manual/en/function.pcntl-fork.php says 'The reason for the MySQL Lost Connection during query...' like what you concluded, although they grab a new $db connection in the first for loop } else

Re: [PHP-DB] Forking and database connections

2007-04-23 Thread Chris Verges
and execute. Regards, Dwight -Original Message- From: Dwight Altman [mailto:[EMAIL PROTECTED] Sent: Monday, April 23, 2007 10:09 AM To: 'php-db@lists.php.net' Subject: RE: [PHP-DB] Forking and database connections http://php.he.net/manual/en/function.pcntl-fork.php says

RE: [PHP-DB] Forking and database connections

2007-04-23 Thread Dwight Altman
:01 PM To: Dwight Altman; php-db@lists.php.net Subject: Re: [PHP-DB] Forking and database connections Hey Dwight, Thanks for the replies! When the first child thread closes, all of the DB connections seem to close. That is, the $db-execute() statements will fail in the child threads

RE: [PHP-DB] Forking and database connections

2007-04-23 Thread Dwight Altman
To use a PEAR::DB persistent connection, try $db = DB::connect($dsn, TRUE); or $db = DB::connect($dsn, true); Googled for pear::db persistent connection and got http://vulcanonet.com/soft/?pack=pear_tut Regards, Dwight -Original Message- From: Dwight Altman [mailto:[EMAIL PROTECTED]

Re: [PHP-DB] Forking and database connections

2007-04-23 Thread Chris Verges
Hey Dwight, After getting your first e-mail, I started adding the PEAR::DB persistent connection code. Unfortunately, it yielded the same results that I was getting before. At a hunch, I created a second proof-of-concept script that uses the mysql_* functions in the PHP base. For each of

Re: [PHP-DB] Forking and database connections

2007-04-23 Thread Chris Verges
For anyone interested in following the progress of this forking/PEAR::DB issue, see http://pear.php.net/bugs/bug.php?id=10813. Thanks, Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Forking and database connections

2007-04-23 Thread Dwight Altman
Glad to help. I was actually interested in your post because of forking versus threading. I still haven't found anything except for PHP-GTK but it may help your database related performance if it is added/exists in PHP. Regards, Dwight -Original Message- From: Chris Verges

[PHP-DB] Forking and database connections

2007-04-21 Thread Chris Verges
Hey all, I'm writing a PHP script that queries a database for some records, splits the records into N number of groups of equal size, and then creates N number of forks where each child handles one of the groups. During the execution of each of the child processes, I'd like the parent process to

[PHP-DB] help in database design

2007-03-28 Thread Suprie
hi all, i need help in design a database, our office is hospital equipment supplier, we had a list of items, each items had it's own configuration, and each item could consist of several item. we also had contract that have a lot of site, sometimes equipmend that have been ordered different from

Re: [PHP-DB] help in database design

2007-03-28 Thread bedul
what is site mean in here?? - Original Message - From: Suprie [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Wednesday, March 28, 2007 5:03 PM Subject: [PHP-DB] help in database design hi all, i need help in design a database, our office is hospital equipment supplier, we had

Re: [PHP-DB] help in database design

2007-03-28 Thread Chris
Suprie wrote: hi all, i need help in design a database, our office is hospital equipment supplier, we had a list of items, each items had it's own configuration, and each item could consist of several item. we also had contract that have a lot of site, sometimes equipmend that have been

Re: [PHP-DB] help in database design

2007-03-28 Thread bedul
NOT QUITE..ups.. my bad - Original Message - From: Chris [EMAIL PROTECTED] To: Suprie [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Thursday, March 29, 2007 6:53 AM Subject: Re: [PHP-DB] help in database design Suprie wrote: hi all, i need help in design a database, our

[PHP-DB] Re: mssql Database name grater than 30 characters

2007-03-03 Thread Haydar TUNA
Hello, All of objects that you created in SQL Server is in the master database. In this database, there is a table called sysobjects that put all of information about tables and so on. You can see table name length in this table :) -- Haydar TUNA Republic Of Turkey - Ministry of

[PHP-DB] query on database determines image swap in php-coded page?

2005-07-27 Thread Elaine Miller
Hi, I'm a designer of simple webpages, and an enthusiastic user of PHP applications that run with MySQL -- but I don't write, or think in, PHP, so I can't quite figure how to do this: I run phpbb forum software (yes, I've asked at phpbb and at phpbbhacks, no luck) and I have installed for our

[PHP-DB] Searchable/Sortable Database Fields with MySQL/PHP

2005-07-12 Thread Matt McNeil
Greetings, I need to securely store lots of sensitive contact information and notes in a (MySQL or other freely available) database that will be stored on a database server which I do not have direct access to. This database will be accessed by a PHP application that I am developing. However, I

Re: [PHP-DB] Searchable/Sortable Database Fields with MySQL/PHP

2005-07-12 Thread Micah Stevens
Just do all your searching/sorting in PHP.. it would be slower, and if your dataset is very large (sounds like it might be the case) it would be impossible.. So that might be out of the question.. A bit of system engineering might find a solution too, consider which fields you need to

Re: [PHP-DB] Searchable/Sortable Database Fields with MySQL/PHP

2005-07-12 Thread Micah Stevens
Oh! Also, there's built in mysql functions for encryption, I forgot about that, so you can still search, like this: insert into table set name_field = AES_ENCRYPT('Some name', 'secret key'); select * from table where AES_DECRYPT(name_field,'secret key') LIKE '%some'; Make sense? You'll want an

RE: [PHP-DB] Re: Handling database calculations with a php page

2005-03-22 Thread JeRRy
Thankyou :) --- Bastien Koert [EMAIL PROTECTED] wrote: Yes, the 'a' value can also be a table alias name. Bastien From: JeRRy [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Re: Handling database calculations with a php page Date: Mon, 14 Mar 2005 19:46:46 +1100 (EST

[PHP-DB] Re: Handling database calculations with a php page

2005-03-14 Thread JeRRy
Hi, So in other words when we are talking queries anything before a . for SELECT etc means table name and after the . means column name within that table? So... (table_name).(Column_name) ? Is that right? J Find local movie times and trailers on Yahoo! Movies. http://au.movies.yahoo.com --

Re: [PHP-DB] Re: Handling database calculations with a php page

2005-03-14 Thread Miles Thompson
That's the convention. You HAVE TO: - read and use the manual, the rest of us do - dig out and follow a tutorial on working with PHP and databases If you do not, you will have no real knowledge of what you're doing, only a piecemeal Someone said to do it this way. Do this BEFORE

RE: [PHP-DB] Re: Handling database calculations with a php page

2005-03-14 Thread Bastien Koert
Yes, the 'a' value can also be a table alias name. Bastien From: JeRRy [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Re: Handling database calculations with a php page Date: Mon, 14 Mar 2005 19:46:46 +1100 (EST) Hi, So in other words when we are talking queries anything before

Re: [PHP-DB] Re: Handling database calculations with a php page

2005-03-13 Thread Miles Thompson
First of all, check the SELECT statement in your database documentation, because you do this within your select. It is important you that you inform yourself about this, because you will use it a lot. So this is not really a PHP question. The statement is written something like this: SELECT

Re: [PHP-DB] preg_replace and database

2005-02-21 Thread Petar Nedyalkov
On Sunday 20 February 2005 00:52, zgr Odabasi wrote: hi all, I have trouble with preg_replace and querying database, my code is below, ?php include(h/h.php); function getImgAttributes($id){ $dsn = array( 'phptype' = mysql, 'hostspec' = localhost, 'database' = db,

[PHP-DB] preg_replace and database

2005-02-19 Thread Özgür Odabasi
hi all, I have trouble with preg_replace and querying database, my code is below, ?php include(h/h.php); function getImgAttributes($id){ $dsn = array( 'phptype' = mysql, 'hostspec' = localhost, 'database' = db, 'username' = root,

[PHP-DB] preg_replace and database

2005-02-19 Thread Özgür Odabasi
hi all, I have trouble with preg_replace and querying database, my code is below, ?php include(h/h.php); function getImgAttributes($id){ $dsn = array( 'phptype' = mysql, 'hostspec' = localhost, 'database' = db, 'username' = root, 'password' = pass ); $myDbc =

[PHP-DB] Object oriented database in PHP?

2004-12-20 Thread symbulos partners
Has anybody implemented an object oriented database in PHP yet? -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Object oriented database in PHP?

2004-12-20 Thread John Holmes
From: symbulos partners [EMAIL PROTECTED] Has anybody implemented an object oriented database in PHP yet? No... PHP would not be a suitable programming language to create a database in... If you mean an OO abstraction layer to a database, however... then yeah. ---John Holmes... UCCASS -

RE: [PHP-DB] versioning a database

2004-12-10 Thread Norland, Martin
-Original Message- From: Chris Wagner [mailto:[EMAIL PROTECTED] what i want to do is version a database. i am not sure if i am using the right word for this, but... [snip] * where, in the MySQL database could i store a version number? i know Tables have a comment field, which

[PHP-DB] versioning a database

2004-12-09 Thread Chris Wagner
hello. what i want to do is version a database. i am not sure if i am using the right word for this, but... you see, i am constantly modifying the format of various tables within my MySQL database, for use with my PHP app. It is difficult to keep track of places in the code that need to be

RE: [PHP-DB] backing up database with mysqldump

2004-10-25 Thread Perry, Matthew (Fire Marshal's Office)
: Re: [PHP-DB] backing up database with mysqldump MySQLdump is an executable program. From the command line: C:\mysqldump databasename ./path/to/backup/file.sql (or file.txt ) C:\mysqldump --help gives all the options dave Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED

RE: [PHP-DB] backing up database with mysqldump

2004-10-25 Thread dpgirago
C:\mysqldump -uadministrator -p test test.sql Enter password: ** Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED] 10/25/2004 01:53 PM To: [EMAIL PROTECTED] cc: Subject: RE: [PHP-DB] backing up database with mysqldump How do I provide a password? I

RE: [PHP-DB] backing up database with mysqldump

2004-10-25 Thread Norland, Martin
Research Hospital. -Original Message- From: Perry, Matthew (Fire Marshal's Office) [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 1:53 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] backing up database with mysqldump How do I provide a password? I have been trying -p password

RE: [PHP-DB] backing up database with mysqldump

2004-10-25 Thread Norland, Martin
Hospital. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 2:10 PM To: Perry, Matthew (Fire Marshal's Office) Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] backing up database with mysqldump C:\mysqldump -uadministrator -p test test.sql Enter

Re: [PHP-DB] backing up database with mysqldump

2004-10-25 Thread David Orlovich
25, 2004 11:24 AM To: Perry, Matthew (Fire Marshal's Office) Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] backing up database with mysqldump MySQLdump is an executable program. From the command line: C:\mysqldump databasename ./path/to/backup/file.sql (or file.txt ) C:\mysqldump --help gives all

[PHP-DB] downloading from database

2004-10-11 Thread Adil
Hey everyone, I have a question about downloading from a mySQL database, running php on Apache. Basically right now I'm working on this file upload download tool. You login, see a list of files, (upload functionality works great). You click on a file name which pops up the new file in a new

[PHP-DB] Re: Which Database Abstraction Layer ?

2004-09-02 Thread pete M
ADODB Jean-Philippe côté wrote: Hi, I'm trying to choose a database abstraction layer for a project and I'm having difficulty making up my mind. The two I'm currently looking at are: ADOdb and MDB2 (from PEAR). I was recommended to use MDB2 but its still a beta version and the documentation is

[PHP-DB] Variables in database content

2004-05-23 Thread Brian Stoffer
Hi there. I have what I suspect is an easy one, but was unable to find something similar in the archives (it's a tough one to search for...). Basically I have a table with a text block column. The actual content that lives in column contains php variables that I want to be able to use when I

RE: [PHP-DB] Variables in database content

2004-05-23 Thread Sunmaia
Hi you need eval() http://uk2.php.net/manual/en/function.eval.php HTH Peter -Original Message- From: Brian Stoffer [mailto:[EMAIL PROTECTED] Sent: 23 May 2004 23:34 To: [EMAIL PROTECTED] Subject: [PHP-DB] Variables in database content Hi there. I have what I suspect

[PHP-DB] Use of database

2004-03-27 Thread Will
I have searched but I cannot find anything that will help me. I am using phpMyAdmin and I want to have a user not see the privilages, mysql info and such. How do you get rid of those links in the main page. Thank in adanvce. ~WILL~ -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] Use of database

2004-03-27 Thread Peter Lovatt
- From: Will [mailto:[EMAIL PROTECTED] Sent: 27 March 2004 15:21 To: [EMAIL PROTECTED] Subject: [PHP-DB] Use of database I have searched but I cannot find anything that will help me. I am using phpMyAdmin and I want to have a user not see the privilages, mysql info and such. How do you get

[PHP-DB] Protecting mysql database

2004-03-03 Thread Piet from South Africa
Hi Is there a way that an alert or something can be generated when a mysql database is being accessed in any way. I want to close the whole database for a period, and nobody may access the database via phpadmin or anything else Appreciate your input on this one. -- PHP Database Mailing List

Re: [PHP-DB] Protecting mysql database

2004-03-03 Thread Adam Voigt
Why not just stop the database? On Wed, 2004-03-03 at 09:41, Piet from South Africa wrote: Hi Is there a way that an alert or something can be generated when a mysql database is being accessed in any way. I want to close the whole database for a period, and nobody may access the

Re: [PHP-DB] Protecting mysql database

2004-03-03 Thread Ricardo Lopes
] To: [EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 2:41 PM Subject: [PHP-DB] Protecting mysql database Hi Is there a way that an alert or something can be generated when a mysql database is being accessed in any way. I want to close the whole database for a period, and nobody may access

[PHP-DB] PHP APACHE Database

2003-10-08 Thread Paul Ciba
Hi everybody, i have a problem with php 4.0 an Sql Anywhere 5.5. The Webserver (Apache), the database and PHP are all installed on the same server( win 2000). PHP is using ODBC to connect to the database. This works if no other programm using the ODBC-connection ! If i start a programm that use

[PHP-DB] Pros/Cons Database vs Excel

2003-07-22 Thread Ow Mun Heng
Hi, I'm having a problem convincing my boss of the benefits of using a database vs just using excel as a way of tracking events. The boss' stance is that excel is more 'simple' columns can be expanded as and when it's wanted. You can put links into excel that points to files

[PHP-DB] Mysqli setting database connection character set

2003-07-12 Thread Jaanus Heeringson
Is there any way to set the default database connection character set when using myslqi extension? When connecting to a database it does not seem to pick up the default charset of the database (utf8) but instead reverts to the mysql server default chrset (latin_1...). What i want to do is

[PHP-DB] Re: mysql database function problem

2003-07-02 Thread Andres
Thanks, it works...mysqlerror() told me the exact problem and I could solve it thanks David Robley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hello Everybody! I tried to connect with a mysql databasem , but It shows

[PHP-DB] Re: mysql database function problem

2003-06-26 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hello Everybody! I tried to connect with a mysql databasem , but It shows the follow error: Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\ejercicios\cap11\cursor.php on line 25

RE: [PHP-DB] Creating mySQL database

2003-03-18 Thread Luke Woollard
To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Creating mySQL database Can I create a mySQL user and PW from PHP Thomas Tremain www.LiveHost.net http://www.livehost.net/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] no such database

2003-02-01 Thread Brad Hubbard
Red Hat 8.0 php-4.2.2-8.0.5 postgresql-7.2.2-1 I've used the PEAR DB classes quite a lot in the past but have moved to a new machine and have encountered a bit of a perplexing problem. the following code generates the error; DB Error: no such database ?php require_once 'DB.php'; $dsn

[PHP-DB] Web image database questions

2003-01-29 Thread Kim Kohen
Hi folks, A friend of mine would like to use PHP/MySQL to host a web based photo archive. I believe it will hold around 20,000 to 30,000 photos at a reasonable size for web display - perhaps 100 k or so each. I expect he'd have a small preview 'clickable' to a larger version. I searched the

Re: [PHP-DB] Remote Oracle database questions...

2002-12-12 Thread Philippe Saladin
DOH!!! I am seriously hoping that I do not need to have the Oracle client installed on the webserver running the PHP queries. I have no idea about the client licensing, and if it involves money in any way it is pretty much out of the question. Oh well... Hopefully I can find out about this

[PHP-DB] Remote Oracle database questions...

2002-12-11 Thread NIPP, SCOTT V (SBCSI)
I have now been granted access to a remote Oracle database that I need to query. All of the work that I have done with databases and PHP has been focused on MySQL, does anyone know of a good tutorial for PHP with Oracle? My immediate question is how do I get logged into the remote

RE: [PHP-DB] Remote Oracle database questions...

2002-12-11 Thread Ryan Jameson (USA)
, 2002 9:24 AM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Remote Oracle database questions... I have now been granted access to a remote Oracle database that I need to query. All of the work that I have done with databases and PHP has been focused on MySQL, does anyone know of a good

RE: [PHP-DB] Remote Oracle database questions...

2002-12-11 Thread NIPP, SCOTT V (SBCSI)
this stuff from one of our DBAs. -Original Message- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 10:58 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Remote Oracle database questions... One thing I can help with is TNSNAME. It was very confusing

[PHP-DB] UPDATE mySQL database with IF condition

2002-11-21 Thread Ravi Ramroop
Hi.. I'm having some problem with an if condition when I'm trying to insert data into a mysql table.. the script works fine with no parse errors..but the table doesn't get updated like I want it to be.. and i'm almost certain that the code is correct... Here is part of the script.. I have a form

RE: [PHP-DB] Archiving A Database

2002-11-07 Thread Josh Johnson
definitely keep your suggestions in mind for more serious archiving of data in the future. Thanks again! -- Josh -Original Message- From: Peter Beckman [mailto:beckman;purplecow.com] Sent: Thursday, November 07, 2002 12:05 AM To: Josh Johnson Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB

Re: [PHP-DB] Archiving A Database

2002-11-06 Thread Peter Beckman
Do you need to archive it forever? Do you need live access to it? If you just need to archive it, read the man page for mysqldump. You can dump specific rows to a file, rename that file dump.2002.05.24, compress it with gzip, and voila, you have all of your data readily available, easily

[PHP-DB] Re: persistant database connections

2002-11-05 Thread Richard Allsebrook
There's a whole world of difference between 'rendered' and 'processed - the page is processed top to bottom (baring any branching in your php) - and generally rendered from top to bottom - some parts being rendered after as the missing components (images etc) are loaded. - in short - yes you can

Re: [PHP-DB] Re: persistant database connections

2002-11-05 Thread Bob Lockie
Richard Allsebrook wrote: There's a whole world of difference between 'rendered' and 'processed - the page is processed top to bottom (baring any branching in your php) - and generally rendered from top to bottom - some parts being rendered after as the missing components (images etc) are

[PHP-DB] Archiving A Database

2002-10-29 Thread Josh Johnson
Does anyone know of speedy methods of periodically archiving and retrieving a database table? I've got a table I'm using to log statistical data, and it's getting 10k+ entries per day. Entries are only logged in the database if the user is authenticated for access, and only once per access session

[PHP-DB] FLAT FILE database questions.

2002-10-08 Thread Negretti, John (CCI-San Diego)
Hello All, Well, I'm in a situation where I would like to ONLY use a flat file database. I have searched hi and low, though could not find too many resources. So, I am creating my own libraries utilizing arrays. Does anyone have any good links for FLAT FILE databases. Thanks alot.

RE: [PHP-DB] FLAT FILE database questions.

2002-10-08 Thread John W. Holmes
) abstraction layer functions Chapter XIX. dBase functions Chapter XX. DBM Functions ---John Holmes... -Original Message- From: Negretti, John (CCI-San Diego) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 6:28 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] FLAT FILE database

RE: [PHP-DB] FW: Php database support

2002-09-10 Thread Andrew Hill
, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Walgamotte, David [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 8:16 AM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] FW

[PHP-DB] FW: Php database support

2002-09-09 Thread Walgamotte, David
Hello All !!! We use PHP in a production e-commerce web environment with a mysql database server. The higher ups have decided they want to move to Microsoft SQL. I'm now tasked to convert our Unix Apache PHP environment to use a remote Microsoft SQL server. I've researched and used

[PHP-DB] MySQL test database creation...

2002-07-05 Thread NIPP, SCOTT V (SBCSI)
Hey guys... I know that this is not specifically on topic for this group, but I promise this is an easy one. I am developing a web app, and need to create a development copy of the production database. I have created the new database, now I just need to export and import the

RE: [PHP-DB] MySQL test database creation...

2002-07-05 Thread NIPP, SCOTT V (SBCSI)
, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 12:26 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] MySQL test database creation... Hey guys... I know that this is not specifically on topic for this group, but I promise this is an easy one. I am developing

RE: [PHP-DB] MySQL test database creation...

2002-07-05 Thread Peter Lovatt
Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: 05 July 2002 18:26 To: '[EMAIL PROTECTED]' Subject: [PHP-DB] MySQL test database creation... Hey guys... I know that this is not specifically on topic for this group, but I promise this is an easy one. I am

RE: [PHP-DB] PHP in Database Fields..

2002-06-25 Thread Chris Barnes
eval() might do what your asking for. I'm no expert tho. -Original Message- From: Matthew Tedder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 25 June 2002 7:32 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP in Database Fields.. Question: I want to put PHP code into database fields

[PHP-DB] PHP in Database Fields..

2002-06-24 Thread Matthew Tedder
Question: I want to put PHP code into database fields holding HTML text, how can I make it execute that PHP before sending to the browser?? Currently, I get the text from MySQL and print it The browser shows the PHP code mixed into the HTML. Matthew -- Anything that can be

Re: [PHP-DB] PHP in Database Fields..

2002-06-24 Thread szii
exec() the query results. -Mike - Original Message - From: Matthew Tedder [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 2:31 PM Subject: [PHP-DB] PHP in Database Fields.. Question: I want to put PHP code into database fields holding HTML text, how can

Re: [PHP-DB] PHP in Database Fields..

2002-06-24 Thread Matthew Tedder
, either.. Matthew -Mike - Original Message - From: Matthew Tedder [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 2:31 PM Subject: [PHP-DB] PHP in Database Fields.. Question: I want to put PHP code into database fields holding HTML text, how can I

Re: [PHP-DB] PHP in Database Fields..

2002-06-24 Thread kodrik
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1    I want to put PHP code into database fields holding HTML text, how    can I make it execute that PHP before sending to the browser?? I save the code into a file and save the url of the file into a database and then just include that file into my

Re: [PHP-DB] PHP in Database Fields..

2002-06-24 Thread szii
I'm sorry, brainfart. Don't exec(), eval(). Apologies. -Mike - Original Message - From: Matthew Tedder [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 4:00 PM Subject: Re: [PHP-DB] PHP in Database Fields.. On Monday 24 June 2002 09:21 pm

Re: [PHP-DB] Auto-update database records

2002-06-12 Thread Tony
I finally got this auto-update script to work, thanks for your so many replies. Tony S. Wu Jason Wong at [EMAIL PROTECTED] wrote: On Saturday 08 June 2002 21:34, Tony wrote: I do appreciate your reply. Yes, I've tried to track down the problem. I comment-out the fopen() function and use

[PHP-DB] Auto-update database records

2002-06-08 Thread Tony
Here is my code. If you see some variables not defined, assume it is: ? require_once(fn_web.php); require_once(fn_db.php); set_time_limit(3000); set_header(Auto-Update); $final_result = get_records($_POST[key]); // getting the records from database

Re: [PHP-DB] Auto-update database records

2002-06-08 Thread Jason Wong
On Saturday 08 June 2002 20:35, Tony wrote: Here is my code. If you see some variables not defined, assume it is: Hmm, is there a problem with your code? If so could you state what the problem is? -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems

Re: [PHP-DB] Auto-update database records

2002-06-08 Thread Tony
You are being picky on me, huh? I stated my problem 3 emails ago, browser gives me error attempt to load MyPage's URL failed. Could be because of execution timeout. I tried to set the time longer with no luck. If I put the flush() after each data, I get the first output only. But I need to update

  1   2   >