//code for yourditor.php
<?php
//This section should deal with the MagicQuotes and slashes
function nukeMagicQuotes() {
if (get_magic_quotes_gpc()) {
function stripslashes_deep($value) {
$value = is_array($value) ? array_map('stripslashes_deep', $value) : stripslashes($value);
return $value;
}
$_POST = array_map('stripslashes_deep', $_POST);
$_GET = array_map('stripslashes_deep', $_GET);
$_COOKIE = array_map('stripslashes_deep', $_COOKIE);
}
}
?>
<?php nukeMagicQuotes(); ?>
<?php
// Connect to the database
$cnx = mysql_connect("localhost", "root", "pavan")
OR die("Unable to connect to database!");
mysql_select_db("fck_data ", $cnx);
if ($_POST['submit_form'] == 1) {
// Save to the database.
$data = mysql_real_escape_string(trim($_POST['fcktext']));
$res = mysql_query("UPDATE fck_data SET data = '".$data."' WHERE id = 1");
if (!$res)
die("Error saving the record! Mysql said: ".mysql_error());
// Redirect to self to get rid of the POST
header("Location: youreditor.php");
}
include_once "../FCKeditor/fckeditor.php";
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Test FCKeditor</title>
</head>
<body>
<h1>Test FCKeditor</h1>
<form action="youreditor.php" method="post">
<?php
// Get data from the database
$query = mysql_query("SELECT data FROM fck_data WHERE id = 1");
$data = mysql_fetch_array($query);
// Configure and output editor
$oFCKeditor = new FCKeditor('fcktext');
$oFCKeditor->BasePath = "../FCKeditor/";
$oFCKeditor->Value = $data["data"];
$oFCKeditor->Width = 540;
$oFCKeditor->Height = 400;
echo $oFCKeditor->CreateHtml();
?>
<br />
<input type="hidden" name="submit_form" value="1" />
<input type="submit" value="Save Form" />
</form>
</body>
</html>
<?php
// Close the database connection
mysql_close($cnx);
?>
//code for yourpage.php
<?php function nukeMagicQuotes() {
if (get_magic_quotes_gpc()) {
function stripslashes_deep($value) {
$value = is_array($value) ? array_map('stripslashes_deep', $value) : stripslashes($value);
return $value;
}
$_POST = array_map('stripslashes_deep', $_POST);
$_GET = array_map('stripslashes_deep', $_GET);
$_COOKIE = array_map('stripslashes_deep', $_COOKIE);
}
}
?>
<?php nukeMagicQuotes(); ?>
<?php
// Connect to the database
$cnx = mysql_connect("localhost", "root", "pavan");
if (!$cnx) {
die("Unable to connect to database!");
}
// Select your database
mysql_select_db("fck_data", $cnx);
// Get data from the database
$query = mysql_query("SELECT data FROM fck_data WHERE id = 1");
$data = mysql_fetch_array($query);
?>
<!-- This is where the content from your database is displayed
we are telling the database to display the content from the field in
the database called data -->
<div>
<?php echo $data["data"]; ?>
</div>
veerpavan 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.