can you use a remote smtp server on a localhost?convert excel into mysql

phpjaco

hello

just curius can one make MIME mailers to be used on an intranet and then use a remote SMTP server to send mail with something like set_ini("smtp","someotherdomain");

the local server does not have a smtp server and therefore I need to sent mail through an external or rather remote server. is this possible?

and question 2: how do you convert excel into mysql? read somewhere that navicat is best? is this possible? what other options?

Thanks

raspberryh

Not sure about your first question, but as for the second - do you mean importing an excel file into your database? If so, save it as a CSV and then you can use fgetcsv() to read the csv file in as a 2-d array and go through the values and insert them where you want to.

phpjaco

my first question:

normally when I make websites they reside on a webserser hosted typically by a isp, they normally have their own smtp / pop servers installed.

so now im making an cms to be run on a small network run in an office and dont have my own smtp server, so can I use another smtp server to send my mail by settting the smtp server host (external smtp server set up elsewhere e.g isp etc.).

dotn know if this makes it any clearer, basically you use relaying and not the localhost, normally the mail function wont work unless you have a smtp server.

pjleonhardt

According to the man page for [man]mail[/man]
It looks like you're right in trying to do

set_ini("smtp", $host);
Have you tried it?

phpjaco

will try it soon.....

Rodney_H_

phpjaco wrote:
will try it soon.....

Hi, let me know if you get it to work, because I have been trying that too, and haven't had luck yet . . . :o

-THANKS!