[PHP-DB] Re: xml to mysql tables using php
babu wrote: Hi all, I have seen in zend.com about parsing an xml document using php. i have also seen an interesting article which uses perl or java to move data from xml to database and vice versa. Does php has such functions to do so. Thanks It certainly does support parsing XML - see http://php.net/xml for all the gory details. Of course, you'll need to write your own code to insert the parsed data into your favourite database. Cheers -- David Robley Everything bows to success, even grammar. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PEAR DB and MSSQL
My company runs a Linux based PHP website with a MySQL database backend.
We also have several MSSQL databases deployed throughout the
organization. One of our MSSQL databases has a process running on it
that transfers it's data to our MySQL database. However this process
has become unstable and the data does not always make it over. This is
mission critical data and must be present on the website to meet
federal and state regulations.
Our director has mandated that we get rid of the data transfer and query
the MSSQL database directly. I have found several very useful sites on
the net to give me instructiosn on setting this up. I installed
unixODBC and FreeTDS and set up a test server using fedora core 1.
When I first got unixODBC and FreeTDS installed, I was able to connect
to the database just fine. However, when I rebooted the server and
tried to connect again PEAR returns a db_error object with a message of
[nativecode=IM002 [unixODBC][Driver Manager]Data source name not found,
and no default driver specified] ** odbc://#:#/@# {hash
marks added to hide username and password and ODBC name}. I got the
message from the output of print_r($db).
After the reboot, I was still able to connect to the MSSQL database from
the console using isql so this does not appear to be an issue with
unixODBC and FreeTDS.
Does anyone have a clue as to why this happened and what I can do to get
this working?
Thank you,
Robbert van Andel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: Re: [PHP-DB] PEAR DB and MSSQL
I am using an RPM version of PHP, would updating the install do the same
thing, or do I have to manually install PHP from source?
Robbert
Frank M. Kromann [EMAIL PROTECTED] wrote on 06/13/2005, 07:08:38
PM:
Hi Robbert,
Not sure whey your system stops working after a reboot, but when you are
on Linux and using FreeTDS you do not need unixODBC. Just recompile php
using the option --with-mssql=/path/to/freetds. You can then use the
native mssql functions to connect to the server, and this is also
supported through PEAR DB.
Just my 2 cents.
- Frank
My company runs a Linux based PHP website with a MySQL database
backend.
We also have several MSSQL databases deployed throughout the
organization. One of our MSSQL databases has a process running on it
that transfers it's data to our MySQL database. However this process
has become unstable and the data does not always make it over. This is
mission critical data and must be present on the website to meet
federal and state regulations.
Our director has mandated that we get rid of the data transfer and
query
the MSSQL database directly. I have found several very useful sites on
the net to give me instructiosn on setting this up. I installed
unixODBC and FreeTDS and set up a test server using fedora core 1.
When I first got unixODBC and FreeTDS installed, I was able to connect
to the database just fine. However, when I rebooted the server and
tried to connect again PEAR returns a db_error object with a message of
[nativecode=IM002 [unixODBC][Driver Manager]Data source name not found,
and no default driver specified] ** odbc://#:#/@# {hash
marks added to hide username and password and ODBC name}. I got the
message from the output of print_r($db).
After the reboot, I was still able to connect to the MSSQL database
from
the console using isql so this does not appear to be an issue with
unixODBC and FreeTDS.
Does anyone have a clue as to why this happened and what I can do to
get
this working?
Thank you,
Robbert van Andel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Com 1
Hi,. any one to know, how to send ascci file to com1 port from php ?? thx, nandar
Re: [PHP-DB] Com 1
From the manual's user supplied comments: (Looks like this is for a windows
machine)
http://us4.php.net/fopen
// Use this code to write directly to the COM1 serial port
// First, you want to set the mode of the port. You need to set
// it only once; it will remain the same until you reboot.
// Note: the backticks on the following line will execute the
// DOS 'mode' command from within PHP
`mode com1: BAUD=9600 PARITY=N data=8 stop=1 xon=off`;
$fp = fopen (COM1:, w+);
if (!$fp) {
echo Uh-oh. Port not opened.;
} else {
$e = chr(27);
$string = $e . A . $e . H300;
$string .= $e . V100 . $e . XL1SATO;
$string .= $e . Q1 . $e . Z;
echo $string;
fputs ($fp, $string );
fclose ($fp);
}
Mark Cain
- Original Message -
From: Nandar [EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Monday, June 13, 2005 11:01 PM
Subject: [PHP-DB] Com 1
Hi,.
any one to know, how to send ascci file to com1 port from php ??
thx,
nandar
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
