473,768 Members | 3,681 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

PHP, MYSQL, WYSIWYG, DREAMWEAVER.. lost

164 New Member
Hi guys, I hope nobody is offended by my newbish question...

I have no SPECIFIC examples here. I am brand spanking new to all of the dynamic websites business. I am using DW cs3 and am doing pretty well as far as simple things are concerned (connecting to DB, creating RS, Repeat regions, Insert records, I am still working on the update and delete records... Its a slow process for me)

ANYWAYS... What I want to do is to be able to make a pretty simple site that has editable regions for the user to log in and edit. I know this can all be done in dreamweaver, but I what I am really after is for them to have a nice WYSIWYG editor that will pass off all the html value to the MYSQL field.

The first part I am stuck at is.. what type of field it needs to be set as in MySQL ( I am using phpmyadmin )
and second off I dont where exactly to find this solution.

I tried using tinymce ( I think this could work, but I couldnt figure it out, and could find NO documentation that was relevant to my situation.

I am open for ANY suggestions on this.

Thanks for any advice!
Dec 9 '07 #1
2 2481
clai83
41 New Member
Hi guys, I hope nobody is offended by my newbish question...

I have no SPECIFIC examples here. I am brand spanking new to all of the dynamic websites business. I am using DW cs3 and am doing pretty well as far as simple things are concerned (connecting to DB, creating RS, Repeat regions, Insert records, I am still working on the update and delete records... Its a slow process for me)

ANYWAYS... What I want to do is to be able to make a pretty simple site that has editable regions for the user to log in and edit. I know this can all be done in dreamweaver, but I what I am really after is for them to have a nice WYSIWYG editor that will pass off all the html value to the MYSQL field.

The first part I am stuck at is.. what type of field it needs to be set as in MySQL ( I am using phpmyadmin )
and second off I dont where exactly to find this solution.

I tried using tinymce ( I think this could work, but I couldnt figure it out, and could find NO documentation that was relevant to my situation.

I am open for ANY suggestions on this.

Thanks for any advice!

Anyhow, you should set the field to TEXT type, since you will probably have a lot of data entered into 1 field. Also make sure in your PHP code that you prepare the data before entering it into the database. You can use mysqli or PEAR; however, if you are using the older mysql functions then do not forget to use mysql_real_esca pe_string to escape all the " ' quotes and such in the html code you will be storing.

As for the other details maybe make a draft design of what exactly you want to do. Then it will be a lot easier to answer you question.
Dec 10 '07 #2
mbatestblrock
164 New Member
Anyhow, you should set the field to TEXT type, since you will probably have a lot of data entered into 1 field. Also make sure in your PHP code that you prepare the data before entering it into the database. You can use mysqli or PEAR; however, if you are using the older mysql functions then do not forget to use mysql_real_esca pe_string to escape all the " ' quotes and such in the html code you will be storing.

As for the other details maybe make a draft design of what exactly you want to do. Then it will be a lot easier to answer you question.

Sorry about not responding! I checked my control panel everyday, and I didnt see any updates.. I just figured nobody responded..

OKAY, so after searching forever, and dl a bunch of editors that didnt work the wanted them to, or I coudlnt figure out HOW to make them work. I finally got it, but it cost me dearly, 160 bones.

http://www.dmxzone.com/ShowDetail.asp? NewsId=6999

May not be the best thing out there. but it works perfectly for me..

All I wanted to happen was for the user to be able to login and edit a few text areas "about us" "news" you get the idea... A mini CMS if you will for them to visualy edit their sections if they wanted to.

So in case anyone was wondering that plugin works BEAUTIFULLY and I coudlnt be happier.

An thank you for the response. If anyone has anything they want to throw in, please do so. I am still open to suggestions.
Dec 11 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
3735
by: Dominique Javet | last post by:
Hello, I'm new to php and mysql and I use Dreamweaver MX 2004, so sorry for this "newbie" question... I've found no answer in the forum ... I've a date problem with my formular. In my mysql DB my filed "date" in table "experience" is like this: Y-m-d (2002-07-23). My fied`date` is date, NOT NULL with no default entry My form read well the date data depending the id, (pe. 30.02.2003), but when I submit a new date, I receive as result...
3
4487
by: Bert Sierra | last post by:
Hello -- I have what appears to be a simple PHP+MySQL query, but Dreamweaver consistently generates PHP code which won't parse. I've stared at the PHP code for several hours now, and I can't see the problem. Thanks in advance for any input you might have to the problem.
0
2288
by: Gregory | last post by:
I am using OS X and Dreamweaver MX. I am trying to make a connection to the MySQL Server from within Dreamweaver using the Applications panel and clicking on the "+". A window opens asking for: Connection Name: Apress MySQL Server: localhost User Name: apress Password: xxxxxx Database (Select): When I click select so the Dreamweaver can browse to the databases in MySQL the connection is not being made because Dreamweaver cannot find
4
3583
by: Teffy | last post by:
Folks who use both HTML-Kit and a WYSIWYG editor such as Dreamweaver: which tasks are done in which editor? I have been using HTML-Kit to edit HTML for some time, and while I am always learning new things about it, it feels comfortable. I downloaded a trial version of Dreamweaver and am trying to figure out how a lone amateur HTML coder such as myself might use Dreamweaver as an auxiliary tool. Thanks,
3
2238
by: Mel Smith | last post by:
HI Friends, I'm a newbie at html writing but am a computer programmer and use a great editor (The Semware Editor - TSE) for all my coding -- even building my own first web pages. I'd like your recommendation for a good wysiwyg HTML editor please. (either free or commercial). I want to build 'quick' web pages with a wysiwyg editor, then 'fine-tune'
6
4858
by: Marty U. | last post by:
I know this topic has been beat to death. However, I was sitting here trying to figure out what Microsoft Does when they develop an ASP.net for WYSIWYG functionality. Visual Studio's sucks to be honest. And I don't believe Microsoft has purchased Dreamweaver to do their designs. Are any of you using Visual Studio exclusively to develop your ASP.net apps? If so do you have any web sites that can demonstrate the result. I am really curious...
12
2650
by: Rex | last post by:
Hello, I am a PHP newbie looking for a PHP editor I can use with a WYSIWYG interface for HTML (e.g. like Dreamweaver or Frontpage). I'm running Vista. I am having installation problems with both Dreamweaver and FCKEditor, so those two seem out of the question, even though they do what I want. Basically, I'm looking to make changes mostly to the HTML content of a PHP website, and want to do so in the easiest way possible, preferably...
2
3219
by: aidanhaylock | last post by:
Morning, This one is really driving me insane. I am developing a site for a client who doesn't particularly want to move their hosting away from their current provider. The current host are absolutely terrible with their support (shocking for a large hosting company) and I am running out of ideas. I usually use Dreamweaver to it's full potential when developing sites but due to the fact that the host won't allow external access to the...
4
4245
by: Neil Jones | last post by:
Hello, I would like to create my own theme(s) for a couple of my own blog sites. I am hoping a few better themes could bring lot more readers. So far, I have stayed with the default wordpress theme (blue title). There are a lot of web sites I have seen that have very attractive themes. I am not a programmer and do not like to edit the php files or css files etc. My preference is to visually create the theme (font,images,background...
0
9407
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10176
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9964
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9845
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6656
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5285
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5425
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3933
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2808
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.