FCK Editor + MYSQL Database

Keewee6

has anyone ever connected fck editor to mysql database - any joy

Unless I'm missing the point of the query, the usual process is to process the contents of the FCKEditor and submit it to the database using a server side language. If memory serves, there are good examples for all the common ones supplied with the package.

Keewee6

that is probably more like an tutorials on how do to this

that is probably more like an tutorials on how do to this

Do you have a specific question?

Keewee6

are there any good tutorials out the on how to connect fckeditor to a mysql database ?

thanks

As I said in first post, you don't connect FCKeditor to a mysql database. You take the output of FCKeditor and send it to a server side language. The included examples are simple. You then use the server side language to write to the database as usual.

If you dont know server side programming, you'll have to learn that first. w3schools.com is the best place to start. Look at the PHP and SQL tuts.

jhegarty

Just drop the output from FCK into a blob in mysql.

If you don't know sql then w3schools (as SBS said) is a great site to start with.

DrivingInfo

First you will need to be able to send the information from a form to your database.

You will have a textbox in that form.

You will need the FCK file/files in you roof folder.

Then you need to link the FCK editer to the textbox

I think this is what you want to know...

Keewee6

DrivingInfo wrote: »

First you will need to be able to send the information from a form to your database.

You will have a textbox in that form.

You will need the FCK file/files in you roof folder.

Then you need to link the FCK editer to the textbox

I think this is what you want to know...

where would i get the code to connect the form to the FCK editor

oeb

Keewee6 wrote: »

where would i get the code to connect the form to the FCK editor

The FCK editor is part of the form. There is documentation included with FCK on how to display it on your page.

Also note, FCK has been replaced with CK

Keewee6

do i connect ckeditor to mysql database

DrivingInfo

Keewee6 wrote: »

do i connect ckeditor to mysql database

I found the best way to get your head around this is;

1, create your datebase
2, create your form (with your normal fields and text boxes)
Download FCK Editer
These files are put into you root folder in you hosting server (check with your hosting company as they may have them already)

Then read the install instructions.

NOTE: Get your standard form working before you try to add the Editor

DrivingInfo

Keewee6 wrote: »

do i connect ckeditor to mysql database

NO NO NO. Please do not ask this question again as you do not connect the FCK/CK Editor to your database.

What are you using to build your website/form?

daymobrew

KeeWee6 - please tell us, in great detail, what exactly you are trying to achieve.
What data do you have? Do you have a db? Do you have a web site?

Placebo

Keewee6 wrote: »

do i connect ckeditor to mysql database

sorry i have to LOL at this. hhaaahhhaahh
dont mean to be rude to any end user, we all start some where but you've asked this like 10 times?

Keewee6

DrivingInfo wrote: »

First you will need to be able to send the information from a form to your database.

You will have a textbox in that form.

You will need the FCK file/files in you roof folder.

Then you need to link the FCK editer to the textbox

I think this is what you want to know...

i know im not great at this sorry thanks for your help so far - how do i link to editor to the textbox

DrivingInfo

Keewee6 wrote: »

i know im not great at this sorry thanks for your help so far - how do i link to editor to the textbox

Have you got a database?

Keewee6

DrivingInfo wrote: »

Have you got a database?

yes

DrivingInfo

Keewee6 wrote: »

yes

Good

Do you have the form?

Keewee6

yep

DrivingInfo

Keewee6 wrote: »

yep

Ok sorry about this but do you have the editor downloaded and sitting within your root folder

Keewee6

DrivingInfo wrote: »

Ok sorry about this but do you have the editor downloaded and sitting within your root folder

no problem my fault cant get the hang of this - yes its in my public folder

DrivingInfo

Keewee6 wrote: »

no problem my fault cant get the hang of this - yes its in my public folder

Do you know what a SQL query is?

Keewee6

DrivingInfo wrote: »

Do you know what a SQL query is?

yep

DrivingInfo

Keewee6 wrote: »

yep

GOOD,

When you are sending the information to the database the SQL has a insert query, ye?

Do you know the name of the field you want the add the editor too?

Keewee6

DrivingInfo wrote: »

GOOD,

When you are sending the information to the database the SQL has a insert query, ye?

Do you know the name of the field you want the add the editor too?

yes

DrivingInfo

Keewee6 wrote: »

yes

OK, Now

what you are doing is!
Adding the include to the file, this will tell you page you are going to need the editor
[PHP]<?php
include_once("fckeditor/fckeditor.php") ;// this could be ckeditor/ckeditor.php
?>[/PHP]

Then going from top to bottom find the field name in the SQL, will look something like this
[PHP]GetSQLValueString($_POST, "text"),[/PHP]
and change the name to the name of what you want to call the editor textbox
call it 'Keewee6' not 'Business_Name'

Then go to where the box is at the moment again it should be something like this:
[HTML]<input name="Business_Name" type="text" class="TeleT" id="Business_Name" size="40" />[/HTML]

And replace with something like this.

[PHP]<?php
$oFCKeditor = new FCKeditor('Keewee6') ; // insert into the $_POST["FCKeditor1"] in the SQL Query at top of page
$oFCKeditor->BasePath = 'fckeditor/' ;
$oFCKeditor->ToolbarSet = 'EditOnly'; // 'CMS_Text_Update' or 'Default' or 'Basic' or 'EditOnly'
$oFCKeditor->Height ='200'; // How to size
$oFCKeditor->Width ='450'; // How to size
$oFCKeditor->Value = 'what ever you want!' ; // Default text in data box on you html page
$oFCKeditor->Create() ;
?>[/PHP]

NOTE: you will get the instructions from the readme file in the editor if i remember correctly.

I hope this helps you.

DrivingInfo

Keewee6 how did you get on?

Keewee6

just workin on it now

Keewee6

Parse error: syntax error, unexpected ',' in /home/squarebar/domains/nixysthesquarebar.com/public_html/testcms.php on line 30

got this

Placebo

whats on line 30 then ? no ones psychic :mad: