[PHP-DB] Testing code

2003-07-02 Thread Hugh Dickinson
Is it possible to test PHP and MySQL scripts and databases without being registered on a web server?

[PHP-DB] XML to MySQL

2003-07-02 Thread Nabil
Dear All ; I have an XML files like the following and i want to make an PHP code to insert it into my MySQL how can i read the nodes ot tages??? by the way i can export like this file from PhpMyAdmin but i cann't dump it back... Thanks in advance Nabil ?xml version=1.0 encoding=windows-1252 ? -

[PHP-DB] Re: Testing code

2003-07-02 Thread Nabil
run the mysqld on shell Hugh Dickinson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Is it possible to test PHP and MySQL scripts and databases without being registered on a web server? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] converting function to class and function (object)

2003-07-02 Thread ed anderson
Dell 4500, mem 1g, disk 45g, mhz 2g, Mysql-3.23.54a-linux-i686, PHP-4.30, httpd_2.0.44, moxilla 1.0.1 Can someone help converting a function to a class and function. The included function in example 1 works as expected but the include class and function in example 2 does not. What can I do to

[PHP-DB] insert NULL to mysql table.

2003-07-02 Thread anders thoresson
Hi, I've the query UPDATE un_issue SET i_editor = '$editor' WHERE i_date = '$issue' where $editor = /0 but the inserted value in un_issue.i_editor becomes 0. un_issue is defined as follows: CREATE TABLE un_issue ( i_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL, i_date DATE NOT

Re: [PHP-DB] insert NULL to mysql table.

2003-07-02 Thread jeffrey_n_Dyke
how about \0. yours is a foward slash not an escape. though that may just be your post you can also use an unquoted NULL. hth jeff

[PHP-DB] Re: insert NULL to mysql table.

2003-07-02 Thread Pete Morganic
'$issue' where $editor = is null Anders Thoresson wrote: Hi, I've the query UPDATE un_issue SET i_editor = '$editor' WHERE i_date = '$issue' where $editor = /0 but the inserted value in un_issue.i_editor becomes 0. un_issue is defined as follows: CREATE TABLE un_issue ( i_id INT PRIMARY

Re: [PHP-DB] insert NULL to mysql table.

2003-07-02 Thread anders thoresson
UPDATE un_issue SET i_editor = null WHERE i_date = '$issue' Thanks. But how come this works and sets i_editor to NULL UPDATE un_issue SET i_editor = $editor WHERE i_date = \$issue\ but the following two gives me a sql-error You have an error in your SQL syntax near 'WHERE i_date = ' at line 1

RE: [PHP-DB] insert NULL to mysql table.

2003-07-02 Thread Hutchins, Richard
Anders, I don't know the specific answer to the question you pose, but if you echo() out your db query before you send it to the db, you'll be able to see the query as it is going to be sent to the db. You can then use your MySQL syntax knowledge to find the error in the different query strings.

[PHP-DB] Problem with select-tag within a php-script

2003-07-02 Thread Ruprecht Helms
Hi, I've some trouble with a select-tag in a php-script. In a database should be written the ID of a table, the user could select the recordset by the Name. My problem is that the fieldentry of the selecttag is not transfered to the executionscript. The different Names within the recordset are

RE: [PHP-DB] Problem with select-tag within a php-script

