Member Avatar for drameshgar1

hy!
I am designing a website, i want to ask few questions: to design my website i am going to use Dreamweaver.
1. i want to add feature where newsletters get emailed to customers automatically every month.
2. also i want to add feature where users can search products on search bar and the search will only display things which is in stock else the search engine will print message saying "goods not found".

and yes i dont no much about mySQL, PHP, CSS and as a team project I have to know them so is their any good website that teach people in short time the fundamental of all these features. I also have to make database about people which has to be connected to Dreamweaver where users can create more than one account from same address but not create account using same usersname. For that we have to use database (1-2 many relationship, 1-1 relationship etc...) and i dont no how to design that type of database...So any recommendation or good resources will help a lot....

Thank you for reading and answering :)

  • 6 Contributors
  • 5 Replies
  • 257 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by codewalkz

Dani AI

Generated

Practical, hands-on plan to get each piece working and safe (short, copy-ready examples; expands on points from , , and the security warnings from / ).

Start with the data model (one address record can back many accounts; usernames must be unique). Example minimal schema:

CREATE TABLE addresses (
  id INT AUTO_INCREMENT PRIMARY KEY,
  street VARCHAR(255), city VARCHAR(100), state VARCHAR(50), zip VARCHAR(20)
);

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(60) NOT NULL UNIQUE,
  password_hash VARCHAR(255) NOT NULL,
  email VARCHAR(255),
  address_id INT,
  FOREIGN KEY (address_id) REFERENCES addresses(id)
);

Search that shows only in-stock items: always filter by stock > 0 and use prepared statements (prevents SQL injection). For small sites LIKE is ok; for larger catalogs add full-text indexes.

$stmt = $pdo->prepare(
  "SELECT id, name, price FROM products
   WHERE stock > 0 AND (name LIKE :q OR description LIKE :q) LIMIT 50"
);
$stmt->execute([':q' => "%$query%"]);
$rows = $stmt->fetchAll();

Newsletters: keep subscribers and a cron-driven sender. Track unsubscribe tokens and last_sent dates.

CREATE TABLE subscribers (
  id INT AUTO_INCREMENT PRIMARY KEY,
  email VARCHAR(255) UNIQUE,
  unsub_token CHAR(32),
  last_sent DATE
);

# cron (monthly, 1st day):
0 0 1 * * /usr/bin/php /path/to/send_newsletters.php

Security & workflow notes (non-negotiable): never store plain passwords (use PHP password_hash), always use prepared statements/parameterized queries, escape output for HTML, include CSRF protection for forms, rate-limit signup/email actions, and provide a safe unsubscribe flow. Develop and test locally with a stack like XAMPP/WAMP/MAMP and phpMyAdmin (as hinted) before deploying.

Learning path: pair short video courses (fast grounding) with the official PHP docs and MDN for HTML/CSS; practice by building small features (register/login, product search, send-test-email). Follow the security items above — that is what was warning about.

Recommended Answers

All 5 Replies

Member Avatar for Macko888

if you have about $25 a month, then i recommend joining www.lynda.com

They have good video tutorials ranging from basics to advanced.

Member Avatar for louie540

Are you using phpmyadmin and do you already have a web server set up on your computer? What company are you using to host your site?

Edited by louie540 because: n/a
Member Avatar for lps

MY recommendation is that you can refer the functions, database and others in php.net. It got a huge number of php API listed. Meanwhile, you can try out your CSS using w3school.

Member Avatar for Member #905211

Please, if this is a business site that is supposed to be professional, don't just learn something over the next few weeks and slap something together. If you don't know how to do it, hire a professional.

You are going to have huge gaping security holes all over the place. This is not stuff that you can learn how to do properly over a few weeks of watching videos. If you have any respect for your users, do it properly, put in the time it takes to learn this stuff properly (3 years of experience, minumum, probably more with CSS, database design, SQL, PHP, JavaScript), or hire someone.

Member Avatar for codewalkz

Please, if this is a business site that is supposed to be professional, don't just learn something over the next few weeks and slap something together. If you don't know how to do it, hire a professional.

You are going to have huge gaping security holes all over the place. This is not stuff that you can learn how to do properly over a few weeks of watching videos. If you have any respect for your users, do it properly, put in the time it takes to learn this stuff properly (3 years of experience, minumum, probably more with CSS, database design, SQL, PHP, JavaScript), or hire someone.

AGREE:$

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.