RE: [PHP-DB] can you use php to connect to both FileMaker and MySQL simultaneously
I've never done it, but assuming there is a connector for filemaker, there is no reason you shouldn't be able to. -Original Message- From: Tami Williams [mailto:[EMAIL PROTECTED] Sent: Monday, April 17, 2006 3:14 PM To: php-db@lists.php.net Subject: [PHP-DB] can you use php to connect to both FileMaker and MySQL simultaneously Thanks in advance for any help. Can you use php to connect to both FileMaker and MySQL simultaneously? Has anyone ever done it? -- 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
RE: [PHP-DB] Displaying Date from Value in MySQL DB
Add an AS to your statement ... ditoevents.eventdate,DATE_FORMAT(ditoevents.eventdate, '%a, %b %d %Y') AS eventdateformatted, ditoevents.eventtime ... then $row[eventdateformatted] should contain the date in the way you want it. -Mike -Original Message- From: Tyler Replogle [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 5:36 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Displaying Date from Value in MySQL DB You could always make your own function. If you need help with that i would be glad to help there too. From: Justin @ Dreaming in TO [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Displaying Date from Value in MySQL DB Date: Tue, 20 Apr 2004 14:27:30 -0400 Hey All, Looking to try to figure at small problem. This is the SQL query I am using to show the next event on a page: SELECT ditoevents.eventstatus, ditoevents.eventdate, DATE_FORMAT(ditoevents.eventdate, '%a, %b %d %Y'), ditoevents.eventtime, ditoevents.eventlocation, ditoevents.topic, ditoevents.presenter FROM ditoevents WHERE ditoevents.eventstatus = 'next' This is the structure of the table in the MySQL db: CREATE TABLE ditoevents ( ID char(3) NOT NULL default '', eventID char(2) NOT NULL default '', eventstatus varchar(4) NOT NULL default '', eventdate date NOT NULL default '-00-00', eventtime time NOT NULL default '00:00:00', eventlocation text NOT NULL, topic text NOT NULL, presenter text NOT NULL ) TYPE=MyISAM; The problem is, the date value that's being pulled from the DB is being displayed as 2004-05-12. I would like the date to be displayed as, Wednesday, May 12th, 2004. How do I do this with PHP. I looked at some of the date functions, and I'm a bit confused. Thanks, Justin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Stop worrying about overloading your inbox - get MSN Hotmail Extra Storage! http://join.msn.com/?pgmarket=en-uspage=hotmail/es2ST=1/go/onm00200362 ave/direct/01/ -- 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
RE: [PHP-DB] RE: Need help Get/send Variabel to another window
I'm guessing this is html? Parent.opener.formname.formfield.value = this.value; Michael Scappa -Original Message- From: Jeremy Shovan [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 12:24 PM To: 'agus supriatna'; [EMAIL PROTECTED] Subject: [PHP-DB] RE: Need help Get/send Variabel to another window Is it a frame page? -Original Message- From: agus supriatna [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 1:25 AM To: [EMAIL PROTECTED] Subject: Need help Get/send Variabel to another window Dear all I have two page one as main and secon as child, now I have problem how to send variable/data to main page from child thanks in advance asupna -- 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
RE: [PHP-DB] Trouble with uploading a file via ftp_put
Ruprecht, I've experienced this problem, its that you need to turn ftp_pasv on. ftp_pasv($connection_id,true); That should take care of it, don't' worry about anything else. Michael Scappa Lead Developer Verve Internet Solutions for higher education -Original Message- From: Ruprecht Helms [mailto:[EMAIL PROTECTED] Sent: Sunday, October 05, 2003 5:16 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Trouble with uploading a file via ftp_put Hi, by uploading a file via the ftp_put-command the upload is not done properly. Result is I have a file in the destinationdirectory but 0 bit in size, only the filename is transfered. How have I to write the script that the file I want upload should be uploaded within the correct size. The actual script you can see here. [code] $conn_id=ftp_connect('62.241.50.14'); ftp_login($conn_id,'user','password'); echo Current directory : , ftp_pwd($conn_id), \n; ftp_chdir($conn_id,html); echo Current directory is now : , ftp_pwd($conn_id), \n; $dstdir=html; $upload=ftp_put($conn_id,$bild,$dstdir./.$bild,FTP_BINARY); [/code] Regards, Ruprecht -- 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
RE: [PHP-DB] RE: [PHP-INSTALL] Problem by running mysql-connection in php-script
Looks possible that php isn't using that particular ini file. Make sure it's the correct ini file, because your error message has it looking in a different location. Try mysql_connect(127.0.0.1:3306:/tmp/mysql.sock, etc etc etc) for your connect (that might supposed to be the path to socket, not the file itself, try both). -Original Message- From: Ruprecht Helms [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 8:15 AM To: Michael Scappa Cc: [EMAIL PROTECTED] Subject: [PHP-DB] RE: [PHP-INSTALL] Problem by running mysql-connection in php-script On Thu, 2003-10-02 at 22:28, Michael Scappa wrote: Ruprecht, Make sure you have PHP pointing to the right location for the mysql.sock. locate mysql.sock. Sometimes its in the /tmp dir. If it is in another location you can point to it specifically when you call mysql_connect (refer to php.net for the exact string), or just change it in your php.ini. This are the entries I've made in the php.ini [MySQL] ; Allow or prevent persistent links. mysql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. mysql.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. mysql.max_links = -1 ; Default port number for mysql_connect(). If unset, mysql_connect() will use ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the ; compile-time value defined MYSQL_PORT (in that order). Win32 will only look ; at MYSQL_PORT. mysql.default_port = ; Default socket name for local MySQL connects. If empty, uses the built-in ; MySQL defaults. mysql.default_socket = /tmp/mysql.sock ; Default host for mysql_connect() (doesn't apply in safe mode). mysql.default_host = localhost ; Default user for mysql_connect() (doesn't apply in safe mode). mysql.default_user = root And this is my actual /tmp-directorylinux:/tmp # ls . .esd AcroSaTWYY aaa ksocket-root migrate-2 noteedit.2vmq44 .. .shtool.8404 AcroWx7cEx alsaplayer_root_0mc-root migrate-3 noteedit.rvtxIc .ICE-unix .webmin Acrol21KzJ audacity1.1-root mcop-root migrate-4 orbit-root .X0-lock AcroAgqtL1AcrooMY5eg gsr-record-Untitled.wav-1603.BHH8QX medusa-idled-service migrate-5 .X11-unix AcroMfep2RAcrowt39f1 jpsock.141.6939 migrate migrate-6 .caitmpAcroQUQtXcAcrox5BdJI kde-root migrate-1 mysql.sock You see there is the mysql.sock And this is the connection-command in some scripts I use. Normaly it works fine, but now It fails and I get the reported error. mysql_connect(localhost,root); -- 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
Re: [PHP-DB] MySQL editor
Not free, but mysqlmanager (www.ems-hitech.com) is by far the best I've used. A free alternative (although not quite as featured) is probably Mysqlcc -Mike - Original Message - From: Angelo Zanetti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:40 AM Subject: [PHP-DB] MySQL editor Hi all. I need to get a program (interface) for MySQL, I was using MySQL Front but they've discontinued its use. Any suggestions. thanx in advance -Angelo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: order by an average in another table (basically a top 10 list)
what version of postgres, newer ones handle null values slightly differently in queries, although there is a setting you can switch to make it work like the older versions. -mike - Original Message - From: Milan Babuskov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:10 AM Subject: Re: [PHP-DB] Re: order by an average in another table (basically a top 10 list) chris wrote: I managed to figure it out on my own. For those curious, here's a starting point: SELECT parent_id, avg(rating) as average FROM ratings WHERE average IS NOT NULL GROUP BY parent_id ORDER BY average DESC, parent_id DESC It works in MySQL 3.x, but not certain about PostgreSQL. The not null check was necessary in my select statement, possibly due to the multiple joins I'm doing (I ended up with the oldest unrated picture at the top, then the top 9, instead of 10; the not null check eliminates this). It's probably because NULLs are always on bottom (and on top if you use DESC). -- Milan Babuskov http://fbexport.sourceforge.net http://njam.sourceforge.net -- 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
Re: [PHP-DB] mail() function
Yehp, actually there is :-) On windows machines you'll need to change the SMTP in there (Since you probably aren't running a local mail server), in your php.ini you can most likely change it to your ISP's mail server., there is more specific info on the docs for the mail funcion in the php manual -- refer to the user postings: http://us4.php.net/manual/en/ref.mail.php -Mike - Original Message - From: Alex Francis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 3:41 PM Subject: [PHP-DB] mail() function I have set up my pc as a test server Windows 98 running Apache as a service, PHP and MySQL but cannot get the mail() function to work. After a long wait, I get an error Warning: Failed to Receive in c:\phpdev\www\assets\submit_users.php on line 17. Is there something I should be changing in the PHP.ini. I used the default settings for this. -- 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] php oop books
I know this is a bit off topic, can anyone recommend a good php / oop book? I've been through php.net's library and nothing really on there. Thanks -Mike