Is there any fee/affordable easy-to-use It software that allows me to manage/publish data info into a website?

Question

It has to run on Windows, and be able to be updated from the web. I want to publish a website with restaurant listings with pix and info, and maybe votes. I have fairly good knowledge of HTML, and graphic editing, but i fail miserabily in the database programming part of it. My host server runs on UNIX, so i preferably would like something PHP/MySQL related, but are open to other productive solutions.

I know Dreamweaver, but don't find it easy to work with for creating database tables.

Answer 1

Try Joomla, it is a content management system(CMS) based on php and mysql.

It has a simple templating system, so if you know css/html it should be easy to create the look how you want it, if not, there are thousands of templates available.

It has a web-based admin backend, so is really quick and easy to update.

There are hundreds of components you can plug in such as listings, calenders, maps and so on.

There is a massive user base with really good forums, if you get stuck you normally get answered within a couple of hours.

Best of all, it is open source and free.

Answer 2

For an investment I would suggest you buy dreamweaver from adobe. http://www.adobe.com/products/dreamweaver/
It is an extraordinary software, although a little expensive, which is used by companies all around the world to make professional sites. It will publish your site to the web using a server and even predict what code you are typing and therefore do most of the work for you. Or you can just drag-and-drop images and text boxes onto a web page to save time and energy. Also is fully compatible with flash enabling you to create fully interactive animated sites.
Although expensive it is the best software of it's kind and has it's own customer care for help and tips, lots of user created forums with tips, hundreds of downloadable add-ons and also allows you to easily update the website; useful if your menu changes regularly.

All in all a great investment considering many professional websites are made with it.

Answer 3

Trying to use a database (MySQL) with any front end program (Dreamweaver) is a waste of time!
When it comes to PhP/MySQL, the notebook is your best editor.
To learn PhP, your best bet is www.php.net (the official site of PhP), with a huge amount of examples on every function.
For MySQL, you probably have a server running Cpanel, go there and run PhPmySQL: a lot of good examples there too.
Mostly you need to know
- Creating (you can do it manually from CPanel)
- INSERT (to add a row)
- DELETE (to remove a row)
- SELECT (get one or more rows)
Here are sone examples:

function dbconnect()
{
$link = mysql_connect("hostname", "username", "password") or die(" Could not connect : " . mysql_error());
mysql_select_db("tinmando_store") or die("Could not select database");
return($link);
}
function makeusers()
{
$link = dbconnect();
$tablename = "users";
echo ("Making Table " . $tablename . "
");
$cmdd = "DROP TABLE IF EXISTS " . $tablename;
mysql_query($cmdd) or die("Query failed : " . mysql_error());
$cmdd = "CREATE TABLE `" . $tablename . "` (
`user` VARCHAR(30) NOT NULL ,
`pwd` VARCHAR(32) NOT NULL,
`lvl` VARCHAR(2) NOT NULL,
`code` VARCHAR(50) NOT NULL
) TYPE = MYISAM" ;
mysql_query($cmdd) or die("Query failed : " . mysql_error());
echo ("Done. Table " . $tablename . " Created
");
mysql_close($link);
}
function adduser($lst)
{
$link = dbconnect();
$txt = 'VALUES ("'.$lst[0].'","'.$lst[1].'","'.$lst[2].'","'.$lst[3].'")';
$sql = 'INSERT INTO `users` ( `user` , `pwd` , `lvl`, `code`) ' . $txt;
$result = mysql_query($sql) or die("Query failed : " . mysql_error());
mysql_close($link);
}
function deluser($uname)
{
$link = dbconnect();
$sql = "DELETE FROM `users` WHERE `user`='".$uname."' LIMIT 1";
$result = mysql_query($sql) or die("Query failed : " . mysql_error());
mysql_close($link);
}
function getuser($uname)
{
$link = dbconnect();
$query = "SELECT * FROM `users` WHERE `user`='".$uname."' LIMIT 1";
$list = mysql_query($query) or die("Query failed : " . mysql_error());
$lst = mysql_fetch_array($list);
mysql_free_result($list);
mysql_close($link);
return($lst);
}
?>

Answer 4

try the sourceforge.net website