Basic News

+ 0 likes

Please Register to submit score.

Average Score	6.5
Scores Submitted	2
Date Added	Jan 12, 2006
Last Updated	Jan 12, 2006
Tags	news

Introduction

Create all three files, input the php code into each file that is listed. Then change the database info in ALL three files.

$host = "localhost";

$user = "your-username";

$pass = "your-password";

$dbname = "your-username_your-database";

DO NOT edit $conn = mysql_connect($host, $user, $pass);

<BR><BR>
Found an error? Leave a comment :-)
<BR>
Feel free to edit or add some addons, However I'm not gonna help with ANY addons.

Grab the Code

FIRST Creating table:
File name: 'createtable.php'

<?php
$host = "localhost";
$user = "your-username";
$pass = "your-password";
$dbname = "your-username_your-database";

$conn = mysql_connect($host, $user, $pass);
mysql_select_db($dbname);

mysql_query("DROP TABLE news"); /* ADDED: just in case */

$query = "CREATE TABLE `news` (`id` int(10) unsigned NOT NULL auto_increment, `news` TEXT NOT NULL default '', PRIMARY KEY (`id`))";

mysql_query($query);
mysql_close($conn);
?>

Run it once!

SECOND Process Page:
File name: 'index.php'

<?php
/* isset() is used to know if the variable exists */
/* $_POST array is created/updated after a submit */
if (isset($_POST['News']))
{
$host = "localhost";
$user = "your-username";
$pass = "your-password";
$dbname = "your-username_your-database";

$conn = mysql_connect($host, $user, $pass);
mysql_select_db($dbname);

$query = "INSERT !NTO news VALUES (NULL, '".$_POST['News']."')";
mysql_query($query) or die ("formInput error: $query");
mysql_close($conn);
}
?>

<html>
<head>
<title>Index</title>
</head>

<body>
<h1>Index</h1>
<form name="New" action="./index.php" method="post">
<textarea name="News" cols="45" rows="10"></textarea>
<br><input type="submit" value="Submit">
</body>
</html>

THIRD News Section:
File name: 'news.php'

<?php
$host = "localhost";
$user = "your-username";
$pass = "your-password";
$dbname = "your-username_your-database";

$conn = mysql_connect($host, $user, $pass);
mysql_select_db($dbname);

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

$i = 0;
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$return[$i] = $row["news"];
$i++;
}

mysql_free_result($result);
mysql_close($conn);
?>

<html>
<head>
<title>News Section</title>
</head>

<body>
<h1>News Section</h1>
<?php
for ($i = 0; $i < count($return); $i++)
{
?>
<p><?= $return[$i] ?></p>
<?php
}
?>
</body>
</html>

Comments

(3) RSS

Go to Bottom

Earl

Comments: 10

PHP Snippet: Basic News
Posted on Jan 15, 2006 1:10 pm

no comments? :(

BackoffJackson

Comments: 56

PHP Snippet: Basic News
Posted on Jan 23, 2007 8:34 pm

Yes, no comments.

Earl

Comments: 10

PHP Snippet: Basic News
Posted on Jan 24, 2007 4:40 pm

yes, no comments indeed.

Basic News

Introduction

Grab the Code

Comments

Earl

My Snippet Tags

Contact

Sponsors

		Student Boston, MA
Last seen: Jul 15, 2007 Profile \| Website Snippets (1) Comments Received (3) Comments Submitted (10) Forum Posts (15)