Re: [PHP-DB] Database and Table creation

2010-10-19 Thread kesavan trichy rengarajan
Hi Ethan, Database Creation: http://www.php.net/manual/en/function.mysql-create-db.php Adding Tables, Extract Data: http://www.freewebmasterhelp.com/tutorials/phpmysql/1 Explore the

RE: [PHP-DB] Database management

2010-08-26 Thread Ashay Chaudhary
ay, August 26, 2010 9:06 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Database management Thank you all for your comments and suggestions. It was a "real" task to find something open source, so I gave up on that. I decided to go with RazorSQL. Its just what I needed and I alrea

RE: [PHP-DB] Database management

2010-08-26 Thread Ashay Chaudhary
It appears to be. I've downloaded the free/trial version, I haven't had time to play with it. : Ashay -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Thursday, August 26, 2010 12:03 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Database

Re: [PHP-DB] Database management

2010-08-26 Thread Karl DeSaulniers
[mailto:k...@designdrumm.com] Sent: Thursday, August 26, 2010 12:03 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Database management That is interesting cause they are an asp based server. I'll have to take a look at that. Might be something I can build into the server. Is it web based like ph

Re: [PHP-DB] Database management

2010-08-26 Thread Karl DeSaulniers
net Subject: Re: [PHP-DB] Database management Thank you all for your comments and suggestions. It was a "real" task to find something open source, so I gave up on that. I decided to go with RazorSQL. Its just what I needed and I already have most of the changes done on the database alr

Re: [PHP-DB] Database management

2010-08-26 Thread Karl DeSaulniers
Thank you all for your comments and suggestions. It was a "real" task to find something open source, so I gave up on that. I decided to go with RazorSQL. Its just what I needed and I already have most of the changes done on the database already. and I am only using the trial version ATM. I pl

RE: [PHP-DB] Database management

2010-08-25 Thread Ashay Chaudhary
If open source is a must, then there is only one choice showing up on search: SQL Web Data Administrator (sqlwebadmin.codeplex.com) That said, the best choice is SQL Server Management Studio. It's not open source and it is a Win32 app (meaning you'll have to run it in VirtualBox or something si

Re: [PHP-DB] Database management

2010-08-25 Thread Phpster
On Aug 25, 2010, at 19:27, Karl DeSaulniers wrote: > Hello fellow PHPers, > Question, > 1. Does anyone know of a good Open source MS SQLServer management software > for MAC? > I have been charged with updating a companies Microsoft SQLServer and I > usually work in MySQL. > Need a freeware if

Re: [PHP-DB] Database Object

2007-09-24 Thread Chris
ok, both CME and CMD are contract, but differ in it's content, one is tower and other is microwave. how to put the class into database ? should i made a contract table , a cme and cmd one... ? any suggestion ? I'd have two tables because they are separate data relationships. One for towers, o

Re: [PHP-DB] database password

