Member Avatar for ankit1122

how could i send email to list of email addresses inside a mysql database??

i want to create a site helping students find home tuitions.

when students fill form regarding subjects they want tuitions ,concerning teachers should get e-mail..tell how can i do this??

  • 3 Contributors
  • 5 Replies
  • 412 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Banderson

Dani AI

Generated

Short plan for : don’t fire mail directly from the web request or rely on a personal Gmail account for production. Capture the student form, match tutors in MySQL, then enqueue one email job per recipient and let a background worker send them in controlled batches. Gmail/Workspace enforces strict daily and per-message limits, so it’s not a reliable bulk/automation channel. See Google’s sending limits for details. ()

Suggested architecture (practical and safe): when a student submits, perform a parameterized query to find matching tutors and insert a row per tutor into an email queue table. Run a cron/worker that picks a small batch (configurable), calls your ESP’s API or SMTP, records the provider message ID, and marks success/failure. Retry with exponential backoff on transient errors and mark hard bounces/failed addresses for suppression. Providers support APIs or SMTP and often require domain verification and sandbox/quotas—read the provider docs before scaling. Example minimal queue schema:

CREATE TABLE email_queue (
  id INT AUTO_INCREMENT PRIMARY KEY,
  to_email VARCHAR(255) NOT NULL,
  template VARCHAR(100),
  payload TEXT,
  status ENUM('queued','sending','sent','bounced','failed') DEFAULT 'queued',
  attempts INT DEFAULT 0,
  next_try DATETIME,
  provider_msg_id VARCHAR(255),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Design the worker to select WHERE status='queued' AND next_try <= NOW() ORDER BY created_at LIMIT N, then update rows to sending to avoid duplicates. Use a transactional email provider (SES, SendGrid, Postmark, etc.) rather than a free mailbox for production; they document API/SMTP usage, quotas, and send best practices. (docs.aws.amazon.com)

Deliverability & compliance (critical): authenticate your domain with SPF/DKIM (and consider DMARC), honor unsubscribe requests, and process bounces/complaints automatically (providers give webhooks or notification integrations). Follow legal rules for commercial messages (CAN‑SPAM in the U.S.) and keep your lists clean—remove hard bounces and persistent non‑responders. See Mailgun’s domain verification notes and the FTC CAN‑SPAM guide for the legal checklist. (help.mailgun.com)

Notes tied to the thread: ’s pointer toward a library is useful for implementation; ’s advice to throttle/queue is exactly the right operational approach—implement the queue/worker pattern and use an ESP to handle deliverability.

Recommended Answers

All 5 Replies

Member Avatar for ankit1122

hello sir,

what are the free solutions for sending e-mails through smtp..

can i get a smtp serevr for free ??

or any other free non-smtp method ??

Member Avatar for Banderson

Yes there are several free alternatives for SMTP and PHP.

If your server has PEAR installed you could use that. You can also use GMail or SwiftMailer to send email. The solution that urtrivedi has given you is a free solution, but here are a couple more links below.

pear.php.net Click Here
swiftmailer Click Here

Edited by Banderson
Member Avatar for ankit1122

dear sir,

gmail smtp blocks after sending some emails .gmail smtp is not a permanent solution..

Member Avatar for Banderson

If this is happening to you input your information into your code instead of GMail ports, host and your credentials. Check with your host. Almost all servers have SMTP installed. If your host offers email solutions from your website then they more than likely have SMTP servers installed. If your looking for totaly free solution then you could use localhost by installing SMTP on localhost and editing your PHP ini file to reflect the correct info. (ie: username, password, port, and host)

Also if your sending multiple emails from your database at one time then it may be getting caught in GMail's spam filters. One way to avoid this is to send the emails using threads. That way you can set timers to send the emails over a period of time instead of all at once.

Edited by Banderson
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.