Hi,
I am testing to use php5.0.0b3 and connect to MySQL 4.1.1 encountered
connection problem:-
Error message:
---
[04-Feb-2004 14:45:07] PHP Fatal error: Call to undefined function
mysql_connect() in D:\Purct\New1x.php on line 1
Please help to advise what went wrong ?
--
PHP Da
Jason - you posted this a 5 weeks ago and received several answers.
http://www.phpdiscuss.com/article.php?id=32225&group=php.db
You say you have written your own code, but you have not attached it.
As Peter said, the key is probably to declare those columns unique then
allow the database to deter
For this table to create 3 unique keys I did the following, in case it
helps someone else out.
+--+--+--+-+-++
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-++
Jas wrote:
For this table to create 3 unique keys I did the following, in case it
helps someone else out.
+--+--+--+-+-++
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-+-
Hi all.
Question on running in a config with Apache2,PHP 4.3.4,MySQL 4.0.17 running
on Linux Redhat 9.0.
Basically I want to make sure that a DB insert or update is guarenteed to
complete.
So if a user hits submit on a webpage, the transaction under the hood
completes, no matter if the user hit
So if a user hits submit on a webpage, the transaction under the hood
completes, no matter if the user hits cancel or his browser dies or
whatever. (Not sure how to even test this condition, but I know it
will
happen)
Once php has the request, hitting cancel on the browser or a browser
dying wil
On Wednesday 04 February 2004 23:46, Matt Matijevich wrote:
> Once php has the request, hitting cancel on the browser or a browser
> dying will not stop the php script from executing all the way through.
Actually whether the script runs through to completion depends on the
'ignore_user_abort' se
Actually whether the script runs through to completion depends on the
'ignore_user_abort' setting.
wow, guess you learn something everyday.
wish I would have known about that when I wrote a php script with some
terrible (lots of joins, just poorly designed) queries that took down my
webserver
Hi Folks:
I just released version 1.6.0RC4 of PEAR DB. Several things have been
fixed since RC1 which is included with the latest PHP RC release. Also,
if you're using 1.5.0 variants or earlier, definitely check out the new
version for loads of enhancements and way fewer bugs.
I've also spent a
If I do this statement:
mysql_query("UPDATE hosts SET hostname=\"$_POST[hostname]\",
mac=\"$_POST[mac]\", ip=\"$_POST[ip]\", vlan=\"$_POST[vlan]\" WHERE
id=\"$_SESSION[id]\"",$db)or die(mysql_error() . mysql_errno());
I get this error:
Duplicate entry '128.110.22.139' for key 41062
I have tried
From: "Jas" <[EMAIL PROTECTED]>
> Now I have used the following to check if duplicate records exist before
> updating:
>
> // Try and update with posted fields form html form
> $update = mysql_query("UPDATE hosts SET hostname='$_POST[hostname]',
> mac='$_POST[mac]', ip='$_POST[ip]', vlan='$_POST[
From: "Jas" <[EMAIL PROTECTED]>
> for instance, say you change the mac and hostname and there is a record
> in the database with the same mac string, how can I flag the field that
> matched from the 3?
Your update will actually fail in the case, so you need to catch the error
with mysql_error() (
John W. Holmes wrote:
[snip]
When you update the table with an existing "mac" value, the error will be
similar to "Duplicate value for Key XX" where XX is what key was duplicated.
I can't remember if the keys start at zero or one, but your ID column will
be the first key, then mac, hostname, and fi
From: "Jas" <[EMAIL PROTECTED]>
> If I do this statement:
> mysql_query("UPDATE hosts SET hostname=\"$_POST[hostname]\",
> mac=\"$_POST[mac]\", ip=\"$_POST[ip]\", vlan=\"$_POST[vlan]\" WHERE
> id=\"$_SESSION[id]\"",$db)or die(mysql_error() . mysql_errno());
>
> I get this error:
> Duplicate entry
[snip]
You're not going to be able to fetch anything from the result set because
you're excuting an UPDATE query, not a SELECT.
You also do not want to die() when the query fails, otherwise you won't be
able to react to the error. Execute the query, then check mysql_error() for
a value. If it conta
Thanks guys, this is great info.
One last thought,
Suppose I have several DB transactions that I want to treat as 1 logical
transaction that I need to complete guarenteed.
For instance, an INSERT to one table, and a DELETE to another, and an UPDATE
to a third. All need to complete once a user
Suppose I have several DB transactions that I want to treat as 1
logical
transaction that I need to complete guarenteed.
For instance, an INSERT to one table, and a DELETE to another, and an
UPDATE
to a third. All need to complete once a user selects submit.
What's the best approach to this scen
Hi,
I had a similar problem and I solved it using transations, but I had to use InnoDB table types...
Regards,
Ricardo
---Mensagem original---
De: whynotpizza
Data: 02/04/04 15:33:37
Para: [EMAIL PROTECTED]
Assunto: [PHP-DB] apache/php/mysql - guarenteed DB transaction
H
You should use
set autocommit = 0;
start transaction ;
insert code;
delete code;
update code;
commit or rollback depending on the result;
To do all this I had to use InnoDB table types.
Sorry, my english is quite pour,
Best regards,
Ricardo
---Mensagem original---
De: w
IT WORKS.
Exactly, I need to unset the locale variables With that It works
without problems.
Thank you all.
in the start script to see which variables are set. Boot, move
/tmp/apache-start to /tmp/apache-boot, stop apache, start apache from
your root shell. "diff -u /tmp/apache-boot /tmp/ap
Hi ALL,
MySql support is not bundled with PHP 5.0.0
I have managed to connect to MySQL after I have copied the new dll
libmySQL.dll(in php/dlls) folder to c:\windows\system32
And modified the php.ini as per below.
In php.ini
; Directory in which the loadable extensions (modules) reside.
extension_
21 matches
Mail list logo
