[web] Ok, I have made a emailer using mysql/PHP whats next?

Started by
1 comment, last by deadimp 16 years, 11 months ago
I made my first newsletter script that emails users of new Blender 3d plugins here. I am using PHP and Mysql. What else should I try? I was thinking more like create a blog using PHP/Mysql, but I think thats a bit hard. Any sujestions?
Check out my open source code projects/libraries! My Homepage You may learn something.
Advertisement
Though that may just be too big of a step, it's really not a difficult process.

A blog requires a database to hold posts.

Table Name: Posts
The fields could be the date, the title of the post, the contents of the post, and perhaps a view count.

Build a front-end that displays the latest "post" and to the side displays the title of every post before it. Each time a post is viewed you should update the count field.

Build a backend that allows you to add a post to the database.

That's good practice. Point is, put it to use. You can do a lot of neat things. I personally devoted a section of my own website to my personal calendar/phone book/note field. You could start with things like that. A good book on PHP / MySSQL and web sites is: Core Web Application Development with PHP and MySQL.
Mark A. Drake
OnSlaught Games
Mark Drake
[General design process]
I would suggest a 'modular' approach, not meaning anything uselessly massive, but something that cuts down on repetition while still being easy to understand/maintain/manipulate/augment/etc, and so on. If you haven't looked into OOP in PHP, or OOP at all for that case, I would suggest it. Not meaning that you should use OOP in every part of your site -- heck no. But when it fits in place, it does so nicely [according to how you made it, of course]. Be sure you know your langauge, too, and how to simplify processes, et cetera.<br><br>If you have a general design process, then you can easily add a blog/forum/whatever you choose, or whatever you're able to do/find.<br><br>Not sure if it'll really help much, but here are some of the resources that I use:<br><a target="_blank" href="http://mozilla.com/">Mozilla Firefox</a> - Kinda obvious<br><a target="_blank" href="http://msdn.microsoft.com/">Microsft Software Developer Network</a><br><a target="_blank" href="http://www.apachefriends.org/en/index.html">Apache Friends: Home of XAMPP server</a> - Use it as my test server (so I can edit/view the files directly &#111;n my computer, etc)<br><a target="_blank" href="http://php.net/">PHP: Hypertext Processor</a><br><a target="_blank" href="http://pspad.com/">PSPad Freeware Editor</a><br><a target="_blank" href="http://mysql.com/">MySQL: Open source Database Framework</a><br><a target="_blank" href="http://webyog.com/">SQLyog: Open source MySQL GUI</a><br><a target="_blank" href="http://w3schools.com/">W3Schools &#79;nline Web Tutorials: HTML, CSS, and more</a><br><a target="_blank" href="http://csszengarden.com/">css Zen Garden: The Beauty in CSS Design</a><br><a target="_blank" href="http://alistapart.com/">A List Apart</a><br>Note that the MySQL link isn't to the developer zone, just the main site.<br>And as for the various tutorials (namely for PHP), there's always Google for that (and everything else).
Projects:> Thacmus - CMS (PHP 5, MySQL)Paused:> dgi> MegaMan X Crossfire

This topic is closed to new replies.

Advertisement