starter — Mon, 29 Mar 2004 17:51:31 +0000

hey thx all for your replys, i ll give it a go, however i ve spoke to the my client who does have dreamweaver already installed, they will update it themselves.

I have just been playing around with bloggers and like some feedbacks on this , seems pretty easy to use .

Greg K — Tue, 23 Mar 2004 17:42:00 +0000

<?php
$dbh=mysql_connect (\"localhost\", \"username\", \"password\") ...
?>

localhost is the name of the server where the mySQL is running

username is the username used to access the mySQL server

password is the password used to access teh mySQL server

<?php
mysql_select_db (\"database_table\");
?>

database_table is the name of the actual database to use on the server

<?php
$sql = mysql_query(\"INSERT INTO data SET\" ...
$sql = mysql_query(\"SELECT * FROM data ORDER BY id DESC\");
?>

data in both of these lines is the table that you are accessing within the database named in the mysql_select_db() command.

-Greg

mjs416 — Tue, 23 Mar 2004 14:20:14 +0000

That script looks good, Eskater. I am a php newbie (learning as I'm going) and I curious about the syntax of your script.

I dont see where you declare what databse and/or table you are connecting to; am I looking at something wrong?

Also, the GET or POST methods should work the same, correct?

brady.k — Mon, 22 Mar 2004 20:49:25 +0000

If you want to make it alot more complex than it has to be, yes...

do this
---Your Form Submission Script---

<?php
$dbh=mysql_connect (\"localhost\", \"username\", \"password\") or die ('Cannot connect to the database because: ' . mysql_error());
mysql_select_db (\"database_table\");

$sql = mysql_query(\"INSERT INTO data SET\"
                    .\" header='$header'\"
                    .\", body='$body'\");
if (!$sql) { echo mysql_error(); }

mysql_close($dbh);

header(\"Location: http://www.website.com/updated.html\");
    
?>

---The script on the page that needs updating or added to (this does added to, not replacing ---

<?php
  

$dbh=mysql_connect (\"localhost\", \"username\", \"password\") or die ('Cannot connect to the database because: ' . mysql_error());
mysql_select_db (\"database_table\");

$sql = mysql_query(\"SELECT * FROM data ORDER BY id DESC\");
// find out what the error is
if (!$sql) { echo mysql_error(); }

while ($qry = mysql_fetch_array($sql)) {
    $header = $qry[header];
    $body = $qry[body];

echo<<<DETAILS
<p class=\"title\">$header</p>
<p>&nbsp;&nbsp;&nbsp;$body</p>
<p class=\"line\">---------------</p>
DETAILS;
}  

mysql_close($dbh);
?>

That's the exact code I use on one of my sites to display info from a dB...modify it where needed, but it works like a charm.

starter — Mon, 22 Mar 2004 13:15:39 +0000

thx all for your responses, i thought that there just might be an easier way and i didnt know about it.

Question! , can i reconfigure some of these guess books scripts and utilise it to what i want to do , it follows the same logic right?

m3rajk — Sun, 21 Mar 2004 20:12:43 +0000

so umm.. short of making one i dunno what to say, i don't think there is anything you can do for a client aside form make somethign to make an easy submit to you to have you updateit witha faster response time

m3rajk — Sun, 21 Mar 2004 20:09:24 +0000

lol. once i finish the updates to my site that's what i'm going back to
a friend wants a webpage she can update easier
i'mcreating a gui csss and tsuch for her so she can use on her site (she has a forums so i know she has php and sql, so that's gonna drive ir)

brady.k — Sun, 21 Mar 2004 19:02:58 +0000

I have run into a similar problem...and I created a different form for each page that needs content change, which is accessible via password and username...they go in and change what they need to when they need to. PHP/HTML/MySQL

s0da — Sun, 21 Mar 2004 16:51:24 +0000

seems like you need a template system in place. THEN you can easily manipulate the files from a form. but i guess that would not be a simple task.

Suzanne — Sun, 21 Mar 2004 06:22:34 +0000

The easiest way is through a web-interface or using the default editing of a text file in an ftp application. But that's perhaps not the easiest for your client?