Jump to content

[SOLVED] str_replace


dropfaith

Recommended Posts

So im trying to build a simple blog site where users submit storys and such to my mysql database and im wondering how to make it so if the user hits enter or there is a blank line it inserts the proper html </p><p> to create the paragraghs on the entry

 

full code for form and insert is below

 

 

<?php
    $u = $_SESSION['userTitle'];
    $uid = $_SESSION['loginid'];

$query = "SELECT * FROM login WHERE loginid = '$uid'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
// if records present
if (mysql_num_rows($result) > 0)
{
// iterate through resultset
// print article titles
while($row = mysql_fetch_object($result))
{
?>
<input type="hidden" name="Author" value="<? echo $row->username; ?>">
<input type="hidden" name="loginid" value="<? echo $row->loginid; ?>">

<?
}
}
// if no records present
// display message
else
{
?>

<?
}
// close database connection
mysql_close($connection);?>

						<p>
							<label>Title</label>
							<input type=text name="Title" size="28">
						</p>
						<p>
							<label>Date</label>
							<input type=text name="Date" size="28">
						</p>

						<p>
							<label>Genre</label>

<select name="Genre">
<?
			// includes
			include("../template/conf.php");
			// open database connection
			$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
			// select database
			mysql_select_db($db) or die ("Unable to select database!");
			// generate and execute query
			$query = "SELECT * FROM genre";
			$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
			// if records present
			if (mysql_num_rows($result) > 0)
			{
			// iterate through resultset
			// print article titles
			while($row = mysql_fetch_object($result))
			{
			?>
			<option value="<? echo $row->Genre; ?>"><? echo $row->Genre; ?>
			<?
			}
			}
			// if no records present
			// display message
else
{
			?>
			<li>No users</li>
			<?
			}
			// close database connection
mysql_close($connection);
			?>				





</select>

						</p>

						<p>
							<label>Article</label>
							</p><p><textarea name="Article" cols="50" rows="37"></textarea>
						</p>
						<p>









							<input type="Submit" name="submit" value="Add">
						</p>

				</form>
			</fieldset>


<?

}

else

{

   // includes

    include("../template/conf.php");

    include("../template/functions.php");



    // set up error list array

    $errorList = array();

    $count = 0;

    

    // validate text input fields
    $Author = mysql_escape_string($_POST['Author']);
    $loginid = mysql_escape_string($_POST['loginid']);
    $Title = mysql_escape_string($_POST['Title']);
    $Date = mysql_escape_string($_POST['Date']);
    $Genre = mysql_escape_string($_POST['Genre']);
    $Article = mysql_escape_string($_POST['Article']);

      

   

    

    // set default value for Type person

    if (!$Type) { $Type = $def_Type; }

    

    // check for errors

    // if none found...

    if (sizeof($errorList) == 0)

    {

        // open database connection

        $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");



        // select database

        mysql_select_db($db) or die ("Unable to select database!");



        // generate and execute query

        $query = "INSERT INTO story(Author, loginid, Title, Date, Genre, Article) VALUES('$Author','$loginid','$Title','$Date','$Genre','$Article')";


        $result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

  



        // print result

        echo "<font size=-1>Update successful.<a href=index.php>Go Home</a><br />
<a href=addstory.php>Add Another</a>.</font>";



        // close database connection

        mysql_close($connection);

    }

    else

    {

        // errors found

        // print as list

        echo "<font size=-1>The following errors were encountered: <br>";

        echo "<ul>";

        for ($x=0; $x<sizeof($errorList); $x++)

        {

            echo "<li>$errorList[$x]";

        }

        echo "</ul></font>";

    }

}

?>


 

Link to comment
https://forums.phpfreaks.com/topic/119973-solved-str_replace/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.