Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
PHP and MySQL Web Development - P132: PHP and MySQL Web Development teaches the reader to develop dynamic, secure, commercial Web sites. Using the same accessible, popular teaching style of the first edition, this best-selling book has been updated to reflect the rapidly changing landscape of MySQL and PHP. | Script Architecture 627 Remember that you can execute this SQL by typing mysql -u root -p create_database.sql You will need to supply your root password. You could of course execute this script via any MySQL user with the appropriate privileges we have just used root here for simplicity. You should change the password for the mlm user and the administrator in your script before running it. Some of the fields in this database require a little further explanation so let s briefly run through them. The lists table contains a listid and listname. It also contains a blurb which is a description of what the list is about. The subscribers table contains email addresses email and names realname of the subscribers. It also stores their password and a flag admin to indicate whether or not this user is an administrator.We will also store the type of mail they prefer to receive in mimetype.This can be either H for HTML or T for text. The sublists table contains email addresses email from the subscribers table and listids from the lists table. The mail table contains information about each email message that is sent through the system. It stores a unique id mailid the address the mail is sent from email the subject line of the email subject and the listid of the list it has been sent to or will be sent to. The actual text or HTML of the message could be a large file so we will store the archive of the actual messages outside the database.We will also track some general status information whether the message has been sent status when it was sent sent and a timestamp to show when this record was last modified modified . Finally we use the images table to track any images associated with HTML messages. Again these images can be large so we will store them outside the database for efficiency. Instead we will track the mailid they are associated with the path to the location where the image is actually stored and the MIME type of the image mimetype for example image gif. The SQL .
