[PHP-DB] Downloading Database?!?!
Hello all, I am developing an Intranet page for my workplace, ATM i use phpmyadmin to do rutine backups ect, this is cool but i am going on long service leave for 14 weeks and during that time a new guy will attempt to continue to maintain the site and perform regular backups... I tried to show him how to use phpmyadmin but has proved too dificult for him to understand, how can i make a quick script to implement into a page that prompts you to download the entire sctipt in .txt form?? just like php myadmin, and starting tips and hints would be great. Cheers in advance Brenton -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Downloading Database?!?!
Have you considered using the console-tool, mysqldump? You could write a quick script ... say mysqldump -u adminuser -p adminpass --all-databases backup.sql tar -zcvf backup.tar.gz backup.sql mv backup.sql /somepath/backup.sql if you're on Winders, a batch file: mysqldump -u adminuser -p adminpass --all-databases backup.sql move backup.sql z:\somepath\backup.sql If you write a batch script, or shell script, all the new guy would have to do is run it. Create a cron job (on linux) or scheduled task (on windows) and the new guy just has to figure out the coffee machine :) Food for thought, ~Steve Brenton Dobell wrote: Hello all, I am developing an Intranet page for my workplace, ATM i use phpmyadmin to do rutine backups ect, this is cool but i am going on long service leave for 14 weeks and during that time a new guy will attempt to continue to maintain the site and perform regular backups... I tried to show him how to use phpmyadmin but has proved too dificult for him to understand, how can i make a quick script to implement into a page that prompts you to download the entire sctipt in .txt form?? just like php myadmin, and starting tips and hints would be great. Cheers in advance Brenton -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP5.0, MySQL4.1, Apache2 on WinXP
PHP 5.0 doesn't come with mysql support... You have to get the libraries yourself... I think u can get them from mysql.com php_mysql is in the extensions directory of the latest downloads, just uncomment it in the php.ini file. Might have to pay? I haven't totally figure out the implications of the no mysql in PHP 5.0 yet, but I know its not there. No charge for it in PHP, it's the changes to the mysql licence that cause the problem. Mysql is not necessarily free for commercial use, and THAT aspect is now being pressed by mysql. Try Firebird - works great with PHP, and many of the add on database packages, and is totally free. www.firebirdsql.org -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] write to word..
Hi I did it like this ?php //create file here //then output it header (Content-type: application/msword); header (Content-Disposition: attachment; filename=letter.doc); include('letter.htm'); print('done it') ? I wrote the letter to file and then included it, but you can probably just print HTML as you would normally. Word will open HTML files and maintain the format. HTH Peter -Original Message- From: Chris Mach [mailto:[EMAIL PROTECTED] Sent: 23 July 2003 03:01 To: [EMAIL PROTECTED] Subject: [PHP-DB] write to word.. hi, I'm just wondering if it is possible to write to a word document or any other file type that would allow for easy editing(besides txt) with out having to copy and past everything in? I'm looking to have a template perhaps in word and have the code insert variables from the database. If it is possible, could some one point me in the right direction. Like where to look in the manual. Thanks, Chris -- 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] write to word..
Better still, Take a look at RTF as a file format. Its readable in Word, looks like a Word doc and can be saved with a '.doc' extension and you can store placeholders that php can use to 'mail-merge' with. Works for me. Cheers George -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED] Sent: 23 July 2003 9:04 am To: Chris Mach; [EMAIL PROTECTED] Subject: RE: [PHP-DB] write to word.. Hi I did it like this ?php //create file here //then output it header (Content-type: application/msword); header (Content-Disposition: attachment; filename=letter.doc); include('letter.htm'); print('done it') ? I wrote the letter to file and then included it, but you can probably just print HTML as you would normally. Word will open HTML files and maintain the format. HTH Peter -Original Message- From: Chris Mach [mailto:[EMAIL PROTECTED] Sent: 23 July 2003 03:01 To: [EMAIL PROTECTED] Subject: [PHP-DB] write to word.. hi, I'm just wondering if it is possible to write to a word document or any other file type that would allow for easy editing(besides txt) with out having to copy and past everything in? I'm looking to have a template perhaps in word and have the code insert variables from the database. If it is possible, could some one point me in the right direction. Like where to look in the manual. Thanks, Chris -- 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] permission...
When I get a warning like below, is that something I can fix by modifying the code? or is that some configuration that need to be changed on the server? Warning: unable to create file files/sked.html because Permission denied in /server3/home/cjmach/public_html/newfile.php on line 14 I get this warning when I try to create or edit txt files with php. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] session problem
I have installed an user-login aplication on my website ( http://www.norbertnet.ro ) but i have problems with session controls. I receive all kinds of warnings and i don't know how to interpret them thanks advanced - Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger
RE: [PHP-DB] session problem
This is advertising a porno site. -Original Message- From: tana dsasa [mailto:[EMAIL PROTECTED] Sent: 23 July 2003 11:11 To: [EMAIL PROTECTED] Subject: [PHP-DB] session problem I have installed an user-login aplication on my website ( http://www.norbertnet.ro ) but i have problems with session controls. I receive all kinds of warnings and i don't know how to interpret them thanks advanced - Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger http://www.cantor.com CONFIDENTIAL: This e-mail, including its contents and attachments, if any, are confidential. If you are not the named recipient please notify the sender and immediately delete it. You may not disseminate, distribute, or forward this e-mail message or disclose its contents to anybody else. Copyright and any other intellectual property rights in its contents are the sole property of Cantor Fitzgerald. E-mail transmission cannot be guaranteed to be secure or error-free. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. Although we routinely screen for viruses, addressees should check this e-mail and any attachments for viruses. We make no representation or warranty as to the absence of viruses in this e-mail or any attachments. Please note that to ensure regulatory compliance and for the protection of our customers and business, we may monitor and read e-mails sent to and from our server(s). For further important information, please read the Important Legal Information and Legal Statement at http://www.cantor.com/legal_information.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Pros/Cons Database vs Excel
You can achieve much more with a Database backend, if your boss likes spreadsheets (XLS) then you can always export from any database backend (which ever one you want). He can still keep hyperlinks etc for web access etc if he would display the database results onto webpages/excel/text/etc!. Perhaps your Boss's company is small and he just wants to keep things simple to him and shy away from having to hire somebody that knows how things work when you have databases involved. I agree you have 1000% more possibilities with a database backend! Excel if you look at it is also a 'database' with the capacity to enable users to make it look as a report! (all in one!) its not a great database solution but it works for the small companies. Good luck convincing him! Cheers! Ow Mun Heng [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I'm having a problem convincing my boss of the benefits of using a database vs just using excel as a way of tracking events. The boss' stance is that excel is more 'simple' columns can be expanded as and when it's wanted. You can put links into excel that points to files residing in the system (within the web server's reach), can be mailed out to distribution lists (some ppl are lazy to need to open up a browser, log on etc.. to view the data). It can be stored on the web server for retrieval later etc.. For a database, actually a database can do all of the above but to me, it's makes more sense as it can store all the above and provide additional functionality (as long as The code is written to make it more functional). Can anyone help me out and give me a few pointers on why using a database makes more sense then excel. What's needed: 1. Method for tracking sequence of events (sort of like experiment results) 2. Links embedded inside to relevent files (results of experiment) 3. Can be mailed around 4. additional fields can be added whenever wanted something like that.. Cheers, Mun Heng, Ow H/M Engineering Western Digital M'sia DID : 03-7870 5168 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Downloading Database?!?!
You can create a batch file like this or if you want it to be in a web interface much like phpmyadmin, but with your backup scheme you can use the load data outfile command. This page from the mysql manual describes both the infile and outfile methods: http://www.mysql.com/doc/en/LOAD_DATA.html. This will tell you how to use the syntax for the text files. It will let you do it with tabs, commas, etc. Then you can use php to create the interface for your new guy and make it as simple or complex as you like, but you don't even have to use the filesystem functions to do it this way. Which does make it a little simpler so that you can plan for 14 weeks of whatever you're doing. David Smith On Wed, 2003-07-23 at 01:32, Stephen March wrote: Have you considered using the console-tool, mysqldump? You could write a quick script ... say mysqldump -u adminuser -p adminpass --all-databases backup.sql tar -zcvf backup.tar.gz backup.sql mv backup.sql /somepath/backup.sql if you're on Winders, a batch file: mysqldump -u adminuser -p adminpass --all-databases backup.sql move backup.sql z:\somepath\backup.sql If you write a batch script, or shell script, all the new guy would have to do is run it. Create a cron job (on linux) or scheduled task (on windows) and the new guy just has to figure out the coffee machine :) Food for thought, ~Steve Brenton Dobell wrote: Hello all, I am developing an Intranet page for my workplace, ATM i use phpmyadmin to do rutine backups ect, this is cool but i am going on long service leave for 14 weeks and during that time a new guy will attempt to continue to maintain the site and perform regular backups... I tried to show him how to use phpmyadmin but has proved too dificult for him to understand, how can i make a quick script to implement into a page that prompts you to download the entire sctipt in .txt form?? just like php myadmin, and starting tips and hints would be great. Cheers in advance Brenton -- 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: ./configure stupidity
please please would you help me to get mysql - gd - iodbc (odbc) - mssql - apache I need to upgrade because i need the new one with iodbc support not unixODBC. and i need it with ofcourse ( mysql - gd - iodbc (odbc) - mssql - apache ) I have read so many articles all over the web, and i reffered to php.net ... MY PROBLEM is that i m new to linux and when it come to specify the DIR , i got lost... and when i make the ./configure , then make then make install ,, i got errors always .., i untared the file in /usr/local/src and after everything done , i echo phpinfo() and i got the version still there !!! I installed RedHat 7.3 ... the current php that came with redhat is perfectly working just i need to make mssql and iodbc work... so if there any other way please help me.. Please help me in details Cristian Marin [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I think it's very good as it is. ./configure actually is almost a standard for every compilation and is not ment to be used by a programmer but by a system admins. Linux is not Windows. If you really want to learn to compile a php create in a day or two a complete line with everything you ever think you need about php or compile them as modules, save the config line in a file and keep it on a CD. From version to version are very few changes to the ./configure options. -- - Cristian MARIN - Developer InterAKT Online (www.interakt.ro) Tel: +4021 312.53.12 Tel/Fax: +4021 312.51.91 [EMAIL PROTECTED] Nico Sabbi [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I wonder why at compile time ./configure doesn't automatically detect what features are compilable and what not, so as to build in php as much as possible. There isn't even such an option available, with the result that everytime I recompile PHP I end-up missing some group of functions that I didn't expect to need. Thanks, Nico -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP Warning: InterBase: I/O error for file File too large.
Hello, I have this configuration: kernel 2.3.20, apache 1.3.27, with php 4.2.3 as apxs module with firebirdCS-1.0.3-64IO I have problems with firebird database files which are 2GB. Till today everithing works good but, now one database file is then 2 GB and I have this error message in my log: [23-Jul-2003 22:54:02] PHP Warning: InterBase: I/O error for file /web/test.gdb Error while trying to open file File too large in /web/test.inc on line 38 in the script on line 38 is: ibase_pconnect(/web/test.gdb,$ibuser,$ibpassword,WIN1250,0,3) when I use this line ibase_pconnect(localhost:/web/test.gdb,$ibuser,$ibpassword,WIN1250,0,3) or connetct throug isql in shell. everything works good. (No error). But I want connect to my database direcly through php and libgds.so, and not via gds_inet_server on localhost. I trie to compile php module in several ways, check the versions of libs (libgds.so) but with no success. Can anybody send some suggestion to me? Honza Hubeny [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] change datatype in postgres
Thank´s Xaos, but I have a inocent question ¿why on earth can`t do with a simple alter table like other databases??? and, o.k drop the old column buy copy the data into a new one? how? with an update query? Thank´s again and sorry if bother =) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] change datatype in postgres
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Postgresql doesn't support altering the size or data type of a table field. Prolly the quickest way for you to fix this table is to create another table the way you want it, with the same fieldnames, but the size you wanted and do COPY old_tablename TO '/tmp/filename'; from psql, then do COPY new_tablename FROM '/tmp/filename'; On Wednesday 23 July 2003 19:23, Norma Ramirez - TECNOSOFT wrote: Thank´s Xaos, but I have a inocent question ¿why on earth can`t do with a simple alter table like other databases??? and, o.k drop the old column buy copy the data into a new one? how? with an update query? Thank´s again and sorry if bother =) - -- Death is merciful, for there is no return therefrom, but with him who has come back out of the nethermost chambers of night, haggard and knowing, peace rests nevermore - -Lovecraft -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQE/HzE/uJXVjPNiNE4RAleIAJ9IutPsH5GXt8vML53uHB4M2gU2zwCfbsCV TBd6mZwzJi6Z9ck/17FnDX0= =xne4 -END PGP SIGNATURE- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: ./configure stupidity
You may want to consider that RedHat 7.3 is quite out dated. If you just did your install recently I would firct recommend upgrading to RedHat 9. You might also want to consider debian instead. I'm a redhat fan but when it comes to keep packages up to date and providing advanced functionality in packages debian sure seems to beat the pants off of RedHat. But, sorry, that doesn't help your immediate problem. - Jeff On Thu, 2003-07-24 at 11:33, Nabil wrote: please please would you help me to get mysql - gd - iodbc (odbc) - mssql - apache I need to upgrade because i need the new one with iodbc support not unixODBC. and i need it with ofcourse ( mysql - gd - iodbc (odbc) - mssql - apache ) I have read so many articles all over the web, and i reffered to php.net ... MY PROBLEM is that i m new to linux and when it come to specify the DIR , i got lost... and when i make the ./configure , then make then make install ,, i got errors always .., i untared the file in /usr/local/src and after everything done , i echo phpinfo() and i got the version still there !!! I installed RedHat 7.3 ... the current php that came with redhat is perfectly working just i need to make mssql and iodbc work... so if there any other way please help me.. Please help me in details Cristian Marin [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I think it's very good as it is. ./configure actually is almost a standard for every compilation and is not ment to be used by a programmer but by a system admins. Linux is not Windows. If you really want to learn to compile a php create in a day or two a complete line with everything you ever think you need about php or compile them as modules, save the config line in a file and keep it on a CD. From version to version are very few changes to the ./configure options. -- - Cristian MARIN - Developer InterAKT Online (www.interakt.ro) Tel: +4021 312.53.12 Tel/Fax: +4021 312.51.91 [EMAIL PROTECTED] Nico Sabbi [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I wonder why at compile time ./configure doesn't automatically detect what features are compilable and what not, so as to build in php as much as possible. There isn't even such an option available, with the result that everytime I recompile PHP I end-up missing some group of functions that I didn't expect to need. Thanks, Nico -- Jeff Wiegley, PhDhttp://www.csun.edu/~jeffw Assistant Professor Computer Science Department EA1407 Engineering Addition California State University Northridge email [EMAIL PROTECTED] 18111 Nordhoff Street office phone 818.677.3887 Northridge CA 91330-8281CS Dept. phone 818.677.3398 USA signature.asc Description: This is a digitally signed message part