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.
rea
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 , i want to replace "[c]" with a special formating
tag etc...?
Thanks?
O
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 h
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 time
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 1
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
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 u
There are many facters that have to be considered to make a proper
decision. First, as you have stated, mssql offers many features not
available in mysql. If these featuers are important, then you should
choose mssql. However, PHP's support for mysql is much better than its
support for mssql. PHP
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 ra
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
a
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 prob
Hi,
I have just learnt about the firebird project and was wondering how
alive it is. I know this is hard to quantify, but is development going
better worse than postgres? I quite frankly don't like mysql that much
and defintely want something like one of these two, but the simple
fact of the matter
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
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.
Alternatives? PostgreSQL or Firebird.
HTH - Miles Thompson
At 11:07 AM 10/1/2004, Matthew Per
> Does anyone know of a good online source for using php and microsoft
> access.
> I don't want to have to use asp.
> Thank you for your time.
you could use com objects with Microsoft ADO
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I am sure that I have no other choice but to "submit"
the form.
So right now this is the form action:
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 googling about how to make form auto
submit, but yet to
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
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 da
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 choos
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
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 (http://www
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
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 a
A very good solution for connecting to an MS Access database is the odbtp
extension. You can get it at http://odbtp.sourceforge.net. It provides
support for many of Access's features, such as UNICODE text data and query
processing, and stored query execution. An example on how to connect to a
MS Ac
On Thu, 30 Sep 2004 23:53:38 -0400, Bastien Koert <[EMAIL PROTECTED]> wrote:
> Here is a basic connect script. I would stringly recommend against using
> access, use mysql instead.
Or Firebird
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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 "r
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 (http://www.php.net/)
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 o
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 (h
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 m
Lester Caine wrote:
Lukas Smith wrote:
mysql:
http://marc.theaimsgroup.com/?l=pear-dev&m=108239153527834&w=2
ibase:
http://marc.theaimsgroup.com/?l=pear-dev&m=108240351804395&w=2
there are other interesting points being discussed through out this
thread but with a noteably focus on the pear abstra
31 matches
Mail list logo
