[PHP-DB] Binary Data problem solved :-)
Hi there everyone, Just wanted to let you know i've solved the binary data problem I was having, I can now zip both text and gif/jpeg files etc . on the fly, in the fopen command I missed out the rb at the end, I put in the r but NOT the b - doh, knew it would be something simple in the end :-) Thanks for the help with this, it's helped me to breath again :-) Chris
Re: [PHP-DB] Very cool -= Code Generator =- !!!
a php/mysql already exist : http://www.bigprof.com/appgini/ - Original Message - From: "John W. Holmes" <[EMAIL PROTECTED]> To: "'johnny1b1g'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, September 29, 2002 4:19 PM Subject: RE: [PHP-DB] Very cool -= Code Generator =- !!! > > Use Codejay as your web assistant. > > Create ASP , PHP, COLDFUSION , ASP.NET > > web applications > > Save time and money. > > > > Visit www.codejay.com > > Interesting program, did anyone else check it out?? All it really does > is generate reports and create admin interfaces to add/edit data in a > database. The reports are pretty good, you can open your database, > choose what columns you want, create relationships, add to the SQL Where > clause, make the results links (and pass values in them) or images, etc. > > It would be useful to someone with no programming experience at all, > which is always the case with these "code generators". > > There are some issues with the PHP code creation, of course. For some > reason, it uses $HTTP_GET_FILES, instead of $HTTP_GET_VARS. This, of > course, causes the Prev/Next and other links to fail. There may be > others, that's the obvious one I found right away. > > It also requires the user to turn on output buffering in php.ini. Why? > The code for some reason contains a ob_start() and session_start() call, > but it never uses a session or does anything with the buffer. If output > buffering is required to be on in php.ini, then why call ob_start()?? I > think it's a bad idea to require changes to php.ini, anyhow. > > And, the most blaring oversight, IMO, is that it only generates code for > Access and MSSQL. ?? Come on...if you're going to take the time to write > this, why not include MySQL? > > Plus, they need to run a spell and grammar check on the help files... :) > > Not worth 80 Euro / 82 dollars in my opinion... > > ---John Holmes... > > > > -- > 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] Re: binary data?
In article <000801c2658b$6ae22420$f7fea8c0@chris>, [EMAIL PROTECTED] says... > Hi there everyone, > > How can I import binary data - say from a gif file, into a string or array in PHP? >I can do text files/csv etc . but using the same method it won't do binary (I'm >sure for some obvious reason). > > Thanks for your help > > Chris fread() is documented as being binary safe - is that what you have tried? This example is in the docs: $filename = "c:\\files\\somepic.gif"; $fd = fopen ($filename, "rb"); $contents = fread ($fd, filesize ($filename)); fclose ($fd); -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Accessing Foxpro free tables using ODBC
Hi John, It could be a file permissions issue. I ran the script using PHP from XP's command prompt window and the output is fine. The problem occurs only when test.php is served by Apache. How should I grant the permissions? Do I modify php.ini or Apache's httpd.conf file? "John Lim" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi > > Looks like a file permissions problem perhaps. Grant access to the the IIS > user or make the file public to everyone. > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Very cool -= Code Generator =- !!!
i've check it, and also try it, code generated for a sample database won't run okay, most pages return errors ! if it will support others database, it will be a great tool Best regards, Hatem - Original Message - From: "John W. Holmes" <[EMAIL PROTECTED]> To: "'johnny1b1g'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, September 29, 2002 4:19 PM Subject: RE: [PHP-DB] Very cool -= Code Generator =- !!! > > Use Codejay as your web assistant. > > Create ASP , PHP, COLDFUSION , ASP.NET > > web applications > > Save time and money. > > > > Visit www.codejay.com > > Interesting program, did anyone else check it out?? All it really does > is generate reports and create admin interfaces to add/edit data in a > database. The reports are pretty good, you can open your database, > choose what columns you want, create relationships, add to the SQL Where > clause, make the results links (and pass values in them) or images, etc. > > It would be useful to someone with no programming experience at all, > which is always the case with these "code generators". > > There are some issues with the PHP code creation, of course. For some > reason, it uses $HTTP_GET_FILES, instead of $HTTP_GET_VARS. This, of > course, causes the Prev/Next and other links to fail. There may be > others, that's the obvious one I found right away. > > It also requires the user to turn on output buffering in php.ini. Why? > The code for some reason contains a ob_start() and session_start() call, > but it never uses a session or does anything with the buffer. If output > buffering is required to be on in php.ini, then why call ob_start()?? I > think it's a bad idea to require changes to php.ini, anyhow. > > And, the most blaring oversight, IMO, is that it only generates code for > Access and MSSQL. ?? Come on...if you're going to take the time to write > this, why not include MySQL? > > Plus, they need to run a spell and grammar check on the help files... :) > > Not worth 80 Euro / 82 dollars in my opinion... > > ---John Holmes... > > > > -- > 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] Very cool -= Code Generator =- !!!
Also check out .codecharge.com - it's a bit more matured. I couldn't get codejay to work on my machine - can't even remember the errors. I just removed it after 2 hours of frustration. Tim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] export to csv file
You need to specify a path that the webserver has write permissions to. Yes this can be bad, so be careful. I have a script that grabs data from2 databases and writes the report out to a csv file, which the browser then downloads. - Original Message - From: Diana Castillo <[EMAIL PROTECTED]> Date: Saturday, September 28, 2002 10:02 am Subject: [PHP-DB] export to csv file > Hi, I want to export some fields on a regular basis from a table > to a text > file, preferable to the users local computer. I tried writing to a > file with > fopen but I get "permission denied" when I try to open it for writing. > What is the best solution? > Thanks, > Diana > > -- > See my web page: > http://www.netrox.net/%7Ecastillo/hghindex.htm > > > > -- > 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] Re: Accessing Foxpro free tables using ODBC
"Yue Teng" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Dear All, > > Warning: SQL error: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file > c:\web\data\dblist.dbf., SQL state S1000 in SQLExecDirect in c:\web\test.php > on line 10 > > Since the same ODBC DSN can be accessed from other programs, is it > possible that I have left out something when configuring PHP? > Hi Looks like a file permissions problem perhaps. Grant access to the the IIS user or make the file public to everyone. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Very cool -= Code Generator =- !!!
> Use Codejay as your web assistant. > Create ASP , PHP, COLDFUSION , ASP.NET > web applications > Save time and money. > > Visit www.codejay.com Interesting program, did anyone else check it out?? All it really does is generate reports and create admin interfaces to add/edit data in a database. The reports are pretty good, you can open your database, choose what columns you want, create relationships, add to the SQL Where clause, make the results links (and pass values in them) or images, etc. It would be useful to someone with no programming experience at all, which is always the case with these "code generators". There are some issues with the PHP code creation, of course. For some reason, it uses $HTTP_GET_FILES, instead of $HTTP_GET_VARS. This, of course, causes the Prev/Next and other links to fail. There may be others, that's the obvious one I found right away. It also requires the user to turn on output buffering in php.ini. Why? The code for some reason contains a ob_start() and session_start() call, but it never uses a session or does anything with the buffer. If output buffering is required to be on in php.ini, then why call ob_start()?? I think it's a bad idea to require changes to php.ini, anyhow. And, the most blaring oversight, IMO, is that it only generates code for Access and MSSQL. ?? Come on...if you're going to take the time to write this, why not include MySQL? Plus, they need to run a spell and grammar check on the help files... :) Not worth 80 Euro / 82 dollars in my opinion... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php