[PHP-DB] How to simplify DB creation?

2004-03-19 Thread Michal Masa
Hi, We plan to write a simple DB with app. 10 tables. Are there any tools that simplify and automatize the creation of PHP scripts for the database? Like automatic generation of PHP scripts that produce HTML input forms, generation of value lists, validation, sorting and searching? Well documented

[PHP-DB] Re: How to simplify DB creation?

2004-03-19 Thread Lester Caine
Michal Masa wrote: We plan to write a simple DB with app. 10 tables. Are there any tools that simplify and automatize the creation of PHP scripts for the database? Like automatic generation of PHP scripts that produce HTML input forms, generation of value lists, validation, sorting and searching?

Re: [PHP-DB] How to simplify DB creation?

2004-03-19 Thread Ricardo Lopes
Yes, there are tools to do that. You could take a look at PEAR which have libraries to do that, that a look at HTML:HTML_Form (for making forms) and there are several others alternatives(http://phpformgen.sourceforge.net and http://www.hotscripts.com/PHP/Scripts_and_Programs/Form_Processors/),

[PHP-DB] Re: How to simplify DB creation?

2004-03-19 Thread Manuel Lemos
Hello, On 03/18/2004 01:35 PM, Michal Masa wrote: We plan to write a simple DB with app. 10 tables. Are there any tools that simplify and automatize the creation of PHP scripts for the database? Like automatic generation of PHP scripts that produce HTML input forms, generation of value lists,

[PHP-DB] MySQL category tree db sorting

2004-03-19 Thread Age Bosma
I'm trying to work out what the most efficient way will be to get the complete tree structure from top to bottom of a category tree db. Starting with the first main branch listing it's first child branch followed by it's children, after that the second child branch, ect. When the first main

RE: [PHP-DB] MySQL category tree db sorting

2004-03-19 Thread Hutchins, Richard
I'd recommend you search the PHP archives for an answer. This question comes up a few times a year and the last time I remember seeing it, somebody (John Holmes, I think) provided an excellent discourse on the different ways to approach this solution. You'll probably get other new responses with

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-19 Thread Matthew Vos
Hi Piotr, Everyone else is suggesting edit all of the code. Alternatively you could setup an iptables rule which forwards all incoming requests on 127.0.0.1:3306 (or whatever port your mysql server is running on) to 192.168.0.1:3306 (repolace 192.168.0.1 wit the IP of your DB server). This way

[PHP-DB] Re: SQL Server Query Failed

2004-03-19 Thread david
Ahthread safe. THAT is an interesting thought. Especially because I somehow suspect that my problem is related to the database and/or table being locked just when I am trying to read it. However, I have to profess some ignorance about FastCGI. I looked at the web site for it, but I am not

[PHP-DB] Re: MySQL category tree db sorting

2004-03-19 Thread Hans Lellelid
Yes, in briefly reading your requirements, I believe the answer you want is the nested set model: Here's an article that looks right ... (quick google search) http://www.dbazine.com/tropashko4.shtml More information on this is contained in the SQL for Smarties book (which is an

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-19 Thread Operator
On 19 Mar 2004 at 9:53, Matthew Vos wrote: Hi Piotr, Everyone else is suggesting edit all of the code. Alternatively you could setup an iptables rule which forwards all incoming requests on 127.0.0.1:3306 (or whatever port your mysql server is running on) to 192.168.0.1:3306 (repolace

Re: [PHP-DB] Re: SQL Server Query Failed

2004-03-19 Thread Robert Twitty
Hi David Do these few queries ALWAYS fail, or just occasinally fail? Is this intranet site used by many people? If the same query always fails, you can determine if it may be a thread-safe issue by running that query outside of Apache as follows: c:\php\php thequery.php If the above fails,

[PHP-DB] Firebird support

2004-03-19 Thread Maximiliano Robaina
Hi, There are any plan about support for direct access to Firebird SQL DBMS? The interbase dll driver include in php 4.x work fine with Firebird 1.5? Thank in advance. -- Maxi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL category tree db sorting

2004-03-19 Thread John W. Holmes
From: Age Bosma [EMAIL PROTECTED] I'm trying to work out what the most efficient way will be to get the complete tree structure from top to bottom of a category tree db. Search the archives or Google for nested sets. That's going to be the most efficient database scheme to use. Any

[PHP-DB] Re: Re: SQL Server Query Failed

2004-03-19 Thread david
Thank you, Bob, for your continuing comments. The intranet site is used by approximately 100 people, and sees a good amount of traffic every day. I don't really have an exact number of daily queries that are executed, but it has to be a pretty sizable number, since the site handles much of the

[PHP-DB] Automatically Refreshing png-Image'd Web Page

2004-03-19 Thread dpgirago
Howdy Listers, The Background: I am making dynamic, color-coded, png images of the floor plan of a building and displaying them in a browser. Numerous radioactivity sensors throughout the building send their readings to a MySQL dB, and the web page queries the dB, and depending on the

[PHP-DB] ?DHTML Layers with PHP?

2004-03-19 Thread Galbreath, Mark A
I've been sitting here all morning wracking my brains for a way to code a hierarchical menu tree with JavaScript from database data retrieved by PHP, so that the child menus appear on a mouse click. Can PHP do this without JS? The only JS examples I can find use static menu trees, not dynamic

RE: [PHP-DB] Automatically Refreshing png-Image'd Web Page

2004-03-19 Thread Paul Miller
I might be reading this wrong, but I do not think you should put your meta refresh request in the png creation script. It should be in the html body script. Index.php Meta-refresh to call itself in 30 secs Call to img src=php_radio_image_creation_script.php

RE: [PHP-DB] MySQL category tree db sorting

2004-03-19 Thread Galbreath, Mark A
Remember that this is my first script, but here's how I extracted and associated category hierarchies: include 'c:\apache2\adodb\adodb\adodb.inc.php'; $ADODB_CACHE_DIR = 'c:\apache2\adodb\adodb-cache'; $db = ADONewConnection( 'mysql' ); $db - Connect( 'localhost', 'root', 'mysql', 'reach');

RE: [PHP-DB] ?DHTML Layers with PHP?

2004-03-19 Thread Paul Miller
This JS script is awesome. I work with Oracle Portal and a guy modified it to read portal hierarchies so I know it can read dynamic data with modification. http://www.destroydrop.com/javascripts/tree/ I believe you just have to be able to create the parent child relationships and display them

RE: [PHP-DB] Automatically Refreshing png-Image'd Web Page

2004-03-19 Thread dpgirago
Thanks, Paul, you got it right. I was trying to do it all in one file/page. I'll have a go at your suggestion. dave I might be reading this wrong, but I do not think you should put your meta refresh request in the png creation script. It should be in the html body script. Index.php

Re: [PHP-DB] Automatically Refreshing png-Image'd Web Page

2004-03-19 Thread Adam Voigt
You might want to use iframe's so you can refresh just individual sections when you need to. On Fri, 2004-03-19 at 12:00, [EMAIL PROTECTED] wrote: Howdy Listers, The Background: I am making dynamic, color-coded, png images of the floor plan of a building and displaying them in a browser.

[PHP-DB] Re: cant insert into specific column in specific row...help?

2004-03-19 Thread Justin Patrin
Aj Seelund wrote: im trying to insert, or more or less, add to the number in a column called (comNum) in one a specific row in one table(dm_blog), and add other values to another table(comments). i have the comments table working fine, everything insert correctly, but im trying to add to the

[PHP-DB] Re: How to simplify DB creation?

2004-03-19 Thread Justin Patrin
Michal Masa wrote: Hi, We plan to write a simple DB with app. 10 tables. Are there any tools that simplify and automatize the creation of PHP scripts for the database? Like automatic generation of PHP scripts that produce HTML input forms, generation of value lists, validation, sorting and

[PHP-DB] Re: ?DHTML Layers with PHP?

2004-03-19 Thread Justin Patrin
Mark A Galbreath wrote: I've been sitting here all morning wracking my brains for a way to code a hierarchical menu tree with JavaScript from database data retrieved by PHP, so that the child menus appear on a mouse click. Can PHP do this without JS? The only JS examples I can find use static

RE: [PHP-DB] ?DHTML Layers with PHP?

2004-03-19 Thread Galbreath, Mark A
This is exactly what I am looking for, so can PHP generate a new dynamic_page.php with the add. syntax? Mark -Original Message- From: Paul Miller [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 12:23 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] ?DHTML Layers with PHP? This JS

[PHP-DB] RE: How to simplify DB creation?

2004-03-19 Thread Brock Jimmy D Contr DODHSR5
I don't use this product, but I know some non-programs that use ASAP http://www.data-asap.com/ It creates many db functions: add, edit, delete, and search records. Jimmy Brock -Original Message- From: Michal Masa [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 11:36 AM To:

[PHP-DB] RE: ?DHTML Layers with PHP?

2004-03-19 Thread Brock Jimmy D Contr DODHSR5
If you compiled PHP with DOM support you can use XML to create dynamic trees. Here's a link to an article that uses XML...it's in ASP but the code could be converted to PHP. http://xefteri.com/articles/may312002/default.aspx Hope this helps, Jimmy Brock -Original Message- From:

Re: [PHP-DB] Re: Re: SQL Server Query Failed

2004-03-19 Thread Robert Twitty
Hi David Based on the amount of users accessing the site, there is a possibitity that php_mssql.dll not being thread safe could be the problem. The only way to verify this is to use PHP as a CGI, run Apache as a multi-process server, or replace php_mssql.dll with php_odbtp_mssql.dll. As much as

[PHP-DB] Re: Firebird support

2004-03-19 Thread Lester Caine
Maximiliano Robaina wrote: There are any plan about support for direct access to Firebird SQL DBMS? The interbase dll driver include in php 4.x work fine with Firebird 1.5? Both PHP4 and the enhanced PHP5 Interbase drivers are fine. There is a continual discussion on the firebird-php yahoo list

[PHP-DB] Stuck on basic concept, how to use a list selection?

2004-03-19 Thread Doug F
I want to: Populate a dropdown list with values from a MySQL db (done and working). Use the selected value as the 'where' clause in a second query. Return the results and display them to the user. Any pointers are appreciated - noob^3 (html, mysql, and php). Doug Code that I'm using: html body

[PHP-DB] How to use value from a pick list?

2004-03-19 Thread dogu
I'd like to have a form that does the following: User picks a site from a dropdown list from a MySQL db (that works - code below, thanks to all those on the web who posted code for this). Once the value is selected, a second query is run using the site as the 'where' clause and the results are

Re: [PHP-DB] Stuck on basic concept, how to use a list selection?

2004-03-19 Thread John W. Holmes
From: Doug F [EMAIL PROTECTED] Populate a dropdown list with values from a MySQL db (done and working). Use the selected value as the 'where' clause in a second query. Return the results and display them to the user. Any pointers are appreciated - noob^3 (html, mysql, and php). Doug Code

Re: [PHP-DB] Stuck on basic concept, how to use a list selection?

2004-03-19 Thread dogu
John, I'm still not quite there, I can see the misty shape of a solution but the details are still a bit hazy. The code I posted it the whole shebang. I've made some attempts to 'form enable' it, but can't figure out where to put the form.../form, and submit stuff so the entire thing renders

Re: [PHP-DB] Stuck on basic concept, how to use a list selection?

2004-03-19 Thread John W. Holmes
From: dogu [EMAIL PROTECTED] I'm still not quite there, I can see the misty shape of a solution but the details are still a bit hazy. The code I posted it the whole shebang. I've made some attempts to 'form enable' it, but can't figure out where to put the form.../form, and submit stuff so

[PHP-DB] Re: How to use value from a pick list? dup post, sorry

2004-03-19 Thread dogu
Sorry for the dup - I had trouble posting to the list and managed to double post. Doug Dogu wrote: I'd like to have a form that does the following: User picks a site from a dropdown list from a MySQL db (that works - code below, thanks to all those on the web who posted code for this). Once

Re: [PHP-DB] Stuck on basic concept, how to use a list selection?

2004-03-19 Thread dogu
Awww jeez, you mean I have ta think? LOL. I appreciate the comments. Not asking for full code, don't want that ever. I think I may be going at this the wrong way - biting off too much at one sitting. I'm working from a book by Steven Schafer Apach, MySQL, and PHP - Weekend Crash Course'.

[PHP-DB] Sessions, Cookies and other

2004-03-19 Thread Craig Hoffman
Hi there, I have a script where the administrator of the site can add / edit / delete records. Here's how its works: basically the admin selects a user from a drop down menu and hits submit. This goes to a page where it queries the DB and returns some basic info - name, email address and so

RE: [PHP-DB] ?DHTML Layers with PHP?

2004-03-19 Thread Galbreath, Mark A
This worked great (except for a couple of formatting issues) - I am able to build the hierarchical menus from database data dynamically with PHP. Thanks for the link! Mark -Original Message- From: Paul Miller [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 12:23 PM This JS

[PHP-DB] Selecting one row by random, where a column is set

2004-03-19 Thread Mathias Hunskr Furevik
Using MySQL. I've got the SQL line: $sql = SELECT * FROM shop_items ORDER BY RAND() LIMIT 1; I've got a column which is called image_large. The tricky part is, not all of the image_large rows exists. Whis the query above, I want to get only a row where image_large is present. - Mathias

Re: [PHP-DB] Selecting one row by random, where a column is set

2004-03-19 Thread John W. Holmes
Mathias Hunskår Furevik wrote: I've got the SQL line: $sql = SELECT * FROM shop_items ORDER BY RAND() LIMIT 1; I've got a column which is called image_large. The tricky part is, not all of the image_large rows exists. Whis the query above, I want to get only a row where image_large is

Re: [PHP-DB] Stuck on basic concept, how to .. here's how

2004-03-19 Thread dogu
John, Your remark got me pointed in the right direction - I wasn't thinking about a second form. Figuring out the syntax took a while, but it's working. I need to do some clean up to make it a bit more elegant, but the bones are there. Todo: Disconnect the MySQL session. Figure out a way to

Re: [PHP-DB] Stuck on basic concept, how to .. here's how

2004-03-19 Thread John W. Holmes
dogu wrote: Figure out a way to pass the db connection to the 2nd file rather than reconnecting. You can't pass resources. You connect on each PHP page. Put _that_ in a function to make it easy. :) -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect:

[PHP-DB] Re: [PHP-WIN] OK, ahí voy...

2004-03-19 Thread Cesar Cordovez
Felipe Eduardo Ortiz López wrote: Mi primera pregunta: ¿PHP tiene algún editor o IDE tipo las que tiene HTML? Clarifico; por ejemplo puedo trabajar con FrontPage, o el editor de textos, para generar los archivos HTML, ¿existe algo así para PHP? My first question: Has PHP some editor or IDE kinda