2007-04-04 Thread Micah Stevens
On 04/03/2007 07:35 AM, Roberto Mansfield wrote: So is anyone doing anything to protect plain text passwords in the filesystem? Yeah, I make sure people I don't want reading the passwords don't get into the filesystem. :) -Micah -- PHP Database Mailing List (http://www.php.net/) To unsu

Re: [PHP-DB] database password

2007-04-03 Thread Roberto Mansfield
Stut wrote: > Roberto Mansfield wrote: >> Bastien Koert wrote: >>> store your password/access credentials outside the web root and use php >>> to read the data in. >> >> This is good for web attacks, but I'm thinking of an account break in >> where someone is accessing files directly on the server.

Re: [PHP-DB] database password

2007-04-03 Thread Stut
Roberto Mansfield wrote: Bastien Koert wrote: store your password/access credentials outside the web root and use php to read the data in. This is good for web attacks, but I'm thinking of an account break in where someone is accessing files directly on the server. I suggest you think about

Re: [PHP-DB] database password

2007-04-03 Thread Roberto Mansfield
Bastien Koert wrote: > store your password/access credentials outside the web root and use php > to read the data in. This is good for web attacks, but I'm thinking of an account break in where someone is accessing files directly on the server. > Another alternative is to wrap those items in a >

RE: [PHP-DB] database password

2007-04-03 Thread Bastien Koert
store your password/access credentials outside the web root and use php to read the data in. Another alternative is to wrap those items in a function and check the calling source to make sure its only your application hth Bastien From: Roberto Mansfield <[EMAIL PROTECTED]> To: php-db@lists.

RE: [PHP-DB] Database abstract layer

2006-11-07 Thread Bastien Koert
WE use XML here to store the values, however our requirements also add the ability to use mutiple languages so its a little more complex. For personal projects I store the various data like this into a system_option table as text (1,Male;2,Female;) and then have a common routine that grabs the

Re: [PHP-DB] Database abstract layer

2006-11-07 Thread Natalie Leotta
We have 0/1/2 for gender but also have tlkpSex or something like that. It has the id and the string we want to use, then our queries just make sure that data.gender=tlkpSex.gender. Good luck! Natalie On 11/7/06, Tony Grimes <[EMAIL PROTECTED]> wrote: Why not build the options into your data

Re: [PHP-DB] Database abstract layer

2006-11-07 Thread Tony Grimes
Why not build the options into your data model? Instead of using integers for gender, use a varchar field that stores 'Male' and 'Female'. You can ensure data integrity by adding a check constraint to the column. If the presentation might change depending on context, you can create gender referenc

Re: [PHP-DB] Database abuse help needed

2006-03-13 Thread Ludvig Ericson
Another fine thing about this is the fact that you can use unicode characters as an alternative which the regular expression engine probably wont match, unless it's somehow tweaked. This is the same theory as in when you are doing phising, for say ebay.com and replace the a with one of them non-ASC

RE: [PHP-DB] Database abuse help needed

2006-03-13 Thread Finner, Doug
No, I agree, for this matter you can never create a regular expression well written enough to match all or even most of the lingo we use. = Been off the list for a couple of days and just stumbled across this thread. Our company uses some kind of 'nicey-ni

Re: [PHP-DB] Database abuse help needed

2006-03-12 Thread Ludvig Ericson
-oOo-- > - Original Message - > From: "Ludvig Ericson" <[EMAIL PROTECTED]> > To: "Julien Bonastre" <[EMAIL PROTECTED]> > Cc: > Sent: Sunday, March 12, 2006 11:31 AM > Subject: Re: [PHP-DB] Database abuse help needed > &g

Re: [PHP-DB] Database abuse help needed

2006-03-12 Thread Julien Bonastre
PROTECTED] www.the-spectrum.org --oOo---oOo-- - Original Message - From: "Ludvig Ericson" <[EMAIL PROTECTED]> To: "Julien Bonastre" <[EMAIL PROTECTED]> Cc: Sent: Sunday, March 12, 2006 11:31 AM Subject: Re: [PHP-DB] Database abuse help need

Re: [PHP-DB] Database abuse help needed

2006-03-11 Thread Ludvig Ericson
sidered if: ... a.. You have no users, and nobody ever visits > your server. ... Extracted Quote: Security Tips - Apache HTTP > Server ---oOo--- --oOo---oOo-- Julien Bonastre > [The_RadiX] The-Spectrum Network CEO ABN: 64 235 749 494 > [EMAIL PROTECTED] > www.the-spectrum.org --

Re: [PHP-DB] Database abuse help needed

2006-03-11 Thread Julien Bonastre
-- From: "Ludvig Ericson" <[EMAIL PROTECTED]> To: "Julien Bonastre" <[EMAIL PROTECTED]> Cc: "Chris Payne" <[EMAIL PROTECTED]>; Sent: Sunday, March 12, 2006 12:18 AM Subject: Re: [PHP-DB] Database abuse help needed Erm, dude, chill out with the elitism

Re: [PHP-DB] Database abuse help needed

2006-03-11 Thread Ludvig Ericson
fferent fields. Easy enough? > > > Then I have the second part, which uses the PCRE [perl compat reg exp] > handler functions of PHP to attempt matching my patterns to the given > inputs from user. > > > Easy right??? > > > Too easy, and extremely fast and effective... >

Re: [PHP-DB] Database abuse help needed

2006-03-11 Thread Julien Bonastre
hes about how expensive they are to run, but wouldn't we be BADed without them!?!?!? ---oOo--- Allowing users to execute CGI scripts in any directory should only be considered if: ... a.. You have no users, and nobody ever visits your server. ... Extracted Quote: Security Tips - Apache HTT

RE: [PHP-DB] Database abuse help needed