2003-07-02 Thread Snijders, Mark
the select has to be a name and not the id the id has to be within the option value! -Original Message- From: Ruprecht Helms [mailto:[EMAIL PROTECTED] Sent: woensdag 2 juli 2003 15:51 To: [EMAIL PROTECTED] Subject: [PHP-DB] Problem with select-tag within a php-script Hi, I've some

RE: [PHP-DB] Testing code

2003-07-02 Thread Matthew Moldvan
Yes, but it can be complicated ... you have to install MySQL (www.mysql.com) and PHP (www.php.net) and web server software, such as Apache (www.apache.org). I recently setup a test server on Windows XP with little trouble ... Good luck! Regards, Matthew Moldvan System Administrator Trilogy

[PHP-DB] removing a # from a string

2003-07-02 Thread Rick Dahl
How would I remove a # from a string? I want #2 to be 2. - Rick

[PHP-DB] detecting browser close or change of url

2003-07-02 Thread Jamie Saunders
Hi, I'm trying to figure out a way of detecting when a user closes the browser, or if they leave the site. If they do this I'd like to change a value in the database, i.e: if (browser is closed by user or they leave site) { // run php code to update database } Any help much appreciated. --

[PHP-DB] Re: removing a # from a string

2003-07-02 Thread Joseph Szobody
How would I remove a # from a string? I want #2 to be 2. $str = #2; $str = str_replace(#,,$str); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MS-SQL Connection Problem

2003-07-02 Thread Martin Weber
Hi, I'm using MS-SQL-Server (MSDE, ServicePack 3), with Apache 1.3.27 PHP/4.3.1 completely under Windows 2000. My task is, to build an installation package, which installs MSDE, Apache and PHP and some PHP-code on arbitrary Windows 2000 systems. Currently my installation package is running.

Re: [PHP-DB] detecting browser close or change of url

2003-07-02 Thread Oscar Rylin
PHP is server-side, not client side. That said, what you could do is simply make use of window.onunload or window.onclose in javascript to bring up a second window/page.. of course, anyone with half a brain and a popup-stopper won't get that page :) --rylin Jamie Saunders wrote: Hi, I'm

[PHP-DB] IB/FB and array field

2003-07-02 Thread Martin
Hi, I need to insert integer values into array field in FireBird/InterBase's table with PHP, but don't know how to do it. Does anyone has a working example please? -- Martin (mailto:[EMAIL PROTECTED]) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] detecting browser close or change of url

2003-07-02 Thread Jamie Saunders
Ok, let's explain the situation more fully: Basically I have a session controlled login system for users to my site. If they manually log-out, close the browser or move away from the site the variables that are needed for them to view the 'members area' are unset, hence they are logged out. What

RE: [PHP-DB] detecting browser close or change of url

2003-07-02 Thread Hutchins, Richard
Jamie, Read through this thread: http://marc.theaimsgroup.com/?l=php-dbm=104162246227155w=2 Since you are using a login/logout system, you may be able to use some of the suggestions in here to solve your problem. Rich -Original Message- From: Oscar Rylin [mailto:[EMAIL PROTECTED]

Re: [PHP-DB] detecting browser close or change of url

2003-07-02 Thread Oscar Rylin
You might also want to take a look at PEAR Auth http://pear.php.net/manual/en/package.authentication.auth.intro.php --rylin Hutchins, Richard wrote: Jamie, Read through this thread: http://marc.theaimsgroup.com/?l=php-dbm=104162246227155w=2 Since you are using a login/logout system, you may be

Re: [PHP-DB] detecting browser close or change of url

2003-07-02 Thread Pablo
On 07/02/2003 10:06 AM, Jamie Saunders ([EMAIL PROTECTED]) wrote: What I want to do is disable people logging into the same user account at the same time. If this is your goal, try reversing your way of thinking. Instead of worrying about what happens when a user logs out (or doesn't),

[PHP-DB] should each php-script clean up it's mysql connections

2003-07-02 Thread anders thoresson
Hi, I just noticed something I haven't done before. I was writing this piece of code: $articlequery = SELECT somestuff FROM sometable; $result = mysql_query($query); $row = mysql_fetch_row($result); But I didn't get the result I expected. Finally, I noticed that my new querystring was

[PHP-DB] Connect Active Directory using LDAP... please help :)

2003-07-02 Thread Vince C
Hi everyone, I tried to connect to Active Directory (AD) by using php. I heard that it could use LDAP to achieve it. I have written some code on my machine (Win2000) and try to connect to AD. It looks like the it could connect, bind, and even search (I determined base on the line I placed).

[PHP-DB] Re: mysql database function problem

2003-07-02 Thread Andres
Thanks, it works...mysqlerror() told me the exact problem and I could solve it thanks David Robley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Hello Everybody! I tried to connect with a mysql databasem , but It shows