The tutorials are fine if you want something quick (and possibly dirty!). You'll probably benefit more from buying a book on "php5 and MySQL 5". There are loads of good books out there, but an unbelievably large number of poor online tutorials. Books are usually peer-reviewed, but any idiot (including myself) can write a tutorial and post it online.
In my experience, books are essential for the "basics", whereas online resources tend to be good for "quirky" or "experimental/cutting-edge" stuff - but only if you know what's going on.
I'd suggest learning the basics before jumping in with both feet and incorporating free online scripts. Being a "script bunny" will end in tears - your SQL statements will be full of security holes and your php will be pure spaghetti.
O'Reilly usually have good resources as well as Wrox (think they've died recently?). Although a boring subject, security is an essential aspect of learning the basics - XSS/sql injections etc. You won't believe how many tutorials I've read or scripts I've seen that don't pay the slightest attention to security.
BTW: Atli is right, as far as it goes, W3Schools is a decent resource.
Happy hunting.
diafol
Rhod Gilbert Fan (ardav)
7,792 posts since Oct 2006
Reputation Points: 1,170
Solved Threads: 1,080
diafol
Rhod Gilbert Fan (ardav)
7,792 posts since Oct 2006
Reputation Points: 1,170
Solved Threads: 1,080
Dear ardav, i asked bcoz i want to start designing my own CMS in PHP, that's why i was wondering what does it need to start designing my own CMS.
regardz
Ah, I see. In order to make a good CMS, get a good wysiwyg editor (or write your own - not for the faint-hearted!). Spaw2, Yahoo, TinyMCE, FCKeditor etc etc. These have a good solid user base with good support. Your DB design will be the key area for your development. You'll need to identify your static elements from your variable ones and ensure that they are placed in separate tables (unless using templates).
diafol
Rhod Gilbert Fan (ardav)
7,792 posts since Oct 2006
Reputation Points: 1,170
Solved Threads: 1,080
Sorry - that was a bit cryptic.
Your main html sections will probably be "static", e.g. navbars, sidebars, footers, banners etc etc
If you want to give total control - you'll probably need to created 'template' files to hold the various 'static' elements. You don't need a templating system - you can create your own. The following example is just that - not to be taken too seriously - just one way. There are far better ways of doing things I'm sure.
In /templates/main.php
<?php
include("{$_SERVER['DOCUMENT_ROOT']}/includes/config.php");
include("{$_SERVER['DOCUMENT_ROOT']}/includes/functions.php");
include("{$_SERVER['DOCUMENT_ROOT']}/includes/dtd.php");
include("{$_SERVER['DOCUMENT_ROOT']}/includes/head_n_body.php");
include("{$_SERVER['DOCUMENT_ROOT']}/includes/bannerarea.php");
include("{$_SERVER['DOCUMENT_ROOT']}/includes/nav.php");
include("{$_SERVER['DOCUMENT_ROOT']}/includes/side.php");
include("{$_SERVER['DOCUMENT_ROOT']}/includes/main_content.php");
include("{$_SERVER['DOCUMENT_ROOT']}/includes/footer_n_end.php");
?>
Then in your actual displayed page, you could have something like:
<?php
include("{$_SERVER['DOCUMENT_ROOT']}/templates/main.php");
?>
And that's it. The static content (structural html and the odd piece of static text/logos etc) can be drawn from the individual include files AND/OR from a DB, which is handled by the include files.
The dynamic data from the DB can be placed into placeholder variables within the include files.
<?php
$navlist = getNavItems($_SERVER['PHP_SELF']);
//there are better ways of doing this - the function could spit out parsed html containing the navlist (from the DB) pertaining to that page
?>
<ul id="nav">
<?php echo $navlist;?>
</ul>
diafol
Rhod Gilbert Fan (ardav)
7,792 posts since Oct 2006
Reputation Points: 1,170
Solved Threads: 1,080
depends how deep you want to go.
A simple solution would be to login and use a $_SESSION variable to store the verified details.
Each page will have:
<?php
include('includes/login.php');
?>
The login.php file could have something like this:
if(isset($_SESSION['username'])){
echo "<p>{$_SESSION['username']} logged in <a href='logout.php' title='log out from site'>[logout]</a></p>";
}else{
?>
<form action="includes/authenticate.php" method="post">
<label for="username">Username:</label>
<input type="text" name="username" id="username" />
<label for="pw">Username:</label>
<input type="password" name="pw" id="pw" />
<?php
if(isset($_SESSION['login_error'])){
echo "<p class='beware'>Username and/or password not correct</p>";
}
?>
<input type="submit" name="login" id="login" value="Login" />
</form>
<?php
}
?>
The above is a very simple login form / logout link display based on $_SESSION variables. The authentication.php page accepts the data from the form and uses this (via $_POST variables) to check against users in the DB. If OK, set the session variables and kill the $_SESSION['login_error'] variable if set. If not OK, set the $_SESSION['login_error'] = 1.
Then return the user to the referring page with the header() command.
Please read up on php/mysql security BEFORE going live with an authentication script. Data validation/verification/sanitizing are essential.
diafol
Rhod Gilbert Fan (ardav)
7,792 posts since Oct 2006
Reputation Points: 1,170
Solved Threads: 1,080
It's better if you use ready classes... try: phpclasses.org
Easier, not necessarily better. Learning should be an active experience, rather than passive. If we take the 'classes is better' stance, we'd use Wordpress or similar. Of course some elements of app building will have to rely on ready-made scripts, e.g. wysiwyg editors.
diafol
Rhod Gilbert Fan (ardav)
7,792 posts since Oct 2006
Reputation Points: 1,170
Solved Threads: 1,080
I don't know about his Skills, but a starter can't Code everything from scratch! Classes are coded by more experienced coders, and they are provided with examples...
If he (phpangel) wants to learn php & mysql, i would suggest Lynda.com:
1. PHP with MySQL Essential Training (you will learn how to code a php/mysql a simple article site, form the scratch)
2. PHP with.MySQL Beyond the Basics (PHP gallery/OOP)
I agree - you can't do everything from scratch - the above links you note are good places to do some effective learning. My quibble is that a beginner will get very little from professional-level classes as they are usually OOPed and use the most efficient way of presenting conditionals (e.g. ternaries) - this is baffling for many!
Script bunnies can build decent sites, but if something goes wrong, they have little to no idea of how to fix it. As I mentioned a mix of ready-mades for things like wysiwyg editors and novel coding should be encouraged.
diafol
Rhod Gilbert Fan (ardav)
7,792 posts since Oct 2006
Reputation Points: 1,170
Solved Threads: 1,080
Croeso (you're welcome) - good hunting.
BTW - you can't go far wrong with a decent book on PHP5/MySQL5. I won't go on and on, but books are peer-reviewed and are usually full of good practice. O'Reilly and Wrox have good publications.
diafol
Rhod Gilbert Fan (ardav)
7,792 posts since Oct 2006
Reputation Points: 1,170
Solved Threads: 1,080
first of all, thank u all for the support, let me make life easy 4 u guyz, i'm beginner in PHP, and what i want from PHP now is:
to design a Web driven Database website and possibly with CMS, without having to use ready made open source CMS's.
thnax again:)
Hi,
I'm doing the same!
evstevemd
Senior Poster
3,713 posts since Jun 2007
Reputation Points: 462
Solved Threads: 392