2006-03-10 Thread Chris Payne
t: Thursday, March 09, 2006 8:40 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] Database abuse help needed Thank you for that. And excuse the inexperience, but how would I use an Array with the below? I mean say I had words such as this,is,a,bad,word (Just as examples as I can't post wh

RE: [PHP-DB] Database abuse help needed

2006-03-10 Thread Dwight Altman
us2.php.net/in_array -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED] Sent: Thursday, March 09, 2006 8:40 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] Database abuse help needed Thank you for that. And excuse the inexperience, but how would I use an Array with the below? I

RE: [PHP-DB] Database abuse help needed

2006-03-09 Thread Bastien Koert
I use an array of 'bad' words and the in_array function to check if the data is in the array Bastien From: "Chris Payne" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] Database abuse help needed Date: Thu, 9 Mar 2006 18:21:25 -0500 Hi there everyone, Is there a better way I can do this? if

RE: [PHP-DB] Database abuse help needed

2006-03-09 Thread Chris Payne
Thank you for that. And excuse the inexperience, but how would I use an Array with the below? I mean say I had words such as this,is,a,bad,word (Just as examples as I can't post what I'm trying to block on here) how would I loop through those to check if any of them exist and if they do THEN exec

RE: [PHP-DB] Database abuse help needed

2006-03-09 Thread Dwight Altman
If you POST from your form use $_POST, or $_GET for a form GET foreach($_POST as $key => $value){ if( strpos($value, $findme) !== false ){ //$findme was found in $value } } http://php.net/manual/en/reserved.variables.php http://us2.php.net/manual/en/control-structu

RE: [PHP-DB] Database storage and Sessions

2006-02-10 Thread Bastien Koert
Its not that much overhead to check it each time...but I would store the username (not the password) in the session along with an 'access_level' and some hash value to uniquely id that person/account each time (read the hash from the db before authorizing any alterations to the data). Check the

Re: [PHP-DB] database for books question

2006-01-22 Thread mario
Hi, you may wish to know that the kind of tools you are asking about are already well developed by members of the Typo3 community. Typo3 is a powerful open source, community developed, GPL licensed, php +mysql based CSM. See at http://www.typo3.org If you look at their Extension Repository (sea

Re: [PHP-DB] database for books question

2006-01-21 Thread Julien Bonastre
r" <[EMAIL PROTECTED]> To: "Flint Million" <[EMAIL PROTECTED]>; Sent: Sunday, January 22, 2006 10:14 AM Subject: Re: [PHP-DB] database for books question -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Flint Million wrote: Good idea. OK so I'll create a new databa

Re: [PHP-DB] database for books question

2006-01-21 Thread Julien Bonastre
ity Tips - Apache HTTP Server ---oOo--- --oOo---oOo-- Julien Bonastre [The_RadiX] The-Spectrum Network CEO ABN: 64 235 749 494 [EMAIL PROTECTED] www.the-spectrum.org --oOo---oOo-- - Original Message - From: "John Meyer" <[EMAIL PROTE

Re: [PHP-DB] database for books question

2006-01-21 Thread John Meyer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Flint Million wrote: > Good idea. OK so I'll create a new database with subject ID's. Now, back in > the primary database, how can I have multiple subjects assigned to one book? > Let's say I repeat my above example and we assign "Nonfiction" to 1, > "

Re: [PHP-DB] database for books question

2006-01-21 Thread John Meyer
Flint Million wrote: > Now I want to be able to do a subject listing as well as a search. For > example, if I asked for a lsit of all subjects, I want something like: > Nonfiction (2) > PHP (1) > Technology (2) > Computers (1) > Programming (1) > History (1) > Linux (1) > In database design, I'd

Re: [PHP-DB] database synchronization. .

2005-05-12 Thread Martin Norland
M Saleh EG wrote: Are you running your sites on the same server? If yes use only one database for all of them. Unless he's installed the latest of either SSvX* or QFCP**, I'm guessing his server isn't installed at multiple sites. * [SSvX] Schrodinger's Server vX ** [QFCP] Quantum Flux Computin

Re: [PHP-DB] database synchronization

2005-05-12 Thread M Saleh EG
Are you running your sites on the same server? If yes use only one database for all of them.

RE: [PHP-DB] database synchronization

2005-05-12 Thread Murray @ PlanetThoughtful
  I have web based application running on php and mysql and installed on multiple sites. The data on those sites need to be synchronized (to have same data on every site after insert/update/delete action in each site). Currently im using an ftp server to handle synchronization, im using batch scri

RE: [PHP-DB] database synchronization

2005-05-12 Thread Bastien Koert
have a look into replication...might be what you realy need http://dev.mysql.com/doc/mysql/en/replication.html bastien From: "Andri" <[EMAIL PROTECTED]> To: "PHP DB List" Subject: [PHP-DB] database synchronization Date: Thu, 12 May 2005 14:09:51 +0700 Hello all, anyone can help me? I have web bas

RE: [PHP-DB] Database creation question

2005-04-29 Thread jnpritchard
Hi If your concern is fulling your MySQL database quota then one solution may be to store on the message headers in the MySQL Database, the message text could be stored as plain text files within your webspace. James Bastien Koert <[EMAIL PROTECTED]> wrote: Hi Ron, You could look at FlatFi

RE: [PHP-DB] Database creation question

2005-04-29 Thread Bastien Koert
Hi Ron, You could look at FlatFile Databases.(http://ffdb-php.sourceforge.net/) The real issue is that if the discussion board becomes too active, your flatfiles don't have the same flexibility to adapt tp load. hth bastien From: "Ron Piggott" <[EMAIL PROTECTED]> Reply-To: "Ron Piggott" <[EMAIL

Re: [PHP-DB] database connection timeout

2005-03-24 Thread Martin Norland
Juffermans, Jos wrote: I understand your point but since I wasn't getting any response and never received a confirmation email from the system telling me that my email account had been verified, I wasn't sure that the original post was actually sent to the community. Oddly enough I got an email fro

RE: [PHP-DB] database connection timeout

2005-03-24 Thread Juffermans, Jos
Hi, Martin Norland wrote: MN> I'm afraid phrasing a question multiple ways over a course of days tends MN> not to have much success. In an effort to avoid populating google with MN> just the question, I will give to you what I would try. I understand your point but since I wasn't getting any r

Re: [PHP-DB] database connection timeout

2005-03-24 Thread Martin Norland
Juffermans, Jos wrote: Hi, [snip] Hello, again. I'm afraid phrasing a question multiple ways over a course of days tends not to have much success. In an effort to avoid populating google with just the question, I will give to you what I would try. ( please note the irony of this now. ) I'm

Re: [PHP-DB] Database visible via mysql CLI but not MOD_PHP with

2005-02-16 Thread Elliot Mackenzie
I have an update for this. I used mysql_connect to connect to the database and then ran the query "select current_user()". I discovered that despite using mysql_connect specifying a username and password, it still insisted on connecting as "@localhost", but with no user. The @localhost user do

Re: [PHP-DB] Database visible via mysql CLI but not MOD_PHP with

2005-02-16 Thread Elliot Mackenzie
Agh! GLOBALS GLOBALS GLOBALS. For a future suckers' reference, the variable was not available in its scope, and was thus passing null as the username to mysql_connect, which in turn was connecting to the database as "@localhost". Thanks for your help, pardon my stupidity :) Kind regar

Re: [PHP-DB] Database visible via mysql CLI but not MOD_PHP withsame username

2005-02-16 Thread Elliot Mackenzie
OK I will look further and try these ideas today. Cheers, M. Bastien Koert wrote: > sounds like a mysql account user permissions problem to me, too > > bastien > >>From: Martin Norland <[EMAIL PROTECTED]> >>Reply-To: php-db@lists.php.net >>To: php-db@

Re: [PHP-DB] Database visible via mysql CLI but not MOD_PHP withsame username

2005-02-15 Thread Bastien Koert
sounds like a mysql account user permissions problem to me, too bastien From: Martin Norland <[EMAIL PROTECTED]> Reply-To: php-db@lists.php.net To: php-db@lists.php.net Subject: Re: [PHP-DB] Database visible via mysql CLI but not MOD_PHP withsame username Date: Tue, 15 Feb 2005 15:59:09

Re: [PHP-DB] Database visible via mysql CLI but not MOD_PHP with same username

2005-02-15 Thread Martin Norland
Elliot Mackenzie wrote: I have encountered a "hidden database" issue with mod_php, apache2 and mySQL that I have thus far been unable to resolve. I am able to connect to the mysql socket using mysql_connect, but then find that mysql_list_dbs only returns the "test" database. This *sounded* like

Re: [PHP-DB] database connectivity problem

2005-02-02 Thread Martin Norland
Adams, Jonathan K. [C] wrote: Thanks Martin... You were right... I had to make Apache run as sybase (gasp!) for it to work really funky but it works... Probably better to figure out where the permissions are needed (no doubt somewhere in the filesystem) and see about adding one or the other to

RE: [PHP-DB] database connectivity problem

2005-02-02 Thread Adams, Jonathan K. [C]
b@lists.php.net' Subject: Re: [PHP-DB] database connectivity problem Adams, Jonathan K. [C] wrote: > Here is the error: "Warning: sybase_connect() [function.sybase-connect]: > Sybase: Unable to allocate connection record > > My configuration - The database is Sybase ASE 12.0

Re: [PHP-DB] database connectivity problem

2005-02-01 Thread Martin Norland
Adams, Jonathan K. [C] wrote: Here is the error: "Warning: sybase_connect() [function.sybase-connect]: Sybase: Unable to allocate connection record My configuration - The database is Sybase ASE 12.0 running on Solaris 8 The webserver is Apache 1.3.33 with PHP 5 running Solaris 9 The sybase librarie

Re: [PHP-DB] Database Design Recommendations

2004-11-02 Thread -{ Rene Brehmer }-
At 23:36 01-11-2004, Eric Cranley wrote: I tried to find this in the archives. If I missed it, my apologies in advance. I'm developing an intranet for my company, and we are planning on putting sensitive information on it. I've already setup a login system using sessions, but I'm not sure how to ma

Re: [PHP-DB] Database Design Recommendations

2004-11-02 Thread Miles Thompson
Eric, Your second approach is fine. It's denormalized, extensible, and can be manipulated using tools you put in place. You may want to consider "groups" as well, thus people belonging to a group could view/edit pages, that has the potential to save a lot of administrative scut work. A table

RE: [PHP-DB] Database Design Recommendations

2004-11-02 Thread Hutchins, Richard
Eric, There are, as you will find out, a number of ways you could handle it. The "right" way is really your decision and it's directly related to the flexibility, maintainability, and security your site will require. I have had success in the past using a role-based permission system. For example

Re: [PHP-DB] Database Backup

2004-10-06 Thread Andrew Kreps
On Wed, 6 Oct 2004 15:31:34 -0400, Aaron Todd <[EMAIL PROTECTED]> wrote: > Do you happen to know > how I might be able to push a file to another server using FTP? I might http://us4.php.net/ftp has a list of all the FTP related PHP functions with some ready-to-use examples. Enjoy! -- PHP

Re: [PHP-DB] Database Backup

2004-10-06 Thread Aaron Todd
Andrew, I like the idea of using the crontab even though I have never used it before. I guess the first thing I need to do is make my script. Thanks for the link to mysqldump, I think it will be usefull. Do you happen to know how I might be able to push a file to another server using FTP? J

Re: [PHP-DB] Database Backup

2004-10-05 Thread Andrew Kreps
On Tue, 5 Oct 2004 16:33:08 -0400, Aaron Todd <[EMAIL PROTECTED]> wrote: > What is everyone doing to backup a MySQL database. Just in case...I'd like > to backup mine, but I was wondering if there was a way to do it without > going to a page and clicking a button. Is there a way to run a php scri

Re: [PHP-DB] Database Backup

2004-10-05 Thread martin73
You can simply copy files from 'data' subfolder of mysql database or create php script to make a dump of db and run it on regular basis as a cron job. Cheers, Martin > What is everyone doing to backup a MySQL database. Just in case...I'd > like > to backup mine, but I was wondering if there was

Re: [PHP-DB] DATABASE error on form submission.

2004-08-31 Thread Arné Klopper
Can you access the other POST variables, if not put quotation marks around method="post", also try using instead of op something else... Kind Regards Arné Klopper NetCB Solutions (Pty) Ltd. www.netcb.com Office: +27 12 997 3007 Fax: 27 12 997 3629 Mobile:

Re: [PHP-DB] DATABASE Error on form submission

2004-08-30 Thread randy
//check for required fields from the form if ((!$_POST[topic_owner]) || (!$_POST[topic_title])|| (!$_POST[post_text])) { header("Location: addtopic.html"); exit; } The $_POST is an associative array and the key names need to be wrapped by commas. The same error is happening on your local mac

Re: [PHP-DB] database

2004-08-30 Thread Ramil Sagum
On Mon, 30 Aug 2004 21:44:03 -0700, Ryan Holowaychuk <[EMAIL PROTECTED]> wrote: > And that is where I am lost? > > Yes I have the data in a Mysql server, so how do I get the server to do the > work. > > thanks > Ryan > You need to execute a SELECT statement with a WHERE clause. Your problem

Re: [PHP-DB] database

2004-08-30 Thread Ramil Sagum
On Mon, 30 Aug 2004 21:29:07 -0700, Ryan Holowaychuk <[EMAIL PROTECTED]> wrote: > > I have a database that has 110,000 barcodes in it. > I am trying to create a system that I can enter barcode1 in the system and > it return a good or bad value. > I have it loading in an array at the moment. which

Re: [PHP-DB] Database Search Engine ?

2004-02-27 Thread Muhammed Mamedov
]> Sent: Thursday, February 26, 2004 12:59 PM Subject: Re: [PHP-DB] Database Search Engine ? > Hello, > > I suggest PostgreSQL+TSearch2+OpenFTS... > > 30 minutes to a wonderful search engine. > > On Thu, 26 Feb 2004, Muhammed Mamedov wrote: > > >

Re: [PHP-DB] Database Search Engine ?

2004-02-26 Thread Joshua D. Drake
Hello, I suggest PostgreSQL+TSearch2+OpenFTS... 30 minutes to a wonderful search engine. On Thu, 26 Feb 2004, Muhammed Mamedov wrote: > Anyone knows/uses IMP database search engine? > http://www.imptechnology.com/DesktopDefault.aspx?tabid=56 > > Thanks, > M.Mamedov > -- Co-Founder Command P

Re: [PHP-DB] Database Abstraction Layer?

2004-01-23 Thread John W. Holmes
From: "Muhammed Mamedov" <[EMAIL PROTECTED]> > And one more question : A guy from this list told that MDB supports XML > files (can create db from an XML file and ...) . What do you all think about > it? Available for ADOdb, also. Never used it personally, though. http://phplens.com/lens/adodb/d

Re: [PHP-DB] Database Abstraction Layer?

2004-01-23 Thread Muhammed Mamedov
: <[EMAIL PROTECTED]> Sent: Thursday, January 22, 2004 11:26 PM Subject: Re: [PHP-DB] Database Abstraction Layer? > There's also PEAR's DB_DataObject which does build SQL for you. The join > syntax isn't set up to be totally DB independant yet, but it can and > will be. >

Re: [PHP-DB] Database Abstraction Layer?

2004-01-22 Thread Justin Patrin
ssage- From: Muhammed Mamedov [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 10:07 AM To: [EMAIL PROTECTED]; phpdb Subject: Re: [PHP-DB] Database Abstraction Layer? Hmm.. Thank you for you sql picks:) But what do you guys think aabout Pear :: DB? Is it as effective as these Paul

Re: [PHP-DB] Database Abstraction Layer?

2004-01-22 Thread Justin Patrin
" <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 11:21 AM Subject: Re: [PHP-DB] Database Abstraction Layer? You have ADODB and PEAR DB that both work as abstraction layer. I have used ADODB and seems to me that is very good, yet i have not tested PEAR DB... To make php code 100%

RE: [PHP-DB] Database Abstraction Layer?

2004-01-21 Thread Paul Miller
. Either way adds a significant time to coding and product release initially. - Paul -Original Message- From: Muhammed Mamedov [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 10:07 AM To: [EMAIL PROTECTED]; phpdb Subject: Re: [PHP-DB] Database Abstraction Layer? Hmm.. Thank

Re: [PHP-DB] Database Abstraction Layer?

2004-01-21 Thread Muhammed Mamedov
: Wednesday, January 21, 2004 5:44 PM Subject: RE: [PHP-DB] Database Abstraction Layer? > There are a couple of products out there that I am about to start testing, > starting first with: > > - SQL Relay > http://sqlrelay.sourceforge.net/ > This product uses its on C inte

RE: [PHP-DB] Database Abstraction Layer?

2004-01-21 Thread Paul Miller
: Wednesday, January 21, 2004 3:41 AM To: phpdb Subject: Re: [PHP-DB] Database Abstraction Layer? Thanks Ricardo for your comments. What do you think guys: ADODB or PEAR::DB ? - Original Message - From: "Ricardo Lopes" <[EMAIL PROTECTED]> To: "Muhammed Mamedov"

RE: [PHP-DB] Database Abstraction Layer?

2004-01-21 Thread Paul Miller
There are a couple of products out there that I am about to start testing, starting first with: - SQL Relay http://sqlrelay.sourceforge.net/ This product uses its on C interfaces to interact with DBs and different programming languages. It addresses a bunch of items in the PHP DB calls. Connecti

Re: [PHP-DB] Database Abstraction Layer?

2004-01-21 Thread Muhammed Mamedov
Thanks Ricardo for your comments. What do you think guys: ADODB or PEAR::DB ? - Original Message - From: "Ricardo Lopes" <[EMAIL PROTECTED]> To: "Muhammed Mamedov" <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 11:21 AM Subject: Re: [PHP-DB] Dat

Re: [PHP-DB] Database abstraction

2004-01-14 Thread Malte Starostik
Hans Lellelid wrote: > Martin Marques wrote: > > Mensaje citado por Malte Starostik <[EMAIL PROTECTED]>: > >>Hi, > >> > >>I've read several posts touching this subject, but I didn't find one that > >>asks a simple question I've been wondering about since I first used PHP and > >>that is also one of

Re: [PHP-DB] Database abstraction

2004-01-14 Thread Hans Lellelid
Martin Marques wrote: Mensaje citado por Malte Starostik <[EMAIL PROTECTED]>: Hi, I've read several posts touching this subject, but I didn't find one that asks a simple question I've been wondering about since I first used PHP and that is also one of the two really really bad things about PHP (th

Re: [PHP-DB] Database abstraction

2004-01-13 Thread Jason Wong
On Wednesday 14 January 2004 06:42, Martin Marques wrote: > Why is it you say it's semi-official? > I have always felt PEAR as much official. Well it's not in the PHP manual so I treat it as semi-official ;-) -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] Database abstraction

2004-01-13 Thread Martin Marques
Mensaje citado por Jason Wong <[EMAIL PROTECTED]>: > > Whilst there isn't a builtin database abstraction layer in PHP itself there > are a number of projects which fills the gap. There's the semi-official > PEAR-DB, also ADODB and Metabase. Why is it you say it's semi-official? I have always f

Re: [PHP-DB] Database abstraction

2004-01-13 Thread Martin Marques
Mensaje citado por Malte Starostik <[EMAIL PROTECTED]>: > Hi, > > I've read several posts touching this subject, but I didn't find one that > asks a simple question I've been wondering about since I first used PHP and > that is also one of the two really really bad things about PHP (the other > b

Re: [PHP-DB] Database abstraction

2004-01-13 Thread Jason Wong
On Wednesday 14 January 2004 06:04, Malte Starostik wrote: > Why is there no modularization in this area, such that it'd be the _normal_ > way not to write things like $dbh = ibase_pconnect( ... ), but $dbh = > sql_connect( "Firebird", ... ) > and that would internally check if a Firebird/InterBas

Re: [PHP-DB] Database Array Question

2003-12-22 Thread Muhammed Mamedov
! - sign adds a negative meaning to the statement. Thus, if(!isset($_SESSION['uid'])) means = If (NOT isset($_SESSION['uid']))) you know that if(statement) will work if "statement" returns a "true" value...so if $_SESSION['uid'] is already set(has some value), isset($_SESSION['uid']) will also r

Re: [PHP-DB] database design question

2003-09-29 Thread olinux
i would add a second table and also store the totals in the lyrics table like you suggested then you can do things like top 10 this week / top 10 this month and make sure its not being abused LYRICS_RATINGS - id | lyric_id | rating | vote_date | remote_addr same idea for hits/impressions olinu

Re: [PHP-DB] Database backup

2003-08-27 Thread David Smith
Just do a mysqldump on the command line. It will dump a whole bunch of SQL code that can be used to recreate the database in the event of disaster. You could even pipe the output to gzip to compress it. mysqldump --all-databases -u root | gzip -c > mysql_backup.gz That works fine for me. The

Re: [PHP-DB] Database backup

2003-08-27 Thread jeffrey_n_Dyke
use mysqldump. you can dump all databases (--all-databases) or list them individually. http://www.mysql.com/doc/en/mysqldump.html hth Jeff

RE: [PHP-DB] Database backup

2003-08-27 Thread Jacob A. van Zanen
How'bout backing up your data directory (ies) Otherwise you can maybe use mysql_dump in a batch?? Jack -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 11:46 PM To: php Subject: [PHP-DB] Database backup Hi there everyone, Is there a qui

Re: [PHP-DB] Database backup

2003-08-27 Thread otherguy
http://www.mysql.com/doc/en/Backup.html This question might be a little bit more relevant on the mySQL-help list... At the very least, if that page doesn't do it for you, you might be able to get a little bit more expertise about backups of very large installations there. -Cameron Wilhelm On

Re: [PHP-DB] Database backup

2003-08-27 Thread ramki
mysqldump -A > /path_to_file/filename.sql for eg: mysqldump -A > /tmp/alldatabases.sql This generates a sql file which can be used as backup or for restore... Hope it helps.. -ramki Chris Payne wrote: Hi there everyone, Is there a quick way I can backup all my databases on Linux so I can d

Re: [PHP-DB] Database backup

2003-08-27 Thread John W. Holmes
Chris Payne wrote: Hi there everyone, Is there a quick way I can backup all my databases on Linux so I can download them to my HD/Burn them onto CD? I've started a very large travel project and there is going to be over 100 DB's in the end, each with who knows how many tables and going through P

Re: [PHP-DB] Database Design Issue

2003-08-14 Thread Jason Lange
Yes, songs do span shows. However, the list of songs for each weeks show starts out as a *.asc (same a *.txt) space-separated file. This gets uploaded via a PHP file that formats each row and inserts it into the database. That's why even though I know there will be duplication it appears (to me

Re: [PHP-DB] Database Design Issue

2003-08-14 Thread CPT John W. Holmes
From: "Jason Lange" <[EMAIL PROTECTED]> > Here's my question. I'm creating a website for a weekly radio show. One > of the items I would like to store in the database is the list of songs > played in each show (there's normally between 20-25 songs per show), and > the songs will be displayed by sh

Re: [PHP-DB] Database connection

2003-07-16 Thread colbey
undefined function means you don't have mysql support compiled in... prefixing any function with @ suppresses any error messages... On Thu, 17 Jul 2003, Martin wrote: > I'm trying to use PHP 4.2.3 in a database application. > > print "Connected?"; > $dbcnx = mysql_connect("localhost","root","a

Re: [PHP-DB] Database question

2003-07-03 Thread Jadiel Flores
This is right, maybe you can assign the db link to a session variable but this will work only for one specific user, but what would happen if you have around 100 users at the same time?? you will have 100 different connections to the db, and that will be slower. So, maybe you should try to avoi

Re: [PHP-DB] Database question

2003-07-03 Thread Paul Chvostek
On Thu, Jul 03, 2003 at 07:00:17AM -0700, Hardik Doshi wrote: > > Currently i am connecting the underlying database > server from every php page. To reduce the connection > overhead i am thinking to store the PEAR DB object > into the registry (session) at the time of user login. > Here i am connec

Re: [PHP-DB] database model

2003-06-04 Thread Ignatius Reilly
I have been using Dezign for Databases from Datanamic for several years. http://www.datanamic.com/ Not free, but invaluably helpful. I strongly recommend it. Ignatius - Original Message - From: "Snijders, Mark" <[EMAIL PROTECTED]> To: <[EMAIL P

RE: [PHP-DB] Database design

2003-03-10 Thread Beverly Steiner
Shaun, I took a quick look at your database layout and noticed that Practice_ID and Clinical_Trial_ID are repeated in the Booking table. This isn't necessary because the Booking table links to the Project table which contains this information. In the Project table, Practice_ID and Clinical_Trial

Re: [PHP-DB] Database Connections

2002-11-29 Thread Marco Tabini
I think that generally PHP closes any non-persistent connections for you when you leave your script, so that it's not necessary to clean up after your script is done. You can create persistent connections, but in a high-traffic site they tend to become a resource problem after a while--and your se

Re: [PHP-DB] database update question

2002-11-15 Thread Peter Beckman
you could do substring update table_name set col_name=concat(substring_index(col_name,".pdf",1),".zip") where col_name like "%.pdf" What does this do? From the man page: SUBSTRING_INDEX(str,delim,count) Returns the substring from string str before count occurrences of the delimiter

Re: [PHP-DB] database update question

2002-11-15 Thread Brad Bonkoski
If you wish to update all of them, then just eliminate the id condition. [EMAIL PROTECTED] wrote: > I have a database with several hundred entries of file names that end with > .pdf. I have converted > all those docs to .zip, now I need to change all the entries in the > database to .zip. I tried

Re: [PHP-DB] database update question

2002-11-15 Thread Jason Wong
On Saturday 16 November 2002 00:53, [EMAIL PROTECTED] wrote: > I have a database with several hundred entries of file names that end with > .pdf. I have converted > all those docs to .zip, now I need to change all the entries in the > database to .zip. I tried to use > update table_name set col_nam

  1   2   >