Mysql Mailing List Convert To Odbc For Access
im working on a modifying a mailing list that i found, that will allow me to send email to certain addresses located in a access database.
I dont get any error, but I am not receiving the email. i setup myself in the database, residing in a state that no one else is from, so i can test mail to myself. Code:
View Complete Forum Thread with Replies
Related Forum Messages:
From ODBC Convert To MYSQL
I can't find a DB area. I created a site in PHP using ODBC and now wish to convert to MYSQL. I extracted my MS DB as a .sql file and imported it into MYSQL. Does MYSQL use the likes of primary keys and relationships? If so, will the relationships i set in microsoft access be carried to MYSQL?
View Replies !
Mailing List Using MySQL / PHP
I have written a database which uses PHP to run through each ID in the database and then generate a persons name and address to include into the rest of the PHP to send an email out. But as people have deleted or updated their details on this mailing list, I now have "holes" in database. Ordinarily not a problem, but the code I've written starts at ID 1 and after sending an email increments to the next ID. But when it encounters a now vacant ID, it sends an error email to me associated with that now blank ID row of data. How can I change my code that will increment through all the results in turn, but not give me these error emails when people have amended the database?
View Replies !
Using A Program To Convert A Ms Access Db To Mysql.
I have a db I created in mysql using a program to convert a ms access db to mysql. The program worked fine from what I can see. What I want to do though is to create a form that will allow me to search this db for the following: Company (one table) position (one table linked to company) Country (one table linked to company) I extracted the db out of mysql using phpmyadmin. Now I am lost as to how to create the form. The file it created is attached however I cut some of the options out so the file would fit in this message.
View Replies !
Mailing List Manager, Send To List
I'm looking for a mailing list script (php) that has a function to let users to reach out to all recipient on the list by simple send the email to a specific maillist- address. Mailman has this functionn but as a just got a webserver account I can't use mailman nor install it.
View Replies !
Php Mailing List
Is it possible to implement a mailing list using PHP?. I know I could maintain a list of emails addresses in a db and send mail to them through my website, but how can I get true mailing list behaviour where emails are sent to a particular address (like mailinglist@mydomain.com) and then distributed to all of the email addresses?.
View Replies !
Mailing List
I am really interested in putting a mailing list on my website. I have only just discovered php and mysql and I found a program called php list on my cPanel X control panel on my website. I would like to put a text box on my navigation bar that has inside it "enter your e-mail" (when they click this disappears) and a button on the right of that which says "join" (I will have a jpg underneath this text box saying "Mailing List"). When someone clicks on "join" I would like them to get sent to a page with the e-mail address field filled out in the right table with what the address they entered in the navigation pane, along with a name field they can fill out and a Submit button. I have seen these on many websites so I assume it is not that hard to do, but I am pretty lost as to how everything is connected (the database (mysql?) and the php list program). I assume when they click submit it will send their details to a mysql database / send them a confirmation e-mail. I was wondering what code I will need to make this system work, as I have been reading and googling and I am quite lost as to the mechanics of how it all works.
View Replies !
How Do I Use For A Mailing List?
Im using PHP to allow people to sign up for my mailing list on my site. I have everything set up but for some reason when I click the submit button the information is not being sent to my email address. Im not very good with PHP I just took some online tutorials and tried to figure it out.
View Replies !
Mailing List.
i have created a mailing list system and it worked fine but what if the recipient replies to my return-path. how am i going to get all incoming mails?
View Replies !
PHP Mailing List Problem
Here's the problem: I've been trying to send to my mailing list using a PHP script, but the page that executes the send times out before the script can actually send to everyone on the list; only about the first half gets sent to.. Is there any possible way around this or to stop the browser from timing out?
View Replies !
Writing Mailing List In PHP?
what's the best way to write a simple mailing list program? If one tries to send email to over 600 addresses using mail(), a usual script will most likely timeout. So, the question is, what's the best way to sendout email to over 600 ppl?
View Replies !
Mailing List Manager
I am using a php mailing list manager that I found on devshed.com and it works great except for one little bug sending the mail which I have isolated in the following bit of code. <?php $message = "This is a test"; // mail function 1: does not work correctly $addresses = file("data/Test.lst"); mail($addresses[0], "Mailing List Test", $message, "From: Crisp Digital Branding <greg@crispdesigns.com>nReply-To: Crisp Digital Branding <greg@crispdigital.com>"); //mail function 2: WORKS correctly $email = "greg@crispdigital.com"; mail($email, "Mailing List Test", $message, "From: Crisp Digital Branding <greg@crispdesigns.com>nReply-To: Crisp Digital Branding <greg@crispdigital.com>");?> Both mail functions below send the mail correctly, but "mail function 1" does not properly send the subject, message, from:, etc. It is all dumped into the mail portion of the message. Mail function 2 works properly. The only difference between mail function "1 & 2" is that the send to email address is pulled from an array of data loaded from a external text file Vs mail function 2 which has a local variable .
View Replies !
Php Mailing List-> Performance
i wrote a php script that sends mail to a list of email generated from a database. this database contains about 8000 email adresses and depending on what the users chose in their preferences it sends out mail accordingly. in general this would come down to roughly 6000 emails per list. the script iterates through the list of email addresses and send out a new email to every email address found that fits the mailing type. the box doing this is an athlon 1400Mhz. now, my question, how heavy will this be for sendmail? i can imagine that this will take some time before all 6000 emails have been send. php is set in the ini to time out after 30 seconds and maybe this script will be running for longer than that with 6000 emails to send. i could test this but i dont think all of those people would be very happy receiving test emails. also, i could send just one mail with all those email addresses stuffed into the Bcc header but i dont know if that would make difference and if the php mail() function likes 6000 mail addresses in the Bcc header. anyone with experience with sending large volumes of mail like this have some advice for me?
View Replies !
Php Mailing List Operation
I'm using the mail() function to send out newsletters to subscribers, problem is that it seems a little unreliable... at the moment I assemble the mail outside a loop then iterate through all the mail addresses for($i=0;$i<$numaddresses;$i++){ mail($to[$i],$subj,$message,$fromstr); } should i be putting in a delay message or a retry_on_fail method or anything?
View Replies !
Subscription Mailing List
Im building my first php site and what im looking for is a simple tutuorial / example of a form which allows users to enter their email address, which is stored in my Mysql db. Also need to know how to go about mailing everyone who subscribes to my news letter. I know its probably quite simple, but i'd like to check for duplicate email addresses, verify email addresses (dont know if that possible) and allow them to un-subcribe.
View Replies !
Timeout Mailing List?
i heave a mailing list with just over 700 people on it. on page one i have a form for newsletter to be typed in, then the person submits the form and the next page has the php to send out the newsletter to all the email addresses in the database. my problem is that the page times out and an connection error occurs, so i don't think everyone in the list gets emailed. how do i get around this problem?
View Replies !
Dynamic Mailing List?
I have a schedule of people that need reminders sent to them weekly. I have figured out how to set a Crontab to send the reminder automatically ... but the people are not the same every week. I know that I could build multiple scripts and hard code the email addresses, setting a cron job for each - but is there any way to build ONE script that will read a text file based on the date and pull the names/email addresses off of that?
View Replies !
Making A Mailing List
I have tons of members on my website, and I want to e-mail them all, but I do not want add all their names to a address book or e-mail them individually. So I was wondering after I flush(Erase) the database, when the user register the "script" will auto adds them to a mailing list, so I can download the mailing list and add it to my address book and e-mail them all at once. If there is a script already out there, can I have it?
View Replies !
Mailing List Addition PHP
I have a website that I host for a few friends of mine to host their own blogs. I currently have a database of their user information (username, password, location, etc.) and the material of their blogs (blog titles, dates, entries, etc.). I want to add a simple mailing list feature for all my users by simply having a textbox visible on their blogs for people to type in their e-mails into to sign up. What is the easiest way to implement this to my site? Is there a simple way to store all the e-mail addresses for the mailing list in a MySQL database?
View Replies !
Join Mailing List
point me towards the most simple, reliable, freesource PHP based "join mailing list" script/app that stores the email address in database for later retrieval.
View Replies !
Mailing List Feature
I am offering users at my blog site the ability to enable a mailing list for their account. When doing so, they will be able to send mass e-mails to their subscribers, but I want to add a small footer sentence with text saying "If you would like to remove yourself from this mailing list, click here". How would I, right below their mail message (that they input in a text field), add this to the message? Here is my mail() code: PHP Code: mail($email_add, $subject, $message, "From: ".$email_address);
View Replies !
Mailing List Software
I recently sent out a mail shot to a number of members of a loyalty club. The trouble was that the script would sent a certain number of mails and then hang. It took me several tries to send all the mails. Can anyone recommend a method of extracting email addresses from a database and then sending a customised mail to each. The client needs to be able to compose an email, select a number of parameters (which will determine to whom the mail will be sent) and then press a button which will complete the process. I know I could create a text file of email addresses then use a commercial bulk emailer, but I'd rather like it to be a one shot process. This isn't for spam, people have elected to receive this information.
View Replies !
Php Script - Mailing List
I am working on a project for my schools Students Against Drunk Driving chapter and need to have a way to gather names and email addresses on the webpage and have them saved into a database. I would also like them to be directed to a page that has a ticket with their name on it for them to print out. I have made many pages in the past, I even run a forum on one of my sites. I have basic knowledge and am familiar with php (using pre made stuff, not actually writing it) and databases (SQL), however I've attempted to download some scripts and cannot get them to work. None of them have had very good instructions so I think i am forgetting something with all of these scripts. I have found a couple scripts on hotscripts and several just searching around on google.
View Replies !
Best Mailing List Manager
I must integrate an existing mailing list manager. We must send newsletters to registered users on our site and we are looking for various features: - send text and html emails - send in "to." every message instead of bcc ones - batch sending with wait list (if the server runs out of time, our ISP has 20 sec script limits) - being able to manage groups. - FREE ! It's there any such script. Wich ones are the best solutions?
View Replies !
Creating Mailing List
I am trying to create a mailing list script to further myself in php and open myself up to new functions I have never used. This being said, before I start I would like a few suggestions on maybe what to remember, watch out for, functions to use, or even a bit of easier script to create that will get me familiar with these same practises.
View Replies !
Start A Mailing List
I am really interested in putting a mailing list on my website. I have only just discovered php and mysql and I found a program called php list on my cPanel X control panel on my website. I would like to put a text box on my navigation bar that has inside it "enter your e-mail" (when they click this disappears) and a button on the right of that which says "join" (I will have a jpg underneath this text box saying "Mailing List"). When someone clicks on "join" I would like them to get sent to a page with the e-mail address field filled out in the right table with what the address they entered in the navigation pane, along with a name field they can fill out and a Submit button. I have seen these on many websites so I assume it is not that hard to do, but I am pretty lost as to how everything is connected (the database (mysql?) and the php list program). I assume when they click submit it will send their details to a mysql database / send them a confirmation e-mail. I was wondering what code I will need to make this system work, as I have been reading and googling and I am quite lost as to the mechanics of how it all works :( :( :confused:
View Replies !
PEAR Mailing List
I've been trying to sign up for the PEAR-General mailing list. I've tried twice now but each time it sends me the request email to which I have replied and then zilch. It's been over 2 weeks now and I've heard nothing from the list. Is anyone else on the list? And if so, how do I subscribe?
View Replies !
> Mailing List Script
I have some troubles with the hotmailusers of my mailing list. They don't seem to receive the activation e-mail. I was wondering how that's possible. The e-mail doesn't even show up at their unwanted e-mail or whatever it's called. I've tested it like this: I add an hotmail e-mail to the list and wait for the activation e-mail. Then I send an e-mail with a NOT hotmail e-mail to the hotmail e-mail.
View Replies !
Mailing List System
I create different mailing lists and assign an email address to every list. In this example mailing list nr. 1 gets mailinglist01@mydomain.com. The user sends an email to 'mailinglist01@mydomain.com'. My MTA sends this to a php script (or the script listens for new mail 'cause I don't know if mail piping is allowed by my hosting company). The PHP script will then look up the email address (mailinglist01) in a mysql database, searches for all subscribers to the mailing list and forwards the mail to each one. Now I've been looking on the net for methods and the IMAP functions of PHP so far do the job for plain text mails. Ofcourse I would like the user to be able to send any kind of email (HTML mails with attachments for instance) and the email should stay intact, as if it was sent directly from the user. Is there a script that does this? Or what would be the best approach? My main reason is because I would like it to be as easy as possible for the user. Because the user is used to his own mail client and providing a web based system doesn't guarantee nice output. I'd have to deal with upload issues, copy/paste from word, user's limited HTML skills.
View Replies !
Mailing List And Newsletter
1) How does a mailing list work? storing email IDs of visitors / users, handling these of multiple mailing lists, storing these email IDs in database. For what purpose these mailing lists are used. Any specific method of handling large count of email IDs? 2) In what way newsletter is associated with mailing list? How to enter and handle the contents of each newsletter? ********* Are there any reference sample codes available?
View Replies !
Mailing List Bounces
Does anyone know of a PHP script that can scan the contents of a POP mail box and produce a list of soft and hard email bounces? If not then is there any software you would recommend? I've found software that claims it can do this but it's always good to get a recommendation.
View Replies !
Integrated Mailing List
I have this user managment script installed on my site called the AR Memberscript. I just wanted to know is it possible to have a mailing list integrated with the member script so that a member can click like a "Join Mailing List" button and all the emails from the members can be stored in a file or soemthing like that.
View Replies !
PHP To MS Access Via ODBC
Newbie here and relative newbie to PHP. Mentioned this on on a totally different forum so sorry if you get this twice. I'm trying to use php to write to an access db and haven't had any luck. Surfed the archives and tried the examples for insert into via odbc from phpbuilder but it never writes the data to the db. The forms draw up properly and when I hit the submit button it goes to the page that is supposed to run the code to write to a db but it doesn't save. Created a system dsn via the examples as well. Have Apache and php 5 installed on my machine. Does anyone have examples of insert into from PHP to Access? I know SQL Server is more stable but they've already been waiting forever before I took the job and the project is already build in Access. Plus this is for a low hit/ low volume survey type thing. I don't get any error messages. It just doesn't store the data.
View Replies !
PHP & ODBC & MS Access
Can anybody link me to some good tutorials regarding using php to extract and retrive data etc from ms access please? I've followed the tutorial about retrieving data and setting up OBDC on this site and it was very helpful although i'd like to expand my knowledge. My next task would be to learn how to add data from a web form into ms access using php. If there aren't any good tutorials perhaps someone knows a good example they could post here?
View Replies !
Access DB Using ODBC
What would be the correct code to use if I'm trying to access an Access DB that is in the same directory as my PHP script? The Following: Code: $connection = odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ='E:usersladams02coursescosc345 tsdata.mdb'", "USER", "PASS"); $sql = "select * from pokerTTS"; $res = odbc_exec($connection, $sql); Returns: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x834 Thread 0x854 DBC 0xc529e4 Jet'., SQL state S1000 in SQLConnect in e:usersladams02coursescosc345 ts tsOutput.php on line 194 among several other errors. Any ideas?
View Replies !
Key Code Generation For Mailing List
I want to send a unique url to each member of my mailing list for mailing list removal purposes. I see this done all the time, but I'm not sure how they do it. I want the user to click on the link at the bottom of their email, which takes them to a page where they confirm there removal from the list. It doen't have to be super secure, its just a personal site, I just don't want idiots going in and guessing random addressess trying to get them removed from the list.
View Replies !
Remove From Mailing List Via Variables In URL
i have often joined other mailing lists and i notice that when emails are sent out there is usually an option to delete your email from the mailing list. i was wondering which is the best way to go about this. would it be a matter of sending a link in the email which is something like... http://wwwmysite.com/deletemail.php?somebody@somewhere.com deletemail.php being a simple script that takes that email addy and deletes it from the database? or is there a better way to do it?
View Replies !
Create A Mailing List For My Website
I want to create a mailing list for my website but i have never done this before, I searched on google and all i found was free mailing lists but when a user subscribes, it takes them to the website that provides the free mailing list and it has an ad for them when i send out an email, can anyone help me create my own mailing list?
View Replies !
Send Emails Out To A Mailing List.
i want to send emails out to a mailing list. its takes 2 emails (right now, probably 50 when im done) from the database and sends out and email. then it submits a hidden form to the same page after it sends two emails. it then grabs the next 2 and sends those out. it does this till all emails are sent out. so basically it sends 2 emails, submits hidden form back to the same page, then send 2 more emails out. it does this till all emails are sent. my problem is that while the script is executing none of the html is output and visible in the browser until the $mailer>send() is done. and when it appears it only appears for 1 sec then disappears.
View Replies !
Announcement Mailing List Tool
I am on the search for a php solution for an "announcement email list." Does anyone know of any simple php solutions out there? I need to put something together for a client of mine, unfortunately his webspace provider doesn't have a plan with mailing list, so we're on our own. (he's stuck with the provider for another few months...)
View Replies !
Mailing List / Server Problems...
I'm having trouble with a mailing list program im using on my server... or rather the server itself. The mailing list was working fine a while ago, but now none of the emails are being sent to their destination. This is not a problem with the mailer system because nothing has changed and it did used to work. So.. I got in touch with texh support on my server and they said: "it has to be set tO a VALID POP email address on this DOMAIN NAME, that is NOT setup as a forwarder." Can anyone explain to me what this means? The mail() function does work when I send to the servers email i.e. username@st.server20063.net . but not to any other address. Alternativly, If I can't get this working again, can anyone recommend a cheap host/server where I can just host the mailing system?
View Replies !
Send Mailing List Email
I'm writing a simple mailing list program, and I would like to know what the suggested method of sending a large number of emails to a list of addresses. It's perfectly legit, it's just an opt-in mailing. I have a feeling that using a 'while' loop with repeated calls to mail() is not the best practice. Is there something better I should be doing.
View Replies !
Using An Access Db From Php On Linux? Odbc?
I have my site running on a linux server, and I want to pull data from an access db on a windows server. I have ODBC set up under linux, and can connect to the mssql server that way, is there a free linux odbc driver for access?
View Replies !
Select 'Like' ODBC / MS Access
I am trying to do a select 'LIKE' statement but I am not returning any results, here is what I am trying: $get = "SELECT item FROM table WHERE item LIKE 'D123-78*'"; $ex = odbc_exec($conn, $get); But in access there are several items: D123-78-567 D123-78-432 D123-78-113
View Replies !
Duplicate Mail When I Send A Mailing-list
I use mysql and the function mall to send a mailing-list. When I execute my script, certain person receives two or more identical messages. I think that the problem is in the server smtp which does not manage to send all the messages at the same time.
View Replies !
Adding A Mailing List To Vbulletin Registration
I have added yes and no buttons to an option called bsmailinglist in the form for registration on my forums. Now I want to have that answer handled according to the following code. I have the yes button set to TRUE and the no button set to FALSE. After adding the folloing code to the script that handles the form (register.php), I get a parse error on the last line of php, the closing php flag. Code: function BSwrite ($email) { $BSfile = "bsmailinglist.txt"; $BSopen = fopen ($BSfile, "a"); if ($BSopen) { fwrite ($BSopen, "$bsmailinglist, "); fclose ($BSopen); } // end BSwrite Function if ($bsmailinglist) { BSwrite(); }
View Replies !
Is It Very Difficult To Setup A Simple Mailing List?
I've seen and been on mailing lists where there are a bunch of people on it, but, when you reply to "the list" you are actually replying to something like, "mailinglist@widgets.com". So I want to setup something like this for a special project. I'm imagining that when the server gets an email to "mailinglist" that it would basically just re-send the message to everyone on the list. Is this very difficult or even advisable using PHP's mail function?
View Replies !
|
TRACKER
