[PHP-DB] Mulitpart form posts and mysql blobs
How are files encoded when theyre sent in mulitpart forms??? Is it the same as blob fields in mySQL databased when you use the LOAD_FILE() command?? If not, is it easy to convert from one to the other?? At the moment, Im taking the blob from mySQL and writing it to a file and then uploading that file through cURL! Very messy. TIA -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: [PHP] Mulitpart form posts and mysql blobs
Sorry, I should have said. Im trying to send this file to an external multipart form script which converts the file to the desired format. Im using cURL to do this. cURL can send files when given the filename, so I have to write the filename from the database and then give cURL the path. But thats messy I want to be able to get the BINARY data from mySQL and send it via cURL directly. TIA - Original Message - From: John W. Holmes [EMAIL PROTECTED] To: John Ryan [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 15, 2003 1:22 AM Subject: [PHP-DB] Re: [PHP] Mulitpart form posts and mysql blobs John Ryan wrote: How are files encoded when theyre sent in mulitpart forms??? Is it the same as blob fields in mySQL databased when you use the LOAD_FILE() command?? If not, is it easy to convert from one to the other?? At the moment, Im taking the blob from mySQL and writing it to a file and then uploading that file through cURL! Very messy. So what are you actually trying to accomplish? Moving a file from one server to another??? -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- 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] SQL File Insert???
Ive a file on my server with SQL instructions to create a table and insert stuff. How do I get this to be run on the database? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysql, finding the last record
is there any quick way of selecting the 'last' row in a mysql table?? i could write some messy code but id prefer an elegant solution. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MYSQL Table Dump
Is there any way *from the command line* to get a dump of a mysql table and have it saved to a local file, instead of standard output -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: MYSQL Table Dump
should have read the manual first, mysqldump John Ryan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Is there any way *from the command line* to get a dump of a mysql table and have it saved to a local file, instead of standard output -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] multiple queries with PHP
I want to SELECT * from a table and also update the hit counter by 1. So theres 2 different queries which I know I can easily do in PHP seperately, but I thought itd be quicker and more efficient to run them in the same query, ie seperated by a ';'. But PHP returns an error, and it works fine on the command line. I read somewhere thats its a security risk in PHP to allow 2 queries, so its turned off by default. Is this true? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] multiple queries with PHP
You wouldnt know where to change this setting? John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] John Ryan wrote: I want to SELECT * from a table and also update the hit counter by 1. So theres 2 different queries which I know I can easily do in PHP seperately, but I thought itd be quicker and more efficient to run them in the same query, ie seperated by a ';'. But PHP returns an error, and it works fine on the command line. I read somewhere thats its a security risk in PHP to allow 2 queries, so its turned off by default. Is this true? Yes. Also, just because you can fit something onto one line it doesn't mean it's more efficient. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mySQL Binaries for Linux
I downloaded what I thought was Linux mySQL binaries, and the INSTALL file said there should be a bin directory when I untar, but there isnt! Just a BUILD folder and loads of make files. Did I download the wrong one? I downloaded mysql-standard-4.0.14-pc-linux-i686.tar.gz -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] upgrading mysql remotely
i got the mysql 4 server RPM, but I dont have RPM on my server to opne it! so i got the full tar gz files of mysql 4 but when i try to compile it, it said i dont have a c compiler. so my question is, can you get mysql linux binaries that i can just put in the old mysql foler?? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] UNION Clause in queries
I have a UNION command in a query on a PHP page that works fine on my test apache/php/mysql server on windows at home but it returns an error when i upload it to the web. i checked both parts of the UNION in phpMyAdmin online and they both worked. so, can the UNION command be somehow disabled, and if so, how can i enable it again on the online site. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] upgrading mySQL remotely
i need to upgrade to mysql 4 to avail of UNION, so im just downloading the 9MB RPM on dial-up, uploading it to my remote server and then can i do the installation from the telnet?? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] SELECT FROM 2 or more tables
Is it easy?? Is it possible?? Should I just run 2 different queries and output their results in the PHP script and make it look like it's all from the same table I cant grasp JOIN for the life of me -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: SELECT FROM 2 or more tables
ive heard that before, and its in the mysql manual, to have something like WHERE table1.id = table2.id But does make any sense to me. What Im doing is providing a search form for customers that allows them to search each individual table for content or all tables. all tables have a common field, keywords, which i have searched. maybe im stupid, but i cant c where WHERE table1.id = table2.id would help, or sumting along that lines John Ryan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Is it easy?? Is it possible?? Should I just run 2 different queries and output their results in the PHP script and make it look like it's all from the same table I cant grasp JOIN for the life of me -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mySQL help on win xp
i installed php and apache fine on my pc, but mysql is giving problems. in winmysqladmin, you cant create a adb on the databases tab. all that lets you do is flush threads, flush processes, etc. so i had to create my database through the mysql command line. also, phpMyAdmin doesnt work, it returns an auth error. but i know for definite the username and password. whats going on?? is it something to do with win xp and users or win xps firewall??? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php