[PHP-DB] Acessing a excel worksheet from a php site
I'm making a site to a company and they have a excel worksheet where i have to get the data to a site in php. My question is simple, i think, how can i get it? Cumprimentos Bruno Pereira DSI [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] mysql to cvs file to excel
I had the some problem and someone told me this What is your problem exactly? Have you investigated the MySQL manual under: LOAD DATA INFILE SELECT ... INTO OUTFILE ? And it realy helped. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: Snijders, Mark [mailto:[EMAIL PROTECTED]] Sent: sexta-feira, 21 de Fevereiro de 2003 9:59 To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql to cvs file to excel hello, does anybody know if it's possible (without php) to export data from mysql to a cvs file, so i can import it in excel??? so is it possible, and if yes.. how? thanks kinds regards, Mark Snijders -- 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] TimeStamp format to date
Good afternoon, Houston i have a problem. :-) Just to play a while. Is like this i have a field in MySql TIME_STAMP int(11) and he has a time stamp value (ex: 1045738710) and i want to make show it like a date format in the web. Can anyone help me on this...? Cumprimentos Bruno Pereira [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] TimeStamp format to date
I'm portuguese, so i say bye in portuguese. If i want to call something you can be jure of one thing it wouldnt be cumprimentos. But i wouldnt do that, cause you help me :-) Cumprimentos(Till next time), is the same. Bruno Pereira [EMAIL PROTECTED] -Original Message- From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 20 de Fevereiro de 2003 15:37 To: Bruno Pereira; [EMAIL PROTECTED] Subject: Re: [PHP-DB] TimeStamp format to date Is like this i have a field in MySql TIME_STAMP int(11) and he has a time stamp value (ex: 1045738710) and i want to make show it like a date format in the web. Can anyone help me on this...? Just SELECT it out and run it through the PHP date() function to format it. www.php.net/date Cumprimentos What'd you call me? ---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] TimeStamp format to date
It's very good to see that a simple word cumprimentos can make a great discussion. :-) Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 20 de Fevereiro de 2003 17:09 To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] TimeStamp format to date Dude, you just topped John! That was laugh-out-loud hilarious. Sorry this has gotten off-topic, but c'mon. A freshmaker? Classic, just classic. Rich -Original Message- From: Mark [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 12:09 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] TimeStamp format to date --- 1LT John W. Holmes [EMAIL PROTECTED] wrote: Cumprimentos What'd you call me? I think he's offering you a free minty freshmaker. = Mark Weinstock [EMAIL PROTECTED] *** You can't demand something as a right unless you are willing to fight to death to defend everyone else's right to the same thing. *** __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Erro na passagem de parametros
1º em portugues Boa tarde, Não consigo passar os valores de uma form para um ficheiro em php, em vex de mostrar só o valor da variavel, mostra o proprio código, penso que seja uma configuração no httpd.conf, mas não sei qual? Obrigado Then in english I can´t pass values from a form in html to a php file. It should just show the value from the var but it is showing the interied code php. I think if some kind configuration of the httpd.conf file, but i dont no where? Thanks Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: Dimas Alberto Ayala Escobar [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 17 de Fevereiro de 2003 16:31 To: [EMAIL PROTECTED] Subject: [PHP-DB] Suscribirse Espero poder suscribirme a su lista. Como lo hago. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Erro na passagem de parametros
ERRO meu, my mistake 1º em portugues Boa tarde, Não consigo passar os valores de uma form para um ficheiro em php, em vex de mostrar só o valor da variavel, mostra o proprio código, penso que seja uma configuração no httpd.conf, mas não sei qual? Obrigado Then in english I can´t pass values from a form in html to a php file. It should just show the value from the var but it is showing the interied code php. I think if some kind configuration of the httpd.conf file, but i dont no where? Thanks Cumprimentos Bruno Pereira [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] HELP, sendmail + mysql.
Hi, need some help. i will try to explain my self. I have a sendmail in GNU/linux, and a radiator GNU/Linux with Mysql. I have to give a diferente user for de dialup login and the sendmail, cause i can't or i dont know a way to change the user and pass for the user in the two servers. Like this, the user to make a dialup conection has a user and a pass and for the sendmail has another, and, if there is any changes, when the user changes de user or pass from one can't at the same time change the user/pass from the other. can someone help me Cumprimentos Bruno Pereira [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] login script
Hi, need some help. i will try to explain my self. I have a sendmail in GNU/linux, and a radiator GNU/Linux with Mysql. I have to give a diferente user for de dialup login and the sendmail, cause i can't or i dont know a way to change the user and pass for the user in the two servers. Like this, the user to make a dialup conection has a user and a pass and for the sendmail has another, and, if there is any changes, when the user changes de user or pass from one can't at the same time change the user/pass from the other. can someone help me Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]] Sent: sexta-feira, 31 de Janeiro de 2003 17:52 To: Matt; [EMAIL PROTECTED] Subject: RE: [PHP-DB] login script try: http://www.hotscripts.com/PHP/Scripts_and_Programs/User_Authentication/ there are loads of pre done scripts you can reference. Cheers Jason -Original Message- From: Matt [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 11:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] login script Anyone have any suggestions on how to go about creating a solid login script? I have a MySQL database with a field called LoggedIn that is by default NO but I want it to turn to YES when the user logs in, and I want it to turn back to NO when the user either logs out, or a certain amount of time goes by and they timeout. I was just wondering if anyone had any suggestions for me on how to go about this process. Thanks a lot. Matt -- 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] login script
Hi, is like this, i will try to explain my self. I have a sendmail in GNU/linux, and a radiator GNU/Linux with Mysql. I have to give a diferente user for de dialup login and the sendmail, cause i can't or i dont know a way to change the user and pass for the user in the two servers. Like this, the user to make a dialup conection has a user and a pass and for the sendmail has another, and, if there is any changes, when the user changes de user or pass from one can't at the same time change the user/pass from the other. can someone help me Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]] Sent: sexta-feira, 31 de Janeiro de 2003 17:52 To: Matt; [EMAIL PROTECTED] Subject: RE: [PHP-DB] login script try: http://www.hotscripts.com/PHP/Scripts_and_Programs/User_Authentication/ there are loads of pre done scripts you can reference. Cheers Jason -Original Message- From: Matt [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 11:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] login script Anyone have any suggestions on how to go about creating a solid login script? I have a MySQL database with a field called LoggedIn that is by default NO but I want it to turn to YES when the user logs in, and I want it to turn back to NO when the user either logs out, or a certain amount of time goes by and they timeout. I was just wondering if anyone had any suggestions for me on how to go about this process. Thanks a lot. Matt -- 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
RE: [PHP-DB] simple mail attachment with php?
Try that, is very good, i have the same problem and someone send me that, try it. I hope is the right one. Thats just a class, but inside there is the instruction. I put it to work and is very good. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: cornelia es said [mailto:[EMAIL PROTECTED]] Sent: sexta-feira, 24 de Janeiro de 2003 18:56 To: [EMAIL PROTECTED] Subject: [PHP-DB] simple mail attachment with php? hi you out there... i hope you're all fine :) has anybody an idea how to attach a simple text-file to the php mail()-function??? the scripts i found on the net are quite complicated, featuring different mime-types, more than one attachment,... i really would need just the absolute basic functionality to send just ONE attachment as .txt-file. (i think this would also be the best way for me to understand the concept ;) THANKS A LOT in advance and have a very nice weekend :) cornelia cornelia es said spacedealeragentur für online media GmbH internet marketing consulting [Strasse] paul lincke ufer 42_43 [Ort] Berlin 10999 [Fon] + 49_030 69 53 50 16[Fax] +49_030 69 53 50 77 [www.] spacedealer.de -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] simple mail attachment with php?
No, you didn't get it? But cornelia es said, just told me that i have mistaken and put an ftp clss, my mistake. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: Matthew Moldvan [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 27 de Janeiro de 2003 17:21 To: 'Bruno Pereira'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] simple mail attachment with php? Did you forget to attach the class? Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc Work: (313) 593-7993 x 116 Cell: (734) 658-0997 http://www.trilogyintl.com/ecommerce/ --- -Original Message- From: Bruno Pereira [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 6:04 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] simple mail attachment with php? Try that, is very good, i have the same problem and someone send me that, try it. I hope is the right one. Thats just a class, but inside there is the instruction. I put it to work and is very good. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: cornelia es said [mailto:[EMAIL PROTECTED]] Sent: sexta-feira, 24 de Janeiro de 2003 18:56 To: [EMAIL PROTECTED] Subject: [PHP-DB] simple mail attachment with php? hi you out there... i hope you're all fine :) has anybody an idea how to attach a simple text-file to the php mail()-function??? the scripts i found on the net are quite complicated, featuring different mime-types, more than one attachment,... i really would need just the absolute basic functionality to send just ONE attachment as .txt-file. (i think this would also be the best way for me to understand the concept ;) THANKS A LOT in advance and have a very nice weekend :) cornelia cornelia es said spacedealeragentur für online media GmbH internet marketing consulting [Strasse] paul lincke ufer 42_43 [Ort] Berlin 10999 [Fon] + 49_030 69 53 50 16[Fax] +49_030 69 53 50 77 [www.] spacedealer.de -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP MySQL: temporary table problem
I would like to know, if there is any change to export/import data from SQL/EXCEL/SQL with php??? It?s very important. So if someone knows a way please help me. Thanks. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: Damir Dezeljin [mailto:[EMAIL PROTECTED]] Sent: sexta-feira, 24 de Janeiro de 2003 8:18 To: PHP-db list Subject: [PHP-DB] PHP MySQL: temporary table problem Hi. I got a task to program a search engine for a site which is all around based on sessions and persistent connections to MySQL. The problem is that I first have to select a subset of those data and then I have to join them all around and output results. I'm using temporary tables for this but there is a problem. Temporary tables are visible trough the entire connection. So in future one browser window can interact (can display) with results from another browser window. Does anyone have a sugestion how to solve this? I was thinking to close a persistent connection (I don't know how???) on each result page at the begining and then reopen it at the end ... for my code I was thinking on using normal connections. Any better idea? I thik I just can't live without temporary tables till I will not have subqueryes. Regards, Dezo -- 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] Import and export data from php/mysql
I would like to know, if there is any change to export/import data from MySQL/EXCEL/MySQL with php??? It's very important. So if someone knows a way please help me. Thanks. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] elseif with header
I Larry is correct you havo to use (==) not (=). The first one is comparing two variables and the second is that var is equal to another var. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: Larry E. Ullman [mailto:[EMAIL PROTECTED]] Sent: terca-feira, 21 de Janeiro de 2003 0:29 To: Addison Ellis Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] elseif with header if ($category = 2 and $subcategory = 52) { header(Location: http://www.vanderbilt.edu/register/ca/vacation_rentals.php;); } elseif ($category = 2 and $subcategory = 50) { header(Location: http://www.vanderbilt.edu/register/ca/rentals.php;); } , etc. for some reason all the elseifs are going to the if header. any input as to how i can correct this is greatly appreciated. You are using the assignment operator (=) instead of the equals comparison operator (==) which makes your if condition always true. Larry -- 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] Send mail with a file
How can i insert a file on a mail, with the command mail()? It is possible? Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: Bruno Pereira [mailto:[EMAIL PROTECTED]] Sent: quarta-feira, 15 de Janeiro de 2003 14:48 Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Concatenate two strings How can i join two strings. My code is something like: $valor1=bruno; $valor2=Pereira; $valor=$valor1 + + $valor2 Can someone help me. Thanks. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Concatenate two strings
How can i join two strings. My code is something like: $valor1=bruno; $valor2=Pereira; $valor=$valor1 + + $valor2 Can someone help me. Thanks. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php