Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

Website Design Forum


You are currently viewing our Website Design Forum as a guest. Please register to participate.
Login



Freelance Jobs

Reply
Customer Updating site manually??
Old 03-07-2007, 01:23 PM Customer Updating site manually??
Novice Talker

Posts: 9
Trades: 0
Hi I have been asked to make a small web site for a school

They want to be able to update pages manually and add information as and when they need to

The only way I know is to edit the html files and re-upload them which a customer obviously cannot do.

Is there an easy way of doing this? Do I need to research into content management?

Thanks, Ben
ben1981 is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 03-07-2007, 03:43 PM Re: Customer Updating site manually??
Insensus's Avatar
Ultra Talker

Posts: 487
Name: Mark Stegeman
Location: Netherlands, Europe
Trades: 0
Yes.
You could use PHP's fopen(), fwrite() functions to edit the HTML files directly.
You could also store all the text in a database and get the pages to get the text from there. Then you can make a management script that alters the text in the database.
__________________
<?php ($helpfull>0)?$talkupation++ : '';?>
Insensus is offline
Reply With Quote
View Public Profile
 
Old 03-07-2007, 03:50 PM Re: Customer Updating site manually??
Novice Talker

Posts: 9
Trades: 0
thanks for that... so:

i need to learn php... store all my text in a mysql database

and write a form where the customer can edit the data and when they submit it sends the php commands to update the DB?

how would i make the page secure so only certain people could up load to the site?

i have been reading and joomla is mentiond a few places is that any use?
ben1981 is offline
Reply With Quote
View Public Profile
 
Old 03-07-2007, 05:01 PM Re: Customer Updating site manually??
Sydpix's Avatar
Drinker I Smoke

Posts: 424
Name: Denny
Location: In a can...
Trades: 0
Cutenews is a small CMs that would allow them to update themselves. You might have to purchase a license but its only like 35 bucks.

Other than that, you could create a CMS yourself. Or Joomla is also an alternative.

I guess it depends on how complicated / or not, you whant it to be.
__________________
.
Village Idiot

Sydpix is offline
Reply With Quote
View Public Profile Visit Sydpix's homepage!
 
Old 03-07-2007, 07:01 PM Re: Customer Updating site manually??
Novice Talker

Posts: 9
Trades: 0
i would like to do it the complicated way and learn how to code everything and set up the database

i guess i need to read up on php then

what interface would the customer see in order to edit their site?

how would they access the editing area?
ben1981 is offline
Reply With Quote
View Public Profile
 
Old 03-07-2007, 07:24 PM Re: Customer Updating site manually??
Sydpix's Avatar
Drinker I Smoke

Posts: 424
Name: Denny
Location: In a can...
Trades: 0
Just from an outside perspective. To create a custom CMS as a beginner and get it to work correctly without leaving your site susceptible to security vulnerabilities. You have a long road ahead of you.

A pre-made CMS however, (not that they are completely secure), would offer extended features that could take you quite a long time to create.

heck, with Joomla, you can completely edit the look of the site, have an extended application CMS and you don't have to leave the copyright at the bottom of the page. Just leave it in the header
__________________
.
Village Idiot

Sydpix is offline
Reply With Quote
View Public Profile Visit Sydpix's homepage!
 
Old 03-08-2007, 10:14 AM Re: Customer Updating site manually??
Novice Talker

Posts: 9
Trades: 0
hi - have found a tutorial on creating a basic cms system with php

i'm just writing the main systemcomponent.php to connect with the mysql database, which is:

<?php
class SystemComponent {
var $settings;
function getSettings() {
// System variables
$settings['siteDir'] = 'path to site?';
// Database variables
$settings['dbhost'] = 'sql4.my-php.net';
$settings['dbusername'] = 'my_394339';
$settings['dbpassword'] = 'password';
$settings['dbname'] = 'my_394339_test';
return $settings;
}
}
?>

what i need to know is what should i enter in the sitedir and path sections which i have highlighted red??? I'm not sure what the path to the mysql db is!!

the host gave me this info:
Addresses and Paths :

Your web site addresshttp://yoursite.my-php.netPath to your site/home/vol1/my-php.net//my_394999
any help appreciated
ben1981 is offline
Reply With Quote
View Public Profile
 
Old 03-08-2007, 12:41 PM Re: Customer Updating site manually??
Novice Talker

Posts: 9
Trades: 0
OK Sorted the last problem I having trouble adding a record to a customers database, can anyone see anything wrong with this code???

<?php
require_once('DbConnector.php');
if ($HTTP_POST_VARS){
$connector = new DbConnector();
$insertQuery = "INSERT INTO customers
(firstname,lastname,address)
VALUES
("."'".$HTTP_POST_VARS['firstname']."', "."'".$HTTP_POST_VARS['lastname']."',
".$HTTP_POST_VARS['address']."')";
if ($result = $connector->query($insertQuery)){
echo '<center><b>Article added to the database</b></center><br>';
}else{
exit('<center>Sorry, there was an error saving to the database</center>');
}
}
?>

I keep getting the Sorry... message
ben1981 is offline
Reply With Quote
View Public Profile
 
Old 03-09-2007, 03:22 PM Re: Customer Updating site manually??
Average Talker

Posts: 27
Trades: 1
You could use DotNetNuke or some other Content Management system. DDN is very easy to set up.
__________________
PJDev

Please login or register to view this content. Registration is FREE
PJDev is offline
Reply With Quote
View Public Profile
 
Old 03-09-2007, 03:51 PM Re: Customer Updating site manually??
Insensus's Avatar
Ultra Talker

Posts: 487
Name: Mark Stegeman
Location: Netherlands, Europe
Trades: 0
I'd try it like this:
PHP Code:
<?php
require_once('DbConnector.php');
if (
$_POST){
$connector = new DbConnector();
$insertQuery "INSERT INTO customers (firstname,lastname,address) VALUES ('".$_POST['firstname']."', '".$_POST['lastname']."', '".$_POST['address']."')";
if (
$result $connector->query($insertQuery)){
echo 
'<center><b>Article added to the database</b></center><br>';
}else{
exit(
'<center>Sorry, there was an error saving to the database</center>');
}
}
?>
__________________
<?php ($helpfull>0)?$talkupation++ : '';?>
Insensus is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Customer Updating site manually??
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.29926 seconds with 12 queries