Comments Script

erfg1

I successfully created a MySQL + PHP script that adds news items.

$db=mysql_connect ("localhost", "USERNAME_HERE", "PASSWORD_HERE") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("MY_DATABASE_HERE",$db);

if ($id) {

// editing so select a record

$sql = "SELECT * FROM news WHERE id=$id";

$result = mysql_query($sql);

$myrow = mysql_fetch_array($result);

$id = $myrow["id"];

}

$result = mysql_query("SELECT * FROM news",$db);

while ($myrow = mysql_fetch_array($result)) {

printf(" ");

printf("%s \n", $myrow["topic"]);

printf("Posted by: %s \n", $myrow["name"]);

printf("%s \n", $myrow["content"]);

printf("%s \n", $myrow["comment_title"]);

printf("- <a href=comment_script.php?id=%s target=_blank>Add Comment</a><-- DOESNT WORK YET! \n", $myrow["id"]);

}

At the moment this script just displays the news, but it wont add the comments. If I made a different database, how would I put both the news and a new database together to display new ones. Like if it displays 1 news item, how will it display all the comments in 1 news item? I need some huge help here, I am close to complete noob. I just know a few simple things.

harmor

If you mean how can you get comments on a specific news title then try this.

Let's say your "news" table what the following fields
newsid, news_title, news_text

Let's say your "comments" table had the following fields
commentid, newsid, comment_text

Notice "newsid" highlighted in orange. This value will be the same as the newsid on your news table.

You're sql query should look like. goes in news.php (for example)

(1-0) //for reference

$query = mysql_query("SELECT * FROM comments WHERE newsid='$_GET[newsid]' ")or die(mysql_error());
   $comments = mysql_fetch_array($query);

What that is doing is getting the "newsid" which can be passed through the address bar.

So lets say you did a while loop and displayed all your news titles in links.
<a href='news.php?newsid=1'>link for row 1</a>

Notice "newsid=1" This will pass value "1" to the query (1-0)
So let's say you click on the link. You'll be sent to "news.php" and you should be able to see comments for that news entry.

I hope this helps a little.
I'll post back and criticize your output method ( printf() ) .

harmor

I'll rewrite your output method into something easier to read and type.

I had no idea what you were doing with "%s"

echo "<br />
<font size=6><b>".$myrow['topic']."</b></font><br /> 
<font size=2><b>Posted by: ".$myrow['name']."</b></font><br /><br /> 
".$myrow['content']."<br /> 
<font size=3><b>".$myrow['comment_title']."</b></font><br> 
<a href=comment_script.php?id=$myrow[id] target=_blank><font size=2>Add Comment</font></a>";

erfg1

I have a few more questions. First of all, I can't auto_increment more then 1. So how do I auto_increment 2? Also I see where your coming with this, it's kind of like a relational database in Access.

Also, is it possible to put php codes into C++? If so, would the codes look exactly the same, or completely different?

harmor

To auto-increment another field in the database you'll need to do it through php.
So let's say you had the coloumn "views" and you would like this number to go up everytime a person views the page.

At the top of the "news.php" file you should be calling the database.

What you'll need to do is get the "views" field and add 1 to it an re-insert it into the database.

$views = $myrow['views'] + 1;

$query = "UPDATE news 
	 SET 
	 views = '$views'
	 WHERE newsid='".$myrow['newsid']."'";
     mysql_query($query);
     mysql_close();

What this is doing is taking the value that's already in the database and adding one to it.
Then I am assigning that value the $views and placing it into the update query.

I am 99.9% sure that you cannot use php coding in C++.

I am planning on making something like this today.
I'll show you the source once I'm done.