Construct a Publication System With PHP and MySQL

As we speak, we’re going to be constructing a publication system utilizing PHP with a MySQL background. The tutorial will cowl constructing a system that permits for a number of publication lists and the sending of messages to particular lists.

Hey guys, so we’re going to be constructing a fairly advanced publication system, so lets get began! You will want two assets for the venture.

Step 1: Create the Utility Skeleton

When beginning any venture, I wish to structure the folders earlier than I begin coding, so lets try this now. First, create the general venture listing. Subsequent, create a folder named admin inside your venture folder. Then contained in the admin folder, add two folders names media and swift. Lastly, create a folder named photographs contained in the media listing. Additionally, you possibly can place the Swift lib folder contained in the swift folder we created. It’s also possible to copy over the six silks icons we will probably be utilizing:

bullet_green.png

bullet_red.png

delete.png

email_go.png

discover.png

page_edit.png

I’m going to construction the remaining tutorial on creating the CRUD: create, learn, replace, and delete for 4 of our six fashions. One different will probably be edited by different actions, and the sixth we is not going to be creating the CRUD actions.

Now let’s first create our database, and our tables we be created progressively later. We are actually going to start out coding. Additionally, as a phrase of be aware, I’ll assume that we are going to be working with recordsdata in our admin folder, until I in any other case specify, as most of code be on this folder.

Step 2: Utility Configuration

Each software can have some kind of configuration file, and we’re going to create ours now. Go forward and create a file named config.php and add the next:

# admin/config.php 
	<?php  
	// DB Settings 
	outline('DB_SERVER', 'localhost'); 
	outline('DB_USER', 'root'); 
	outline('DB_PASSWORD', ''); 
	outline('DB_NAME', 'nettuts_ns_demo'); 
 
	outline('FROM_EMAIL', 'no_reply@ohyeahemail.com'); 
	outline('FROM_NAME', 'oh yeah e mail!'); 
 
 
	session_start(); 
	require_once 'lessons.php'; 
	$mini = false; 
	$nonav = false; 
	error_reporting(0);

So the primary part units up our database variables, so ensure you edit it so it firsts your native configuration. Our subsequent blurb units up some e mail attributes we’ll use later. The final part begins up our session so we are able to entry it, requires our lessons.php file (we’ll create that in only a second), units the defaults for some structure choices, after which units error reporting to 0 to cease annoying warnings. Nonetheless, should you appear to be having hassle, strive commenting out this line.

Now go forward and create our lessons.php file and add in:

# admin/lessons.php 
	<?php  
	// Authentication 
	operate validate_user($username, $pw) { 
	    if (check_username_and_pw($username, $pw)) { 
	        header('Location: index.php'); 
	    } else { 
	        $_SESSION['error'] = "Login error."; 
	        header('Location: login.php'); 
	    } 
	} 
 
	operate logged_in() { 
	    if ($_SESSION['authorized'] == true) { 
	        return true; 
	    } else { 
	        return false; 
	    } 
	} 
 
	operate login_required() { 
	    if(logged_in()) { 
	        return true; 
	    } else { 
	        header('Location: login.php'); 
	    } 
	} 
	// mysql  
	operate question($sql) { 
	  $hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
 
	  $stmt = $hyperlink->put together($sql) or die('error'); 
	  $stmt->execute(); 
	  $meta = $stmt->result_metadata(); 
 
	  whereas ($area = $meta->fetch_field()) { 
	    $parameters[] = &$row[$field->name]; 
	  } 
 
	  $outcomes = array(); 
	  call_user_func_array(array($stmt, 'bind_result'), $parameters); 
 
	  whereas ($stmt->fetch()) { 
	    foreach($row as $key => $val) { 
	      $x[$key] = $val; 
	    } 
	    $outcomes[] = $x; 
	  } 
 
	  return $outcomes; 
	  $outcomes->shut(); 
	  $hyperlink->shut(); 
	} 
 
	operate count_query($question) { 
	  $hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
	  if($stmt = $hyperlink->put together($question)) { 
	    $stmt->execute(); 
	    $stmt->bind_result($outcome); 
	    $stmt->fetch(); 
	    return $outcome; 
	    $stmt->shut(); 
	  } 
	  $hyperlink->shut(); 
	} 
 
	operate check_username_and_pw($u, $pw) { 
	  $hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
 
	  $question = "SELECT * FROM customers WHERE username = ? AND password = ? LIMIT 1"; 
	  if($stmt = $hyperlink->put together($question)) { 
	    $p = md5($pw); 
	    $stmt->bind_param('ss', $u, $p); 
	    $stmt->execute(); 
	    $stmt->bind_result($id, $username, $pw); 
	    if($stmt->fetch()) { 
	      $_SESSION['authorized'] = true; 
	      $_SESSION['username'] = $username; 
	      return true; 
	    } else { 
	      return false; 
	    } 
	    $stmt->shut(); 
	  } 
	  $hyperlink->shut(); 
	}

That could be a enormous chunk of code, and I will undergo it. Our first operate handles when the consumer posts our login, after which sends the information to our check_username_and_pw operate. Our logged_in operate merely returns whether or not a consumer is logged in. Our login_required operate checks to see if we’re logged in, and if not, sends us to the login web page.

The following operate merely named question() preforms a question on our DB, and was created by Jeffrey Approach. I added the hyperlink creation and shut capabilities to make it even simpler. Our subsequent operate I created particularly so we are able to simply run COUNT SQL queries, and our check_username_and_pw operate checks to see if we are able to discover a consumer with the identical e mail and MD5 hashed password, and in that case, units our session variables.

Step 3: Utility Structure

Our subsequent file we’ll work on is our structure.php file, so go forward and create it. In our head part we merely declare our common XHTML declarations. In the event you discover, we mechanically add the title of the web page to a different string for our title. Then we’ve a stylesheet (go forward and create that too in our media folder). After which we open our physique tag, and test to see if we wish a mini structure, and in that case provides a category. Then we’ve our header, after which test to see if we wish our navigation, and if we do, we present our tabs. I additionally added a manner so as to add a present class for every tab. We additionally then have a logout hyperlink, after which have our container div. On this, we add an h3 tag with our title, after which echo our content material.

# admin/structure.php 
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> 
	<html xmlns="http://www.w3.org/1999/xhtml" > 
	    <head> 
	        <meta http-equiv="Content material-Sort" content material="textual content/html; charset=utf-8" /> 
 
	        <title><?php echo $title; ?> » my publication app</title> 
	        <!-- Stylesheets --> 
	        <!-- <hyperlink rel="stylesheet" href="https://code.tutsplus.com/media/type.css" kind="textual content/css" media="all" /> --> 
	    </head> 
	    <physique<?php if ($mini == true) { ?> class="mini"<?php } ?>> 
	        <div id="header"> 
	            <h1><a href="index.php">my publication app</a></h1> 
	        </div> 
	        <?php if ($nonav == false) { ?> 
	        <div id="nav"> 
	            <a href="messages.php"<?php if($tab == 'mess') {?>class="present"<?php } ?>>messages</a> 
	            <a href="subscribers.php"<?php if($tab == 'sub') {?>class="present"<?php } ?>>subscribers</a> 
	            <a href="newsletters.php"<?php if($tab == 'nl') {?>class="present"<?php } ?>>newsletters</a> 
	            <a href="templates.php"<?php if($tab == 'temp') {?>class="present"<?php } ?>>templates</a> 
	            <span class="proper"> 
	                <a href="logout.php">sign off</a> 
	            </span> 
	        </div> 
	        <?php } ?> 
	        <div id="container"> 
	            <h3><?php echo $title;?></h3> 
	            <?php echo $content material; ?> 
	        </div> 
	    </physique> 
	</html>

Now, we’re going to create our index.php web page simply so we are able to type. Open up index.php and add:

# admin/index.php 
		<?php 
		require_once 'config.php'; 
		$title = "Dwelling!"; 
		$content material = <<<EOF 
		<h3>present stats</h3> 
		Our residence web page! 
		EOF; 
		embrace 'structure.php'; ?>

So on this, we require our config file, arrange our title, after which units up our content material variable, after which final requires our structure file. Once you first open it up it ought to seem like:

Now open up our type sheet. I like to make use of the 960.gs reset and typography types, compressed in TextMate. So the highest of my CSS file appears like:

