dropfaith Posted August 16, 2008 Share Posted August 16, 2008 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.