Showing posts with label how to create cms. Show all posts
Showing posts with label how to create cms. Show all posts

Thursday 11 September 2014

create cms blog using ckeditor and save selected data of dropdown value in php

          Today we will learn how to create cms using ckeditor and how to save selected data of dropdown value in php?How To: Insert Data into MySQL Database Using Drop Down Box in PHP?How to save values from Dynamic Drop Down List into MySQL database?

simple example

<select name="color">
<option value="Red">Red</option>
<option value="Green">Green</option>
<option value="Black">Black</option>
<option value="White">White</option>
</select>

<input type="submit" name="submit" />
 
<?php
if(isset($_POST['submit']))
{
$name=$_POST['name'];
$color=$_POST['color'];
if($name!="" && $color!="")
{
$query=mysql_query("insert into tb(color) values('$color')");
if($query)
{
echo "Updated successfully!";
}
 
color is table attribute give its TYPE varchar(25).
 
----------------------------------------------------------
 
HOME.php
 
<code>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
  <title>Test Page </title >
  <meta http-equiv="content-type" content="text/html; charset=utf-8"/ >
  <script type="text/javascript" src="ckeditor/ckeditor.js"></script>
</head>
<body>

<form id="form1" name="form1" method="post" action="add.php">
<table width="958" height="372">
  <tr>
    <td width="69">Name:</td>
    <td width="608"><input name="textfield" type="text" id="textfield" size="40" /></td>
  </tr>


<tr>
    <td width="69">Email:</td>
    <td width="608"><input name="te" type="text" id="te" size="40" /></td>
  </tr>


  <tr>
    <td>Section:</td>
    <td><select name="select" id="select">
     <option selected="selected" value="MALE">Male</option>
  <option selected="" value="FEMAIL">FEMAIL</option>
    </select></td>
  </tr>
  <tr>
    <td>Subject:</td>
    <td><select name="select2" id="select2">
<option selected="selected" value="MA">Ma</option>
  <option selected="" value="FE">FE</option>
    </select></td>
  </tr>
  <tr>
    <td height="53">Description</td>
    <td><textarea name="textarea" id="textarea" cols="45" rows="3"></textarea></td>
  </tr>
  <tr>
    <td>Upload</td>
    <td>
      <label for="fileField"></label>
      <input name="fileField" type="file" id="fileField" size="40" />
    </td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>
      <label for="textarea2"></label>
      <textarea class="ckeditor" cols="20" id="editor1" name="editor1" rows="10"></textarea>
</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>
      <input type="submit" name="button2" id="button2" value="Upload" />
    </td>
  </tr>
</table>

</form>
</body>
</html>

 
 
 
</code> 

-----------------------------
 add.php

<?php
include("mysql.php");

if(isset($_POST["button2"]))
{
$sql="INSERT INTO cktext (papername,email,subject,section,description,upload,uploadtext)
VALUES
('$_POST[textfield]','$_POST[te]','$_POST[select2]',
'$_POST[select]',
'$_POST[textarea]','$_POST[fileField]','$_POST[editor1]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
  else
  {
echo "Question paper uploaded Successfully</br> YOUR TEXT IS";
$data = mysql_query("SELECT * FROM cktext") or die(mysql_error()); Print "<table border cellpadding=3>"; 

while($row = mysql_fetch_array( $data ))
 {
 Print "<tr>"; Print "<th>Name:</th> <td>".$row['papername'] . "</td></tr>";

Print "<tr>"; Print "<th>Blog:</th> <td>".$row['uploadtext'] . " </td></tr>";


echo "--------------------------------<br>";
echo "EMAIL ID :{$row['email']}  <br> ".
         "description : {$row['description']} <br> ".
         "upload : {$row['upload']} <br> ".
         "--------------------------------<br>";

 } // end of while
  
Print "</table>";
  
}//else

 }//first if isset


?>


---------------------------------
mysql.php

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("ckeditor",$con);
?>
----------------------------------------
IMP NOTE :- In database subject,section will be of varchar type for words or char.
 
DOWNLOAD CODE HERE