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

Lester Caine wrote: Lukas Smith wrote: mysql: http://marc.theaimsgroup.com/?l=pear-devm=108239153527834w=2 ibase: http://marc.theaimsgroup.com/?l=pear-devm=108240351804395w=2 there are other interesting points being discussed through out this thread but with a noteably focus on the pear

Re: [PHP-DB] Capturing a sql query

Just a followup and you can give me your opinion (which would be greatly appreciated. While I was working through the code, I came across a variable not previously in my awareness: $_SERVER[QUERY_STRING] all i do now is grab that and it inserts everything past the ? into the database. I

Re: [PHP-DB] Capturing a sql query

Not so much that it is bad but you might be storing data you dont need to, all you really need to store are the keywords the person has searched for. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List

Re: [PHP-DB] Capturing a sql query

Right, and it is storing more then I need. After running it a few times, I decided to see what happens if someone chose every parameter possible. What I found is that even if I just saved the keywords, I'd still need to use mediumtext. In mysql, there doesn't seem to be anything between varchar

Re: [PHP-DB] Capturing a sql query

why do you need more than a varchar? the persons keywords shouldnt be that much text for each agent maybe PHP+Programming+Vermont -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List

Re: [PHP-DB] Capturing a sql query

It's more then keywords actually. There are 3 list boxes, one for states, one for industries and one for taxterm., so 50 states , industries, something like 20 i think but may grow, taxterm - not many. Plus city search, job title search, how far back in days do you want to search, and finally

[PHP-DB] which DB to use?

Thank you very much for your help. If I had to choose between MS SQL Server or or mysql, which would you recommend? I prefer nested subqueries, triggers, procedures etc supported by SQL Server but am completely unfamiliar with any problems that may be accociated with using Microsoft's product

Re: [PHP-DB] which DB to use?

i am not a fan of microsoft go with mysql :) -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Invisible Submit

I'm sure this can be done, just not sure how, or more what it's called. If I have an awaiting form to capture input from session and url variables , instead of having a button to click to submit the form, a way that the form submits on it's own ? Stuart -- PHP Database Mailing List

[PHP-DB] MySQL performance and crash

I use a Linux web server with PHP-MySQL. The hardware is good enough with 2GHz CPU and 1 GB RAM. and 7200 Cycle/min Serial ATA IDE HDD. Only one web site is running on it and on every page of that site, it searchs for a value in Users table including 78000 records and updates that value. The MySQL

Re: [PHP-DB] which DB to use?

Check the MySQL docs - I *think* subqueries are supported in the latest version, but not triggers or stored procedures. But as I say, check. Alternatives? PostgreSQL or Firebird. HTH - Miles Thompson At 11:07 AM 10/1/2004, Matthew Perry wrote: Thank you very much for your help. If I had to

RE: [PHP-DB] Invisible Submit

You could do something trick with an IFRAME or something that calls another script passing the data via the URL/$_GET instead of submitting a hidden form. Or just record the data in the session variables and process it that way. If you're using PHP, there's lots of things you can do to capture

Re: [PHP-DB] Invisible Submit

Javascript. Forms are submitted from the client, so PHP has absolutely nothing to do with submitting a form. PHP just process the data passed to it. You can you javascript timers to automatically submit a form after a certain interval. On Oct 1, 2004, at 10:19 AM, Stuart Felenstein wrote: I'm

Re: [PHP-DB] Invisible Submit

I am sure that I have no other choice but to submit the form. So right now this is the form action: form name={HTMLFormName} action={Action} method=post Now once I hit submit button it takes me to another form where some of the data from the first is passed over via URL. I saw some items

Re: [PHP-DB] which DB to use?

On Fri, 01 Oct 2004 11:24:10 -0500, Matthew Perry [EMAIL PROTECTED] wrote: The latest version is still only alfa. Miles Thompson wrote: Check the MySQL docs - I *think* subqueries are supported in the latest version, but not triggers or stored procedures. But as I say, check.

RE: [PHP-DB] microsoft access

I'm guessing that COM is going to be overkill for this. I thought some systems like ADOdb let you get to Access tables directly without COM. I'm imaginging that COM might not always be a viable way to go anyway, if you have an Access .MDB file on a server where your PHP stuff is hosted, they

RE: [PHP-DB] microsoft access

ADODB is a PHP abstraction layer class. In other words it hides the fact that it is using the odbc extension to connect to Access. And, it has another driver that uses the COM extension to connect to Accesss (ado_access). Basically there are only 3 options for connecting to Access from PHP. They

RE: [PHP-DB] microsoft access

Thanks for the clarification, Bob. ADOdb is one of those things that I use, but don't really think about much so terms like abstraction layer didn't come immediately to mind. So in the interest of not sounding like a dumbass and using the wrong terms, I just kept my response vague :) At any

RE: [PHP-DB] microsoft access

Hi Trevor ODBTP is a technology that allows you to remotely access a Win32 machine's ODBC facilities to connect to a database. IF provides faster and more advanced support for ODBC than PHP's native support. For example, ODBTP connects to a database using ODBC 3, while PHP's native ODBC support

[PHP-DB] Setting a timed-session

Hi all. This may be a bit elementary, however, I am confused on the functionality of it. I am wanting to create a session that logs out after a certain amount of time, no matter if the user is doing something or not. I have used the function `set_time_limit()`, but I don't know if I'm using it

RE: [PHP-DB] MySQL performance and crash

Do you have indexes on the searched columns? Are you searching on numeric links not text (numbers are easier to compare) What is your structure / data like? Bastien From: Murat BIYIKLI [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL performance and crash Date: Fri, 1 Oct 2004

RE: [PHP-DB] Setting a timed-session

http://ca3.php.net/manual/en/function.session-set-cookie-params.php is what you need to look at. set_time_limit only sets a time limit for the script itself. it does not affect the sessions bastien From: Philip Thompson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Setting a

Re: [PHP-DB] Setting a timed-session

On Fri, 01 Oct 2004 14:16:44 -0500, Philip Thompson [EMAIL PROTECTED] wrote: This may be a bit elementary, however, I am confused on the functionality of it. I am wanting to create a session that logs out after a certain amount of time, no matter if the user is doing something or not. I have

Re: [PHP-DB] Re: Convert plain text to HTML tagged text

I have a question along this line... is it possible to have PHP do more than one str_replace at the same time? or would I need to pass through each time seperately? I.e I wasn to check for Line returns and change it to p, i want to replace [c] with a special formating tag etc...? Thanks?

Re: [PHP-DB] User Activities

balwantsingh wrote: hi may pls. help me i am using PHP and MYSQL. is there any command through which i can record which user modifiyed the data through which command (insert / update / delete etc.) on which time and date in a table in mysql. maybe you should describe your application or needs.