# admin/media/type.css 
	/* reset */ 
	html,physique,div,span,applet,object,iframe,h1,h2,h3,h4,h5,h6,p,blockquote,pre,a,abbr,acronym,deal with,huge,cite,code,del,dfn,em,font,img,ins,kbd,q,s,samp,strike,sturdy,sub,sup,tt,var,b,u,i,heart,dl,dt,dd,ol,ul,li,fieldset,type,label,legend,desk,caption,tbody,tfoot,thead,tr,th,td{margin:0;padding:0;border:0;define:0;font-size:100%;vertical-align:baseline;background:clear}physique{line-height:1}ol,ul{list-style:none}blockquote,q{quotes:none}blockquote:earlier than,blockquote:after,q:earlier than,q:after{content material:'';content material:none}:focus{define:0}ins{text-decoration:none}del{text-decoration:line-through}desk{border-collapse:collapse;border-spacing:0} 
	/* typography */ 
	physique{font:13px/1.5 Helvetica,Arial,'Liberation Sans',FreeSans,sans-serif}a:focus{define:1px dotted invert}hr{border:0 #ccc stable;border-top-width:1px;clear:each;peak:0}h1{font-size:25px}h2{font-size:23px}h3{font-size:21px}h4{font-size:19px}h5{font-size:17px}h6{font-size:15px}ol{list-style:decimal}ul{list-style:sq.}li{margin-left:30px}p,dl,hr,h1,h2,h3,h4,h5,h6,ol,ul,pre,desk,deal with,fieldset{margin:10px 0;}

Let’s first type our most important parts, so add the next types:

1	# admin/media/type.css
2	#header {width:85%; margin:0 auto;}
3	#header h1 a {text-decoration:none; shade:#000;}
4	#container {width:85%; background: #111; margin:5px auto; shade:#fff; padding:10px;}

Now your web page ought to seem like:

Now if we type the tabs with a nav background after which a hover background on every of the hyperlinks and it is best to see:

# admin/media/type.css 
	/* tabs */ 
	#nav {margin:0 auto 2px;padding:10px;width:85%; background:#444;} 
	#nav a { padding:12px 10px; margin:0; shade:#fff; text-decoration:none; text-align:heart;} 
	#nav a.present, #nav a:hover {background:#111;} 
	#nav span.proper {float:proper;}

Now, whereas we’re engaged on the file, go forward and add the next types for our mini structure, type inputs, tables, giant hyperlinks, and our error & success messages.

# admin/media/type.css 
	physique.mini #header {width:30%; text-align:heart;} 
	physique.mini #container {width:30%;} 
 
	/* type */ 
	type enter.textual content {width:95%; font-size:16px;} 
	type textarea {width:95%; peak:100%;} 
	/* desk */ 
	desk {width:98%; text-align:proper; border:rgb(128,128,128); font-size:12px; margin:5px 10px; shade:#000;background:#fff;} 
	desk th {background-color: rgb(229, 229, 229); border:1px stable rgb(187, 187, 187); padding:3px 6px; font-weight:regular; shade:#000;} 
	desk tr td {border: 1px stable rgb(221, 221, 221); padding:3px 6px;} 
	desk tr:hover {background-color: rgb(240, 240, 240);shade:#000;} 
	/* a */ 
	a.giant {padding: 5px; shade:#000; background:#eee; text-decoration:none; margin:5px;} 
	a.giant.proper {float:proper;} 
	a.giant:hover, a.giant.present {background:#444; shade:#fff;} 
	/* messages */ 
	#message {margin: 5px 10px; padding: 4px; show:block;text-align:heart;} 
	#message.error {background:#FFEBE8;border: 1px stable #CC0000;shade:#CC0000;} 
	#message.success {border:stable 1px #349534; background:#C9FFCA;shade:#008000;}

These are some types that I like to make use of throughout all my tasks. Now that we’ve completed the structure, we’re going to proceed onto authentication.

Step 4: Authentication

We’re going to be working with a quite simple authentication system. Create a login.php and place the next inside:

# admin/login.php 
	<?php 
	require_once 'config.php'; 
	if(logged_in()) {header('Location: index.php');} 
	$title = "login"; 
	$nonav = true; 
	$mini = true; 
	if($_POST && (!empty($_POST['username']) ) && (!empty($_POST['password']))) { 
	    validate_user($_POST['username'], $_POST['password']); 
	} 
	$error = $_SESSION['error']; 
	$content material = <<<EOF 
	$error 
	<type motion="login.php" technique="submit"> 
	    <p> 
	        <label for="username">username:</label><br /> 
	        <enter kind="textual content" title="username" class="textual content" /> 
	    </p> 
	    <p> 
	        <label for="password">password:</label><br /> 
	        <enter kind="password" title="password" class="textual content" /> 
	    </p> 
	    <p> 
	        <enter kind="submit" worth="login" /> 
	    </p> 
	</type> 
	EOF; 
	embrace 'structure.php'; ?>

I will clarify every a part of the code. First we require our config file. Subsequent we test to see if we’re logged in, and if we’re, we redirect residence. Subsequent we set the title, and our structure choices. Then we test to see if we’ve a POST and if the POST had a username and password, and in that case, we name the validate_user operate from our lessons file. We subsequent set the variable error to our session errors, after which we arrange our type and output any errors. Now we’re going to create our logout web page, so create logout.php and put the next in it:

# admin/logout.php 
	<?php 
	require_once 'config.php'; 
	$_SESSION = array(); 
	session_destroy(); 
	header('Location: login.php'); 
	?>

We once more require our config file, set our session to an empty array, then destroy our session and redirect to our login web page. Now that you’ve finished all this, your login web page ought to seem like:

We’re additionally going to create a consumer document (and our desk) in order that we are able to add within the authentication logic and you’ll view the pages with the code up forward. To create a consumer with the username of admin and a password of secret. So as to add this, run this SQL:

CREATE TABLE `customers` ( 
	   `id` int(10) AUTO_INCREMENT, 
	   `username` varchar(50), 
	   `password` varchar(32), 
	   PRIMARY KEY (`id`) 
	) ENGINE=MyISAM DEFAULT CHARSET utf8; 
 
	INSERT INTO `customers` (`id`, `username`, `password`) VALUES  
	('1', 'admin', '5ebe2294ecd0e0f08eab7690d2a6ee69');

Step 5: Newsletters

I engineered this software to be very versatile. I wished you (the consumer) to have the ability to create and handle as many newsletters as you need. So, first, we have to create our database desk. Right here is the SQL code from the export on my demo software:

 
	CREATE TABLE `newsletters` ( 
	   `id` int(10) AUTO_INCREMENT, 
	   `title` varchar(50), 
	   `description` varchar(255), 
	   `seen` varchar(10), 
	   PRIMARY KEY (`id`) 
	) ENGINE=MyISAM DEFAULT CHARSET utf8;

So now that we’ve our newsletters desk, we’re going to create the pages for every motion. Create 4 recordsdata named: newsletters.php, newsletters_delete.php, newsletters_edit.php, and newsletters_new.php. First open up newsletters.php:

# admin/newsletters.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$title = "newsletters"; 
	$newsletters = question("SELECT * FROM newsletters ORDER BY id ASC"); 
	$tab = 'nl'; 
	$desk = ""; 
	foreach($newsletters as $row) { 
	    $dlink = '<a href="https://code.tutsplus.com/newsletters_delete.php?id=".$row['id'].'" onclick="return verify('Are you positive you wish to delete this text?');" title="delete"><img src="https://code.tutsplus.com/media/photographs/delete.png" alt="delete"/></a>'; 
	    $elink = '<a href="https://code.tutsplus.com/newsletters_edit.php?id=".$row['id'].'" title="edit" ><img src="https://code.tutsplus.com/media/photographs/page_edit.png" alt="edit"/></a>'; 
	    if($row['visible'] == "1") {$seen = '<img src="https://code.tutsplus.com/media/photographs/bullet_green.png" />';} else {$seen = '<img src="https://code.tutsplus.com/media/photographs/bullet_red.png" />';} 
	    $desk .= "<tr><td>".$row['id']."</td><td>".$row['name']."</td><td>".$row['description']."</td><td>$seen</td><td>".$dlink." ".$elink."</td></tr>n"; 
	} 
	$message = error_messages(); 
	$content material = <<<EOF 
	<a href="newsletters_new.php" class="giant">new publication »</a> 
	$message 
	<desk> 
	    <tr> 
	        <th></th> 
	        <th>title</th> 
	        <th>description</th> 
	        <th>seen</th> 
	        <th></th> 
	    </tr> 
	    $desk 
	</desk> 
	EOF; 
	embrace 'structure.php'; ?>

So this file has the identical primary really feel of our login web page. We require our config, make sure that we’re logged in, set our title. Subsequent we use our question() operate to carry out a SELECT question to seek out all of our newsletters. We then set the present tab for our structure. After we loop by means of the array returned by our question, and create the the desk structure. Then we name a yet-unknown operate, and create our web page. Earlier than it is possible for you to to view the web page, you’ll need so as to add the next to your lessons.php file to simply deal with our error messages:

# admin/lessons.php 
	// Render error messages 
	operate error_messages() { 
	    $message = ''; 
	    if($_SESSION['success'] != '') { 
	        $message = '<span class="success" id="message">'.$_SESSION['success'].'</span>'; 
	        $_SESSION['success'] = ''; 
	    } 
	    if($_SESSION['error'] != '') { 
	        $message = '<span class="error" id="message">'.$_SESSION['error'].'</span>'; 
	        $_SESSION['error'] = ''; 
	    } 
	    return $message; 
	}

Whilst you most likely is not going to have any knowledge, when you’ve got just a few information it’s going to seem like: (although a bit much less squished)

Now we’re going to work on our new motion, so open up newsletters_new.php and add the next:

# admin/newsletters_new.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$tab = 'nl'; 
 
	if(isset($_POST['submitted'])) {  
	    $hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
	    $sql = "INSERT INTO NEWSLETTERS (title, description) VALUES ( '".$_POST['name']."' , '".$_POST['description']."' )"; 
	    $stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	    $stmt->shut; 
	    $_SESSION['success'] = "Added publication.";  
	    header('Location: newsletters.php'); 
	} 
	$title = "new publication"; 
	$content material = <<<EOF 
	<type motion="newsletters_new.php" technique='POST'>  
	    <p> 
	        <label for="title">Identify:</label><br /> 
	        <enter kind='textual content' title='title' class="textual content" />  
	    </p> 
	    <p> 
	        <label for="description">Description:</label> 
	        <enter kind="textual content" title="description" class="textual content" />  
	    </p> 
	    <p> 
	        <enter kind='submit' worth='Add Publication' /> 
	        <enter kind='hidden' worth='1' title='submitted' />  
	    </p> 
	</type> 
	EOF; 
	embrace 'structure.php'; ?>

So I hope you’ve got observed the sample on the high of every of our recordsdata. We first require our config.php file, then make sure that we’re logged in, after which set our present tab, and we then add some further logic for dealing with POSTs after which we set our title, our content material, after which render the web page. The POST part is pretty easy to grasp so I will clarify it shortly.

We first test to see if an merchandise with the title of submitted was despatched. That is the hidden area we’ve after the submit button. Subsequent, we create a hyperlink to our database utilizing the variables from our config file. Subsequent we create our SQL insert question, utilizing our POSTed variables. Subsequent we question (not our operate) the database, and if an error is raised, we present the error returned. Subsequent, we shut the question, then we set our success message, after which redirect to the itemizing web page. Your web page ought to seem like:

Subsequent we’re going to work on our edit web page and add the next:

# admin/newsletters_edit.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$tab = 'nl'; 
 
	if(isset($_POST['submitted'])) {  
	    $hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
	    if(isset($_POST['visible'])) {$seen = 1;}else{$seen = 0;} 
	    $sql = "UPDATE NEWSLETTERS SET title="".$_POST["name']."', description='".$_POST['description']."', seen=".$seen." WHERE id=".$_POST['id'].""; 
	    $stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	    $stmt->shut; 
	    $_SESSION['success'] = "Edited publication.";  
	    header('Location: newsletters.php'); 
	} 
	$title = "edit publication"; 
	$id = (int) $_GET['id']; 
	$outcomes = question("SELECT * FROM newsletters WHERE id='".$id."' LIMIT 1"); 
	$title = $outcomes[0]['name']; 
	$description = $outcomes[0]['description']; 
	$seen = ($outcomes[0]['visible'] == "1") ? 'checked="checked"' : ''; 
	$content material = <<<EOF 
	<type motion="newsletters_edit.php" technique='POST'>  
	    <p> 
	        <label for="title">Identify:</label><br /> 
	        <enter kind='textual content' title='title' class="textual content" worth="$title" />  
	    </p> 
	    <p> 
	        <label for="description">Description:</label> 
	        <enter kind="textual content" title="description" class="textual content" worth="$description" />  
	    </p> 
	    <p> 
	        <label for="seen">Seen:</label> 
	        <enter kind="checkbox" title="seen" worth="true" $seen/> 
	    </p> 
	    <p> 
	        <enter kind='submit' worth='Edit Publication' /> 
	        <enter kind='hidden' worth='1' title='submitted' />  
	        <enter kind='hidden' worth='$id' title='id' /> 
	    </p> 
	</type> 
	EOF; 
	embrace 'structure.php'; ?>

Identical to all of our recordsdata, we begin off with the identical block. After our POST block (which I’ll speak about in a second), we set id to our requested id, ensuring it’s an integer. We then use our question operate to seek out the publication we’re working with, and units just a few variables to the returned outcomes. Chances are you’ll ask why we put a [0] earlier than we requested every worth, and the reason being the question operate returns an array of all of the information, and every document is an array, so we have to entry the primary array in our outcomes variable. The road the place we set the variable seen ifs truly a compressed if/else assertion. the if half is the == 1, then if that’s true, the variable is about to checked, else to nothing. Then we’ve our type.

Our POST block is similar to our new web page, and can at all times begin the identical manner throughout the remainder of our pages. We then test to see if the test field was test, and set a variable right here once more. Then we’ve our UPDATE question, once more run the question, set our success message, after which redirect residence. THis is how the shape appears and the message seen after enhancing:

The final web page for this part is the best, as it’s the delete web page. Open up the file and paste to following:

# admin/newsletters_delete.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$id = (int) $_GET['id'];  
	$hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
	$sql = "DELETE FROM newsletters WHERE id=$id LIMIT 1"; 
	$stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	if($hyperlink->affected_rows) { 
	    $_SESSION['success'] = "Publication deleted."; 
	} else { 
	    $_SESSION['error'] = 'Nothing deleted.'; 
	} 
	header('Location: newsletters.php');

On this block we require our config, make sure that we’re logged in, then save the requested id to a variable, create a MySQL connection, setup our SQL question, then execute the question. We subsequent test to see if a row was affected, and units a message appropriately. We then redirect to the newsletters web page. Congrats, you’ve got completed the primary of 4 CRUD sections. Subsequent, we’ll work on the CRUD for our templates.

Step 6: Templates

Our software will even enable a number of templates, all saved within the database. First, lets create our database desk:

 
	CREATE TABLE `templates` ( 
	   `id` int(10) AUTO_INCREMENT, 
	   `title` varchar(50), 
	   `columns` tinyint(5), 
	   `physique` textual content, 
	   PRIMARY KEY (`id`) 
	) ENGINE=MyISAM DEFAULT CHARSET utf8;

We’ve got an auto-incrementing id column, a reputation column, a columns column to save lots of the variety of columns (the applying solely scales to 2 columns, which needs to be sufficient, however can simply be expanded. This may be used for various sections.), and our physique. Identical to final time, we have to make every of our pages, and we can have a templates.php web page, in addition to templates_new.php, templates_edit.php, templates_delete.php, and templates_preview.php. We’re first going to work on our templates.php file, so open it up and paste:

# admin/templates.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$title = "templates"; 
	$tab = 'temp'; 
	$templates = question("SELECT id,title,columns FROM templates ORDER BY id ASC"); 
	$desk = ""; 
	foreach($templates as $row) { 
	    $plink = '<a href="" onClick="window.open('templates_preview.php?id='.$row['id'].'',width=800,peak=600)" title="preview"><img src="https://code.tutsplus.com/media/photographs/discover.png" alt="preview"/></a>'; 
	    $dlink = '<a href="https://code.tutsplus.com/templates_delete.php?id=".$row['id'].'" onclick="return verify('Are you positive you wish to delete this template?');" title="delete"><img src="https://code.tutsplus.com/media/photographs/delete.png" alt="delete"/></a>'; 
	    $elink = '<a href="https://code.tutsplus.com/templates_edit.php?id=".$row['id'].'" title="edit"><img src="https://code.tutsplus.com/media/photographs/page_edit.png" alt="edit"/></a>'; 
	    $desk .= "<tr><td>".$row['id']."</td><td>".$row['name']."</td><td>".$row['columns']."</td><td>".$plink." ".$dlink." ".$elink."</td></tr>n"; 
	} 
	$message = error_messages(); 
	$content material = <<<EOF 
	<a href="templates_new.php" class="giant">new template »</a> 
	$message 
	<desk> 
	    <tr> 
	        <th></th> 
	        <th>title</th> 
	        <th>columns</th> 
	        <th></th> 
	    </tr> 
	    $desk 
	</desk> 
	EOF; 
	embrace 'structure.php'; ?>

Once more we begin with the fundamentals. We then preform a question to seek out all of our templates. We then loop by means of every array in templates and we create a desk. We then get our error (and success) messages, after which our content material. Your web page ought to look one thing like:

Now, shifting on to our our new web page, paste the next:

# admin/templates_new.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$tab = 'temp'; 
	if(isset($_POST['submitted'])) {  
	    $hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
	    $sql = "INSERT INTO templates (title, columns, physique) VALUES ( '".$_POST['name']."' , ".$_POST['columns'].", '".mysql_real_escape_string($_POST['body'])."' )"; 
	    $stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	    $stmt->shut; 
	    $_SESSION['success'] = "Added template.";  
	    header('Location: templates.php'); 
	} 
	$title = "new template"; 
	$content material = <<<EOF 
	<type motion="templates_new.php" technique='POST'>  
	    <p> 
	        <label for="title">Identify:</label><br /> 
	        <enter kind='textual content' title='title' class="textual content" />  
	    </p> 
	    <p> 
	        <label for="columns">Columns</label> 
	        <choose title="columns"> 
	            <choice worth="1">Single Column Structure</choice> 
	            <choice worth="2">Two Column Structure</choice> 
	        </choose> 
	    </p> 
	    <p> 
	        <label for="description">Physique: (uncooked html)</label><br /> 
	        Use %content material% for a single column structure, %leftcol% and %rightcol% for a two column structure.<br /> 
	        <textarea title="physique" rows="35"></textarea>  
	    </p> 
	    <p> 
	        <enter kind='submit' worth='Add Template' /> 
	        <enter kind='hidden' worth='1' title='submitted' />  
	    </p> 
	</type> 
	EOF; 
	embrace 'structure.php'; ?>

So, once more, we’ve our similar header. Our POST once more creates a MySQL connection, then we create our question, and utilizing mysql_real_escape_string to permit any characters into the document, after which we execute our question, set our success message, and redirect to our templates itemizing. In the event you take a look at our type, I additionally ask for variables to be inserted for our content material, and I’ll present you ways this comes into play later after we match a message with a template. Your web page ought to seem like:

Subsequent we’re going to work on our edit web page. In case you have observed, a lot of this code is copy and paste throughout the entire similar actions, so make it straightforward on your self.

# admin/templates/edit.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$tab = 'temp'; 
	if(isset($_POST['submitted'])) {  
	    $hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
	    $sql = "UPDATE templates SET title="".$_POST["name']."', physique='".mysql_real_escape_string($_POST['body'])."', columns=".$_POST['columns']." WHERE id=".$_POST['id'].""; 
	    $stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	    $stmt->shut; 
	    $_SESSION['success'] = "Edited template.";  
	    header('Location: templates.php'); 
	} 
	$title = "edit template"; 
	$id = (int) $_GET['id']; 
	$outcomes = question("SELECT * FROM templates WHERE id='".$id."' LIMIT 1"); 
	$title = $outcomes[0]['name']; 
	$templatedata = stripslashes(htmlspecialchars($outcomes[0]['body'])); 
	$content material = <<<EOF 
	<type motion="templates_edit.php" technique='POST'>  
	    <p> 
	        <label for="title">Identify:</label><br /> 
	        <enter kind='textual content' title='title' class="textual content" worth="$title"/>  
	    </p> 
	    <p> 
	        <label for="columns">Columns</label> 
	        <choose title="columns"> 
	            <choice worth="1">Single Column Structure</choice> 
	            <choice worth="2">Two Column Structure</choice> 
	        </choose> 
	    </p> 
	    <p> 
	        <label for="physique">Physique: (uncooked html)</label><br /> 
	        Use %content material% for a single column structure, %leftcol% and %rightcol% for a two column structure.<br /> 
	        <textarea title="physique" rows="35">$templatedata</textarea>  
	    </p> 
	    <p> 
	        <enter kind='submit' worth='Edit Template' /> 
	        <enter kind='hidden' worth='1' title='submitted' />  
	        <enter kind='hidden' worth='$id' title='id' /> 
	    </p> 
	</type> 
	EOF; 
	embrace 'structure.php'; ?>

We begin with the identical intro, then our POST block, our title, then our requested id. After, we try to discover the template we’re working with, then units three variables in order that we are able to inset them into our content material block. We additionally convert the entire tags we saved to HTML characters so all the pieces will show. When our POST block, you’ll discover we create our hyperlink, then our question and once more use mysql_real_escape_string to save lots of all the pieces, execute our question, after which set our message, and redirect to our templates checklist. Your edit web page (with a pattern document) ought to seem like:

Now we’ll create one other delete web page, so open up our delete web page and paste in:

# admin/templates_delete.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$id = (int) $_GET['id'];  
	$hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
	$sql = "DELETE FROM templates WHERE id=$id LIMIT 1"; 
	$stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	if($hyperlink->affected_rows) { 
	    $_SESSION['success'] = "Template deleted."; 
	} else { 
	    $_SESSION['error'] = 'Nothing deleted.'; 
	} 
	header('Location: templates.php');

I hope you’ve got picked up the sample right here, this can be a quite simple web page. Now we’re going to work on an additional web page that isn’t a part of the CRUD spectrum; we’re going to create a preview web page. The binoculars within the motion half on the desk is the hyperlink for each (in a brand new window). So open up our preview web page. The web page could be very easy, we discover our template and echo the information, after which append a javascript shut button. The code appears like:

# admin/templates_preview.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$id = (int) $_GET['id']; 
	$knowledge = question("SELECT physique FROM templates WHERE id=$id LIMIT 1"); 
	$template = $knowledge[0]['body']; 
	?> 
	<?php echo $template; ?> 
	<heart><button kind="button" onclick="self.shut();">shut window</button></heart>

And an instance preview appears like:

Now we’ve completed with our Templates, we’re prepared to maneuver onto the subsequent step!

Step 7: Subscribers

So now we’re going to work with our subscribers! We’re going to create two tables. The primary:

CREATE TABLE `subscribers` ( 
	   `id` tinyint(10) AUTO_INCREMENT, 
	   `title` varchar(50), 
	   `e mail` varchar(50), 
	   PRIMARY KEY (`id`) 
	) ENGINE=MyISAM DEFAULT CHARSET utf8;

Refers to every subscriber, and the second:

CREATE TABLE `subscriptions` ( 
	   `id` tinyint(10) AUTO_INCREMENT, 
	   `subscriber_id` tinyint(10), 
	   `newsletter_id` tinyint(10), 
	   PRIMARY KEY (`id`) 
	) ENGINE=MyISAM DEFAULT CHARSET utf8;

Creates a desk for our many-to-many relationship with our newsletters. A subscriber can have a number of subscription to newsletters, to allow them to subscribe to a number of ones, and every publication can have many subscribers. To create essentially the most dynamic answer, we’ve a linking desk.

Let’s first create our recordsdata. The recordsdata we’re going are going to have are subscribers.php, subscribers_delete.php, and subscribers_edit.php. Our create motion will probably be created later for the front-end. First open up subscribers.php and paste in:

# admin/subscribers.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$title = "subscribers"; 
	$tab = 'sub'; 
	$desk = ""; 
	$messages = question("SELECT * FROM subscribers ORDER BY id ASC"); 
	foreach($messages as $row) { 
		$dlink = '<a href="https://code.tutsplus.com/subscribers_delete.php?id=".$row['id'].'" onclick="return verify('Are you positive you wish to delete this subscriber?');" title="delete"><img src="https://code.tutsplus.com/media/photographs/delete.png" alt="delete"/></a>'; 
		$elink = '<a href="https://code.tutsplus.com/subscribers_edit.php?id=".$row['id'].'" title="edit"><img src="https://code.tutsplus.com/media/photographs/page_edit.png" alt="edit"/></a>'; 
		$desk .= '<tr><td>'.$row['id'].'</td><td>'.$row['name'].'</td><td>'.$row['email'].'</td><td>'.$dlink.' '.$elink.'</td></tr>'; 
	} 
	$message = error_messages(); 
	$content material = <<<EOF 
	$message 
	<desk> 
		<tr> 
			<th></th> 
			<th>title</th> 
			<th>e mail</th> 
			<th></th> 
		</tr> 
		$desk 
	</desk> 
	EOF; 
	embrace 'structure.php'; ?>

We’ve got principally the identical itemizing pages as earlier than, besides this time we will probably be discovering our subscribers. Your web page (with some pattern knowledge) ought to seem like:

Now we’ll transfer on to our edit web page:

# admin/subscribers_edit.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$tab = 'sub'; 
 
	if(isset($_POST['submitted'])) {  
	    $id = (int) $_POST['id']; 
	    $hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
	    $sql = "UPDATE subscribers SET title="".$_POST["name']."', e mail="".$_POST["email']."' WHERE id=$id"; 
	    $stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	    $stmt->shut; 
 
	    foreach($_POST['newsletter'] as $n) { 
	        if($n['exists'] != '1' && $n['subscribe'] == "true") { // If we wish to subscribe however the document doesnt exist 
	            $nlid = $n['nlid']; 
	            $sql = "INSERT INTO subscriptions (subscriber_id, newsletter_id) VALUES ('$id', '$nlid')"; 
	            $stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	            $stmt->shut; 
	        } elseif ($n['exists'] == '1' && $n['subscribe'] != "true") {// Else if we had an exits however we wish to unsubscribe 
	            $subid = $n['subid']; 
	            $sql = "DELETE FROM subscriptions WHERE id=$subid LIMIT 1"; 
	            $stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	            $stmt->shut; 
	        } 
	    } 
	    $_SESSION['success'] = "Edited subscriber.";  
	    header('Location: subscribers.php'); 
	} 
	$title = "edit publication"; 
	$id = (int) $_GET['id']; 
 
	$subscriber = question("SELECT * FROM subscribers WHERE id='$id'"); 
	$title = $subscriber[0]['name']; 
	$e mail = $subscriber[0]['email']; 
 
	$newsletters = question("SELECT * FROM newsletters"); 
	$subs = question("SELECT * FROM subscriptions WHERE subscriber_id='".$id."'"); 
	$subscriptions = ''; 
	foreach($newsletters as $nl) { 
	    $s = false; 
	    $subid = ''; 
	    foreach($subs as $sub) { 
	        if($sub['newsletter_id'] == $nl['id']) {$s = true; $subid = $sub['id'];} 
	    } 
	    $checked = ($s == true) ? 'checked="checked"' : ''; 
	    $subscriptions .= ' 
	    <enter kind="checkbox" title="publication['.$nl["id"].'][subscribe]" worth="true" '.$checked.'/> 
	    <label for="publication['.$nl["id"].']">'.$nl['name'].'</label> 
	    <enter kind="hidden" title="publication['.$nl["id"].'][exists]" worth="'.$s.'" /> 
	    <enter kind="hidden" title="publication['.$nl["id"].'][nlid]" worth="'.$nl['id'].'" /> 
	    <enter kind="hidden" title="publication['.$nl["id"].'][subid]" worth="'.$subid.'" /><br /> 
	    '; 
 
 
	} 
	$content material = <<<EOF 
	<type motion="subscribers_edit.php" technique='POST'>  
	    <p> 
	        <label for="title">Identify:</label><br /> 
	        <enter kind='textual content' title='title' class="textual content" worth="$title" />  
	    </p> 
	    <p> 
	        <label for="e mail">Electronic mail</label><br /> 
	        <enter kind="textual content" title="e mail" class="textual content" worth="$e mail" />  
	    </p> 
	    <p> 
	        <sturdy>Newsletters:</sturdy><br /> 
	        $subscriptions 
	    </p> 
	    <p> 
	        <enter kind='submit' worth='Edit Subscriber' /> 
	        <enter kind='hidden' worth='1' title='submitted' />  
	        <enter kind='hidden' worth='$id' title='id' /> 
	    </p> 
	</type> 
	EOF; 
	embrace 'structure.php'; ?>

This web page is pretty completely different so I’ll clarify every half. The header is similar we’ve been utilizing. I will skip the POST block and are available again to it. We then proceed the identical code. We subsequent discover our present subscriber. Subsequent we discover all newsletters (this consists of ones that aren’t seen – seen imply seen to the general public) after which the entire subscriber’s subscriptions. We subsequent loop by means of each publication document returned, we subsequent reset some values. Subsequent, we loop by means of each subscription the consumer has, and if the subscription’s newsletter_id is the same as the present publication we’re looping we set $s true, and $subid equal to the subscription id. We then set the variable $checked equal to both checked or nothing relying on whether or not a subscription was discovered for this subscriber and the present publication within the loop. Subsequent we create the checkbox type space, with a variety of hidden fields. First, we’ve the precise checkbox with a reputation that may create an array for every checkbox. We then have our label, and subsequent we output whether or not or not the subscription exists, the newsletter_id after which the subscription_id for when the subscription exists. After which we’ve our regular content material.

Now, if we transfer on to our POST block. We first get the id posted from our hidden area on the backside. We subsequent create our MySQL hyperlink. Subsequent we’ve our first SQL question the place we replace the subscriber document. Subsequent we loop by means of each publication checkbox. The primary conditional assertion checks to see if the POSTed knowledge says we would not have an current subscription, and the consumer needs to subscribe to the publication. To deal with this, we’re going to carry out a SQL INSERT into our subscriptions desk the place our subscriber_id is similar because the user_id we’re enhancing, and newsletter_id equal to the ‘nlid’ worth POSTed by one in all our hidden fields. We then execute that SQL INSERT question. The elseif conditional assertion says that if our subscription exists, however the checkbox was unchecked so we unsubscribe, we have to delete the subscription. We deal with this with a SQL DELETE question. To type our question we set $subid equal to the posted worth for our ‘subid’. We then create our question by deleting the document the place the subscription id equals our variable of $subid. Subsequent we execute the question, set our session success message, after which redirect again to our subscribers web page. Your ultimate edit web page ought to seem like: (full of pattern knowledge)

We’ve got one final web page to work on for the subscribers a part of the backend: the delete web page. Identical to earlier than, this web page could be very easy:

# admin/subscribers_delete.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$id = (int) $_GET['id'];  
	$hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
	$sql = "DELETE FROM subscribers WHERE id=$id LIMIT 1"; 
	$stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	if($hyperlink->affected_rows) { 
	    $_SESSION['success'] = "Subscriber deleted."; 
	} else { 
	    $_SESSION['error'] = 'Nothing deleted.'; 
	} 
	header('Location: subscribers.php');

Step 8: Messages

I’ll let you know upfront, this part has essentially the most pages. We will probably be working with seven now, and creating yet another in Step 10. First, we’re going to create our messages desk with this SQL:

CREATE TABLE `messages` ( 
	   `id` tinyint(10) AUTO_INCREMENT, 
	   `topic` varchar(255), 
	   `leftcol` textual content, 
	   `rightcol` textual content, 
	   `template_id` tinyint(10), 
	   PRIMARY KEY (`id`) 
	) ENGINE=MyISAM DEFAULT CHARSET utf8;

Subsequent, we’ll create the recordsdata for this step. Creates seven recordsdata, every named messages.php, messages_delete.php, messages_edit.php, messages_new.php, messages_new_step2.php, messages_new_step3.php, and messages_preview.php. Let’s first open up messages.php and make it seem like:

# admin/messages.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$title = "messages"; 
	$tab = 'mess'; 
	$desk = ""; 
	$messages = question("SELECT * FROM messages ORDER BY id ASC"); 
	foreach($messages as $row) { 
	    $slink = '<a href="https://code.tutsplus.com/messages_send.php?id=".$row['id'].'" title="ship message"><img src="https://code.tutsplus.com/media/photographs/email_go.png" alt="ship message"/></a>'; 
	    $plink = '<a href="https://code.tutsplus.com/messages_preview.php?id=".$row['id'].'" goal="_new" title="preview"><img src="https://code.tutsplus.com/media/photographs/discover.png" alt="preview"/></a>'; 
	    $dlink = '<a href="https://code.tutsplus.com/messages_delete.php?id=".$row['id'].'" onclick="return verify('Are you positive you wish to delete this message?');" title="delete"><img src="https://code.tutsplus.com/media/photographs/delete.png" alt="delete"/></a>'; 
	    $elink = '<a href="https://code.tutsplus.com/messages_edit.php?id=".$row['id'].'" title="edit"><img src="https://code.tutsplus.com/media/photographs/page_edit.png" alt="edit"/></a>'; 
	    $desk .= '<tr><td>'.$row['id'].'</td><td>'.$row['subject'].'</td><td><a href="" onClick="window.open('templates_preview.php?id='.$row['template_id'].'',width=800,peak=600)" title="preview"><img src="https://code.tutsplus.com/media/photographs/discover.png" alt="preview"/></a></td><td>'.$slink.' '.$plink.' '.$dlink.' '.$elink.'</td></tr>'; 
	} 
	$message = error_messages(); 
	$content material = <<<EOF 
	<a href="messages_new.php" class="giant">new message »</a> 
	$message 
	<desk> 
	    <tr> 
	        <th></th> 
	        <th>topic</th> 
	        <th>template</th> 
	        <th></th> 
	    </tr> 
	    $desk 
	</desk> 
	EOF; 
	embrace 'structure.php'; ?>

That is our routine desk, besides we now have 4 ‘further’ hyperlinks now, one to ship the message, one to preview, one to edit, and one to delete. Your web page ought to seem like:

Now we’re going to begin work on our new pages. The primary web page is the place all messages begin out, after which you possibly can progress on and enter the precise message on the subsequent web page. The explanation for it is because we first must create the preliminary message within the DB and so we are able to discover details about the template. The step2 web page is principally the edit web page (there are six line variations in accordance with FileMerge). Open up our new file and paste the next:

# admin/messages_new.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$tab = 'mess'; 
	if(isset($_POST['subject'])) {  
	    $hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
	    $sql = "INSERT INTO messages (topic, template_id) VALUES ( '".$_POST['subject']."' , ".$_POST['template'].")"; 
	    $stmt = $hyperlink->question($sql) or die($hyperlink->error);     
	    $i = question("SELECT id FROM messages WHERE topic="".$_POST["subject']."' AND template_id=".$_POST['template']." "); 
	    $id = $i[0]['id']; 
	    $stmt->shut; 
	    $_SESSION['success'] = "Added template.";  
	    header('Location: messages_new_step2.php?id=' + $id); 
	} 
	$title = "new message"; 
	$templates = question("SELECT id,title,columns FROM templates"); 
	$tselect = '<choose title="template">'; 
	foreach($templates as $row) { 
	    $tselect .= '<choice worth="'.$row['id'].'">'.$row['name'].'</choice>'; 
	} 
	$tselect .= "</choose>"; 
	$content material = <<<EOF 
	<type motion="messages_new.php" technique='POST'>  
	    <p> 
	        <label for="topic">Topic:</label><br /> 
	        <enter kind='textual content' title='topic' class="textual content" />  
	    </p> 
	    <p> 
	        <label for="template">Template:</label> 
	        $tselect 
	    </p> 
	    <p> 
	        <button onclick="">Proceed »</button> 
	    </p> 
	</type> 
	EOF; 
	embrace 'structure.php'; ?>

This web page is similar to what our different new pages seem like, however this one was one change within the POST block. Proper after we carry out the SQL INSERT, we discover the latest insert id. Now this isn’t the proper answer, however I want it to performing one other SQL question to discover a row utilizing unindexed columns. This step ought to seem like:

We then redirect to step2, so let’s open up the file:

# admin/messages_new_step2.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$title = "new message - step 2"; 
	$tab = 'mess'; 
	$id = (int) $_GET['id']; 
 
	$mess = question("SELECT * FROM messages WHERE id=$id"); 
	$message = $mess[0]; 
	$topic = $message['subject']; 
 
	$templates = question("SELECT id,title,columns FROM templates"); 
	$tselect = '<choose title="template">'; 
	foreach($templates as $row) { 
	    if($message['template_id'] == $row['id']) { 
	        $chosen = ' chosen="chosen"'; 
	        if($row['columns'] == "1") { 
	            $textareas = '<p><label for="physique">Physique: (uncooked html)</label><br /><textarea title="physique" rows="35"></textarea></p>'; 
	        } else { 
	            $textareas = '<p><label for="leftcol">Left column: (uncooked html)</label><br /><textarea title="leftcol" rows="35"></textarea></p> 
	            <p><label for="rightcol">Proper column: (uncooked html)</label><br /><textarea title="rightcol" rows="35"></textarea></p>'; 
	        } 
 
	    } else {$chosen = '';} 
	    $tselect .= '<choice worth="'.$row['id'].'"'.$chosen.'>'.$row['name'].'</choice>'; 
	} 
	$tselect .= '</choose>'; 
 
	// Verify for a POST 
	if(isset($_POST['submitted'])) {  
	    $hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
		$template = question("SELECT columns FROM templates WHERE id=".$message['template_id']); 
	    if($template[0]['columns'] == "1") { 
	        $physique = mysql_real_escape_string($_POST['body']); 
	        $sql = "UPDATE messages SET topic="".$_POST["subject']."', leftcol="$physique" WHERE id=$id"; 
	    } else { 
	        $leftcol = mysql_real_escape_string($_POST['leftcol']); 
	        $rightcol = htmlentities($_POST['rightcol']); 
	        $sql = "UPDATE messages SET topic="".$_POST["subject']."', leftcol="$leftcol", rightcol="$rightcol" WHERE id=$id"; 
	    } 
	    $stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	    $stmt->shut; 
	    header('Location: messages_new_step3.php?id='.$id); 
	} 
 
	$content material = <<<EOF 
	<type motion="messages_new_step2.php?id=$id" technique='POST'>  
	    <p> 
	        <label for="topic">Topic:</label><br /> 
	        <enter kind='textual content' title='topic' class="textual content" worth="$topic"/>  
	    </p> 
	    <p> 
	        <label for="template">Template:</label> 
	        $tselect 
	    </p> 
	    $textareas 
	    <p> 
	        <enter kind='submit' worth='Proceed »' /> 
	        <enter kind='hidden' worth='1' title='submitted' /> 
	    </p> 
	</type> 
	EOF; 
	embrace 'structure.php'; ?>

Hopefully you’ve got gotten the gist of all of the pages and perceive the web page above. We’ve got our regular heading. we then set our id from our GET request. Subsequent we discover the message we’re working with, then we discover all of the templates and assemble a drop down. We additionally use this look to outline whether or not we can have one or two textareas. Subsequent we’ve our POST block, which creates the hyperlink, then checks to see if we’re working with one or two columns and creates the suitable SQL question. After that we’ve our type. Your type ought to seem like:

Now we’ll proceed onto step 3, so open up the file and paste:

# admin/messages_new_step3.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$title = "new message - step 3"; 
	$id = (int) $_GET['id']; 
	$tab = 'mess'; 
 
	$mess = question("SELECT * FROM messages WHERE id=$id"); 
	$message = $mess[0]; 
	$topic = $message['subject']; 
 
	$content material = <<<EOF 
	<a href="messages_preview.php?id=$id" class="giant" goal="_new">preview »</a><br /> 
	<p>Do you need to <a href="messages.php" class="giant">return to messages</a> or <a href="messages_send.php?id=$id" class="giant">ship the message</a>?</p> 
	EOF; 
	embrace 'structure.php'; 
	?>

The web page could be very easy and is the top of making a message. It affords us just a few hyperlinks. The primary is a hyperlink to preview the message. The following affords to take us again residence. The third affords to take us to ship the message (Step 10). The web page appears like:

Now we’re going to proceed on to our edit web page. I cannot clarify it as it’s the similar file as messages_new_step2.php, so you possibly can refer there.

# admin/messages_edit.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$title = "edit message"; 
	$id = (int) $_GET['id']; 
	$tab = 'mess'; 
 
	$mess = question("SELECT * FROM messages WHERE id=$id"); 
	$message = $mess[0]; 
	$topic = $message['subject']; 
 
	$templates = question("SELECT id,title,columns FROM templates"); 
	$tselect = '<choose title="template">'; 
	foreach($templates as $row) { 
	    if($message['template_id'] == $row['id']) { 
	        $chosen = ' chosen="chosen"'; 
	    } else {$chosen = '';} 
	    $tselect .= '<choice worth="'.$row['id'].'"'.$chosen.'>'.$row['name'].'</choice>'; 
	} 
	$tselect .= '</choose>'; 
 
	$mid = $message['template_id']; 
	$template = question("SELECT id,title,columns FROM templates WHERE id=$mid"); 
	if($template[0]['columns'] == "1") { 
	    $textareas = '<p><label for="physique">Physique: (uncooked html)</label><br /><textarea title="physique" rows="35">'.$message['leftcol'].'</textarea></p>'; 
	} else { 
	    $textareas = '<p><label for="leftcol">Left column: (uncooked html)</label><br /><textarea title="leftcol" rows="35">'.$message['leftcol'].'</textarea></p> 
	    <p><label for="rightcol">Proper column: (uncooked html)</label><br /><textarea title="rightcol" rows="35">'.$message['rightcol'].'</textarea></p>'; 
	} 
 
	// Verify for a POST 
	if(isset($_POST['submitted'])) {  
	    $hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
	    if($template[0]['columns'] == "1") { 
	        $physique = mysql_real_escape_string($_POST['body']); 
	        $sql = "UPDATE messages SET topic="".$_POST["subject']."', leftcol="$physique" WHERE id=$id"; 
	    } else { 
	        $leftcol = mysql_real_escape_string($_POST['leftcol']); 
	        $rightcol = htmlentities($_POST['rightcol']); 
	        $sql = "UPDATE messages SET topic="".$_POST["subject']."', leftcol="$leftcol", rightcol="$rightcol" WHERE id=$id"; 
	    } 
	    $stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	    $stmt->shut; 
	    $_SESSION['success'] = "Edited message.";  
	    header('Location: messages.php'); 
	} 
 
	$content material = <<<EOF 
	<type motion="messages_edit.php?id=$id" technique='POST'>  
	    <p> 
	        <label for="topic">Topic:</label><br /> 
	        <enter kind='textual content' title='topic' class="textual content" worth="$topic"/>  
	    </p> 
	    <p> 
	        <label for="template">Template:</label> 
	        $tselect 
	    </p> 
	    $textareas 
	    <p> 
	        <enter kind='submit' worth='Save »' /> 
	        <enter kind='hidden' worth='1' title='submitted' /> 
	    </p> 
	</type> 
	EOF; 
	embrace 'structure.php'; ?>

The web page will look nearly similar to our step 2, however the textarea can have content material. Now we’ll create the delete web page with:

# admin/messages_delete.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$id = (int) $_GET['id'];  
	$hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
	$sql = "DELETE FROM messages WHERE id=$id LIMIT 1"; 
	$stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	if($hyperlink->affected_rows) { 
	    $_SESSION['success'] = "Message deleted."; 
	} else { 
	    $_SESSION['error'] = 'Nothing deleted.'; 
	} 
	header('Location: messages.php'); ?>

That web page must also look acquainted. The ultimate web page we’re going to work on on this step is our preview web page, so open it up and place:

# admin/messages_preview.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$id = (int) $_GET['id']; 
 
	$mess = question("SELECT * FROM messages WHERE id=$id"); 
	$message = $mess[0]; 
	$topic = $message['subject']; 
	$tid = $message['template_id']; 
 
	$knowledge = question("SELECT physique,columns FROM templates WHERE id=$tid LIMIT 1"); 
	$template = $knowledge[0]['body']; 
 
	if($knowledge[0]['columns'] == "1") { 
	    $leftcol = $message['leftcol']; 
	    $physique = str_replace('%content material%', $leftcol, $template); 
	} else { 
	    $leftcol = $message['leftcol']; 
	    $rightcol = $message['rightcol']; 
	    $b = str_replace('%leftcol%', $leftcol, $template); 
	    $physique = str_replace('%rightcol%', $rightcol, $b); 
	} 
	?> 
	<?php echo $physique; ?> 
	<button kind="button" onclick="self.shut();">shut window</button>

This file is considerably completely different than you’ve got seen, so I will stroll you thru it. First have have our regular heading. Subsequent we discover the present message we’re working with, and set just a few variables to the outcomes. Subsequent we discover the template we’re working with and set a variable equal to the physique. Subsequent, we’ve a conditional assertion that checks to see the variety of columns the template has. If it has we use the PHP operate str_replace to interchange the %content material% tag we’ve with our precise content material. In any other case, we first carry out a str_replace for the left column, after which on the results of that we carry out str_replace once more for the appropriate column. Now we’re able to proceed onto the front-end.

Step 9: The Entrance-Finish

We’ve got lastly reached the front-end! For this step and this step solely, I’ll assume the recordsdata we’re working with are within the root of the venture (so not the admin folder, the one containing it). We’re going to be working with 4 recordsdata right here, so go forward and create index.php, preferences.php, subscribe.php and a mode.css file. First open up our index.php file and paste:

# index.php 
	<?php 
	require_once 'admin/config.php'; 
	$newsletters = question("SELECT * FROM newsletters WHERE seen=1"); 
	$subscriptions = ''; 
	foreach($newsletters as $nl) { 
	    $subscriptions .= ' 
	    <enter kind="checkbox" title="publication['.$nl["id"].'][subscribe]" worth="true" '.$checked.'/> 
	    <label for="publication['.$nl["id"].']">'.$nl['name'].'</label> 
	    <enter kind="hidden" title="publication['.$nl["id"].'][nlid]" worth="'.$nl['id'].'" /><br /> 
	    '.$nl["description"].'<br /> 
	    '; 
	} 
	?> 
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> 
	<html xmlns="http://www.w3.org/1999/xhtml" > 
	    <head> 
	        <meta http-equiv="Content material-Sort" content material="textual content/html; charset=utf-8" /> 
 
	        <title>my newsletters</title> 
	        <!-- Stylesheets --> 
	        <hyperlink rel="stylesheet" href="type.css" kind="textual content/css" media="all" /> 
	    </head> 
	    <physique> 
	        <div id="header"> 
	            <h1>my newsletters</h1> 
	        </div> 
	        <div id="container"> 
	            <h3>Subscribe to our newsletters!</h3> 
	            <type motion="subscribe.php" technique="POST"> 
	                <p> 
	                    <label for="title">Identify:</label><br /> 
	                    <enter kind='textual content' title='title' class="textual content" />  
	                </p> 
	                <p> 
	                    <label for="e mail">Electronic mail</label><br /> 
	                    <enter kind="textual content" title="e mail" class="textual content" />  
	                </p> 
	                <p> 
	                    <sturdy>Newsletters:</sturdy><br /> 
	                    <?php echo $subscriptions; ?> 
	                </p> 
	                <p> 
	                    <enter kind='submit' worth='Subscribe »' /> 
	                    <enter kind='hidden' worth='1' title='submitted' />  
	                </p> 
	            </type> 
	        </div> 
	    </physique> 
	</html>

I will clarify the web page first after which we’ll get to the image so-far and the web page styling. Within the PHP part on the high we require our config.php file (now within the admin listing), then discover all of our publicly seen newsletters and create a test field array. You’ll discover that we aren’t dealing with the POSTed knowledge right here, and I selected to try this in our subscribe.php, and we’ll get to that, however first let’s type the web page. The web page ought to presently seem like:

First I added the 960.gs reset file like I did in our different stylesheet. Then I added the three following types to make the design seem like:

# type.css 
	#header, #container {width:65%;margin:0 auto; padding:0.7%;} 
	#container {background:#ccc;} 
	type enter.textual content {width:95%; font-size:16px;} 
	#message.success {border:stable 1px #349534; background:#C9FFCA;shade:#008000;}

So now that we’ve a clear and easy web page, we’re going to proceed on and work on our subscribe.php file. Go forward and open the file and paste:

# subscribe.php 
	<?php 
	require_once 'admin/config.php'; 
 
	if(isset($_POST['submitted'])) {  
	    $hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
	    $title = $_POST['name']; 
	    $e mail = $_POST['email']; 
 
	    $sql = "INSERT INTO subscribers (title, e mail) VALUES ('$title', '$e mail')"; 
	    $stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	    $stmt->shut; 
 
	    $sql = "SELECT id FROM subscribers WHERE title="$title" AND e mail="$e mail" LIMIT 1"; 
	    $subscriber = question($sql); 
	    $id = $subscriber[0]['id']; 
 
	    foreach($_POST['newsletter'] as $n) { 
	        if($n['subscribe'] == "true") { // If we wish to subscribe however the document doesnt exist 
	            $nlid = $n['nlid']; 
	            $sql = "INSERT INTO subscriptions (subscriber_id, newsletter_id) VALUES ('$id', '$nlid')"; 
	            $stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	            $stmt->shut; 
	        }  
	    } 
	} else {header('Location: index.php');} 
	?> 
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> 
	<html xmlns="http://www.w3.org/1999/xhtml" > 
	    <head> 
	        <meta http-equiv="Content material-Sort" content material="textual content/html; charset=utf-8" /> 
 
	        <title>my newsletters</title> 
	        <!-- Stylesheets --> 
	        <hyperlink rel="stylesheet" href="type.css" kind="textual content/css" media="all" /> 
	    </head> 
	    <physique> 
	        <div id="header"> 
	            <h1>my newsletters</h1> 
	        </div> 
	        <div id="container"> 
	            <h3>Thanks for subscribing!</h3> 
	        </div> 
	    </physique> 
	</html>

This web page could be very very similar to our edit subscribers web page, however no DELETE SQL queries occur right here. We merely test to ensure we’ve all POSTed knowledge. We then set just a few variables to our POSTed knowledge, after which create and carry out a SQL INSERT question so as to add the particular person to our subscribers desk. After which we carry out a SQL question to seek out that simply created subscriber (insert_id was not working this time for me). We then loop by means of the entire POSTed newsletters and test to see if we wish to subscribe to them, and carry out SQL INSERTs when wanted. If all goes to plan, you see a pleasant display screen just like the one beneath:

We’ve got on final web page right here to work on, and that’s the preferences.php file. That is the place a consumer can edit their e mail subscription. I’m going to separate the web page in two. First we’ve our PHP block:

# preferences.php 
	<?php 
	require_once 'admin/config.php'; 
 
	if(isset($_POST['submitted'])) {  
	    $id = (int) $_POST['id']; 
	    $hyperlink = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was an issue connecting to the database.'); 
	    $sql = "UPDATE subscribers SET title="".$_POST["name']."', e mail="".$_POST["email']."' WHERE id=$id"; 
	    $stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	    $stmt->shut; 
 
	    foreach($_POST['newsletter'] as $n) { 
	        if($n['exists'] != '1' && $n['subscribe'] == "true") { // If we wish to subscribe however the document doesnt exist 
	            $nlid = $n['nlid']; 
	            $sql = "INSERT INTO subscriptions (subscriber_id, newsletter_id) VALUES ('$id', '$nlid')"; 
	            $stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	            $stmt->shut; 
	        } elseif ($n['exists'] == '1' && $n['subscribe'] != "true") {// Else if we had an exits however we wish to unsubscribe 
	            $subid = $n['subid']; 
	            $sql = "DELETE FROM subscriptions WHERE id=$subid LIMIT 1"; 
	            $stmt = $hyperlink->question($sql) or die($hyperlink->error); 
	            $stmt->shut; 
	        } 
	    } 
	    $_SESSION['success'] = "Preferences saved.";  
	} 
 
	if(isset($_GET['email'])) {$e mail = $_GET['email']; $show = 'type';} else {$show = 'discover';} 
 
	$subscriber = question("SELECT * FROM subscribers WHERE e mail="$e mail""); 
	if($subscriber || $show == 'discover') { 
	    $id = $subscriber[0]['id']; 
	    $title = $subscriber[0]['name']; 
	    $e mail = $subscriber[0]['email']; 
	} else {header('Location: index.php');} 
 
	$newsletters = question("SELECT * FROM newsletters WHERE seen=1"); 
	$subs = question("SELECT * FROM subscriptions WHERE subscriber_id='".$id."'"); 
	$subscriptions = ''; 
	foreach($newsletters as $nl) { 
	    $s = false; 
	    $subid = ''; 
	    foreach($subs as $sub) { 
	        if($sub['newsletter_id'] == $nl['id']) {$s = true; $subid = $sub['id'];} 
	    } 
	    $checked = ($s == true) ? 'checked="checked"' : ''; 
	    $subscriptions .= ' 
	    <enter kind="checkbox" title="publication['.$nl["id"].'][subscribe]" worth="true" '.$checked.'/> 
	    <label for="publication['.$nl["id"].']">'.$nl['name'].'</label> 
	    <enter kind="hidden" title="publication['.$nl["id"].'][exists]" worth="'.$s.'" /> 
	    <enter kind="hidden" title="publication['.$nl["id"].'][nlid]" worth="'.$nl['id'].'" /> 
	    <enter kind="hidden" title="publication['.$nl["id"].'][subid]" worth="'.$subid.'" /><br /> 
	    '; 
	}  
	$message = error_messages(); 
	?>

On this block, so much is happening. First, we embrace our config file. Subsequent, we test for a POST, and if we’ve one, we replace our database. This portion is copied precisely from our subscribers_edit.php file so you possibly can look there for a bit extra clarification. Subsequent relying on if we’ve a get request, we set our variable (this variable is used within the HTML part of the web page). We then search for a subscriber with that e mail, and if one exists or we’re displaying the discover portion, we proceed, in any other case we’re redirected residence. Subsequent we discover all of our newsletters, and the entire subscriber’s subscriptions, after which create our checkbox type. The HTML portion appears like:

# preferences.php 
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> 
	<html xmlns="http://www.w3.org/1999/xhtml" > 
	    <head> 
	        <meta http-equiv="Content material-Sort" content material="textual content/html; charset=utf-8" /> 
 
	        <title>my newsletters - my preferences</title> 
	        <!-- Stylesheets --> 
	        <hyperlink rel="stylesheet" href="type.css" kind="textual content/css" media="all" /> 
	    </head> 
	    <physique> 
	        <div id="header"> 
	            <h1>my newsletters</h1> 
	        </div> 
	        <div id="container"> 
	            <h3>my preferences</h3> 
	            <?php if($show == 'type') {?> 
	            <type motion="preferences.php" technique="POST"> 
	                <p> 
	                    <label for="title">Identify:</label><br /> 
	                    <enter kind='textual content' title='title' class="textual content" worth="<?php echo $title; ?>"/>  
	                </p> 
	                <p> 
	                    <label for="e mail">Electronic mail</label><br /> 
	                    <enter kind="textual content" title="e mail" class="textual content" worth="<?php echo $e mail; ?>"/>  
	                </p> 
	                <p> 
	                    <sturdy>Newsletters:</sturdy><br /> 
	                    <?php echo $subscriptions; ?> 
	                </p> 
	                <p> 
	                    <enter kind='submit' worth='Save my preferences »' /> 
	                    <enter kind='hidden' worth='1' title='submitted' />  
	                    <enter kind='hidden' worth='<?php echo $id; ?>' title='id' /> 
	                </p> 
	            </type> 
	            <?php } else { ?> 
	            <?php echo $message; ?> 
	            <type motion='preferences.php' technique="get"> 
	                <p> 
	                    <label for="e mail">Electronic mail</label><br /> 
	                    <enter kind="textual content" title="e mail" class="textual content" />  
	                </p> 
	                <p> 
	                    <enter kind='submit' worth='Discover »' /> 
	                </p> 
 
	            </type> 
	            <?php } ?> 
	        </div> 
	    </physique> 
	</html>

In our HTML block we’ve two types and a few PHP to decide on which one to show. The highest type is the shape the consumer sees if a document within the database has been discovered. The second type is for getting into your e mail and having the system discover it. The second type appears like:

And the primary appears like:

And the second type after we saved our preferences:

Now that we’ve completed the front-end, we’ve one final step: sending the emails!

Step 10: Sending Messages

Our final step is to work on the web page to ship our message. We will probably be working within the admin listing, and just one file will probably be created. Go forward and create our messages_send.php file and place the next in it:

# admin/messages_send.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$title = "ship message"; 
	$id = (int) $_GET['id']; 
	$tab = 'mess'; 
 
	if(isset($_POST['submitted'])) {  
	    $question = "SELECT * FROM subscribers WHERE id=0 "; 
	    $emails = array(); 
	    foreach($_POST['newsletter'] as $n) { 
	        if($n['send'] == "true") { 
	            $nlid = $n['nlid']; 
	            $e = question("SELECT subscriber_id FROM subscriptions WHERE newsletter_id=$nlid"); 
	            foreach($e as $s) { 
	                $sqlids .= " OR id=".$s['subscriber_id']; 
	            } 
	            $question .= $sqlids; 
	        } 
	    } 
	    $subscribers = question($question); 
	    foreach($subscribers as $sub) { 
	        $emails[$sub['email']] = $sub['name']; 
	    } 
	    $from = array(FROM_EMAIL => FROM_NAME); 
	    // BODY RENDERING 
	    $mess = question("SELECT * FROM messages WHERE id=$id"); 
	    $message = $mess[0]; 
	    $topic = $message['subject']; 
	    $tid = $message['template_id']; 
 
	    $knowledge = question("SELECT physique FROM templates WHERE id=$tid LIMIT 1"); 
	    $template = $knowledge[0]['body']; 
 
	    if($message['rightcol'] == '') { 
	        $leftcol = $message['leftcol']; 
	        $physique = str_replace('%content material%', $leftcol, $template); 
	    } else { 
	        $leftcol = $message['leftcol']; 
	        $rightcol = $message['rightcol']; 
	        $b = str_replace('%leftcol%', $leftcol, $template); 
	        $physique = str_replace('%rightcol%', $rightcol, $b); 
	    } 
 
	    send_email_to_mass($from, $emails, $physique, $topic) or die('lol'); 
	    header('Location: index.php'); 
	} 
 
	$newsletters = question("SELECT * FROM newsletters"); 
	foreach($newsletters as $nl) { 
	    $nls .= ' 
	    <enter kind="hidden" title="publication['.$nl["id"].'][nlid]" worth="'.$nl['id'].'" /> 
	    <enter kind="checkbox" title="publication['.$nl["id"].'][send]" worth="true" '.$checked.'/> 
	    <label for="publication['.$nl["id"].']">'.$nl['name'].'</label> - '.$nl['description'].'<br /> 
	    '; 
	} 
	$mess = question("SELECT * FROM messages WHERE id=$id"); 
	$message = $mess[0]; 
	$topic = $message['subject']; 
 
	$content material = <<<EOF 
	<a href="messages_preview.php?id=$id" class="giant" goal="_new">preview »</a><br /> 
	<type motion='messages_send.php?id=$id' technique="POST"> 
	    <p> 
	        Topic: $topic<br /> 
	    </p> 
	    <p>Ship to:<br /> 
	        $nls 
	    </p> 
	    <p> 
	        <enter kind='submit' worth='Ship »' /> 
	        <enter kind='hidden' worth='1' title='submitted' /> 
	    </p> 
	</type> 
	EOF; 
	embrace 'structure.php'; ?>

The primary half we once more require our config, then make sure that the consumer is logged in, then our title, make sure that our id is an integer, after which set our tab. Subsequent we’ve our difficult submit block. First we arrange our base question, and operating simply that might return 0 information, which is sweet as a result of meaning no customers will probably be ship the publication. Subsequent we loop by means of each publication that we wish to ship to, and discover the entire subscriptions for that publication. We then create a string that will probably be appended to our unique SQL question in order that we are able to discover each subscriber. Now, we run that question and create an array the place the keys are the emails and the title is the worth, and this helps us use names when the consumer appears on the e mail of their mail software, displaying the TO: as their title. We subsequent discover the message we’re working with, and set the topic, message, and template id to variables. We then discover our template and set the physique to a variable. Then we use the identical code from the message preview to interchange the strings contained in the template the the elements of the message. Then we name our yet-to-be-created-function send_email_to_mass after which redirect residence.

Leaving our POST block, we create the identical checkbox checklist of newsletters so the admin can decide which one(s) he needs to ship the message to. Then we’ve a easy type that appears like:

Now, open up our lessons.php file and add the next operate:

# admin/lessons.php 
	// EMAIL 
	operate send_email_to_mass($from, $recipients, $physique, $topic) { 
	    require_once 'swift/lib/swift_required.php'; //require lib 
 
	    $transport = Swift_MailTransport::newInstance(); 
	    $mailer = Swift_Mailer::newInstance($transport) or die('Error creating mailer.'); 
	    $message = Swift_Message::newInstance($topic) 
	        ->setFrom($from) 
	        ->setTo($recipients) 
	        ->setBody($physique, 'textual content/html') or die('error right here.'); 
	    $outcome = $mailer->batchSend($message); 
 
	    return true; 
	}

So first, we’ve our operate declaration, and it expects 4 variables to be handed to it, from, recipients, physique, and topic. Subsequent we require the sqift_required.php file of our Swift Mailer Library. Subsequent we create a brand new Mail Transport (this makes use of the PHP mail operate, so it could be sending out of your native machine, for the documentation on the three transport varieties, see the documentation). Subsequent we create a mailer utilizing that transport. Then we create a brand new message from our topic, then set our from, to, and physique. Then we use the batch_send operate so that every recipient solely sees themselves on the e-mail, and nobody else.

There’s one probably draw back of doing it the way in which I’ve, and that’s in case you are sending many messages, the web page could take perpetually to load. An answer to tthis could be operating a Javascript AJAX request to ship each message, however I will not cowl that right here. Now that we’ve completed engaged on sending messages, we’re going to boost the house web page after which we will probably be finished!

Step 11: The Homepage

Once you load the admin index, the web page does not likely do a lot. I wish to have some ‘stats’ on our homepage, and we’ll lastly use the count_query operate. Open up the admin index file and alter it to seem like:

# admin/index.php 
	<?php 
	require_once 'config.php'; 
	login_required(); 
	$customers = count_query("SELECT COUNT(*) AS num FROM customers"); 
	$emails = count_query("SELECT COUNT(*) AS num FROM subscribers"); 
	$subs = count_query("SELECT COUNT(*) AS num FROM subscriptions"); 
	$nls = count_query("SELECT COUNT(*) AS num FROM newsletters"); 
	$mess = count_query("SELECT COUNT(*) AS num FROM messages"); 
	$temps = count_query("SELECT COUNT(*) AS num FROM templates"); 
	$title = "Dwelling!"; 
	$content material = <<<EOF 
	<h3>present stats</h3> 
	<p>$customers consumer registered</p> 
	<p>$emails subscribers</p> 
	<p>$subs publication subscriptions</p> 
	<p>$nls newsletters</p> 
	<p>$mess messages</p> 
	<p>$temps templates</p> 
	EOF; 
	embrace 'structure.php'; ?>

The web page could be very easy. We require our config, make sure that we’re logged in, then we carry out six depend queries, one for every of our tables after which output that. That is what the ultimate web page seem like:

Conclusion

Congratulations, you’ve got completed! I hope you loved the tutorial and it didn’t confuse you an excessive amount of 🙂

Construct a Publication System With PHP and MySQL

Step 1: Create the Utility Skeleton

Step 2: Utility Configuration

Step 3: Utility Structure

Step 4: Authentication

Step 5: Newsletters

Step 6: Templates

Step 7: Subscribers

Step 8: Messages

Step 9: The Entrance-Finish

Step 10: Sending Messages

Step 11: The Homepage

Conclusion

Full Screencast

40 Finest Blackletter and Gothic Fonts for Designers

PTZOptics Transfer SE Beginning at Underneath $1,000!!

25 Greatest Nonprofit Annual Report Template Designs for 2022

LEAVE A REPLY Cancel reply

Most Popular

Free Stock Videos – AI animation – sinister shadows

tips on how to enter DJI’s contest

TEKEVER and CRFS launch UAS with an ultra-sensitive RF receiver

Honeywell’s superior air mobility enterprise reaches $10 billion

Recent Comments

ABOUT US

POPULAR POSTS

Free Stock Videos – AI animation – sinister shadows

tips on how to enter DJI’s contest

TEKEVER and CRFS launch UAS with an ultra-sensitive RF receiver

POPULAR CATEGORY