Hi all,Im new to sql, php and this forum! so hope i've posted in the correct place.I have been learning mysql and created a simple two field database and used php to create a form to enter data into the database and just list the contents of the database. I would like to know if i can now use div's to possition the list called from the database.Here is my basic php code:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>The Internet Joke Database</title><meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> </head> <body> <?php if (isset($_GET['addjoke'])): // User wants to add a joke ?> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <label>Type your joke here:<br /> <textarea name="joketext" rows="10" cols="40"> </textarea></label><br /> <input type="submit" value="SUBMIT" /> </form> <?php else: // Default page display // Connect to the database server $dbcnx = @mysql_connect('localhost', 'root', ''); if (!$dbcnx) { exit('<p>Unable to connect to the ' . 'database server at this time.</p>'); } // Select the jokes database if (!@mysql_select_db('jokes')) { exit('<p>Unable to locate the joke ' . 'database at this time.</p>'); } // If a joke has been submitted, // add it to the database. if (isset($_POST['joketext'])) { $joketext = $_POST['joketext']; $sql = "INSERT INTO jokes SET joketext='$joketext', jokedate=CURDATE()"; if (@mysql_query($sql)) { echo '<p>Your joke has been added.</p>'; } else { echo '<p>Error adding submitted joke: ' . mysql_error() . '</p>'; } } // If a joke has been deleted, // remove it from the database. if (isset($_GET['deletejoke'])) { $jokeid = $_GET['deletejoke']; $sql = "DELETE FROM jokes WHERE id=$jokeid"; if (@mysql_query($sql)) { echo '<p>The joke has been deleted.</p>'; } else { echo '<p>Error deleting joke: ' . mysql_error() . '</p>'; } } echo '<p> Here are all the jokes in our database: </p>'; // Request the ID and text of all the jokes $result = @mysql_query('SELECT id, joketext FROM jokes'); if (!$result) { exit('<p>Error performing query: ' . mysql_error() . '</p>'); } // Display the text of each joke in a paragraph // with a "Delete this joke" link next to each. while ($row = mysql_fetch_array($result)) { $jokeid = $row['id']; $joketext = $row['joketext']; echo '<p>' . $joketext . ' <a href="' . $_SERVER['PHP_SELF'] . '?deletejoke=' . $jokeid . '">' . 'Delete this joke</a></p>'; } // When clicked, this link will load this page // with the joke submission form displayed. echo '<p><a href="' . $_SERVER['PHP_SELF'] . '?addjoke=1">Add a Joke!</a></p>'; endif; ?></body> </html>I want the list of jokes to be styled and put in possition on the page with css. If i close the php tags and then use css it doesn't work...how can I determine where the list of jokes is shown on the page using css?Hope you understand any questions please ask. Thank you for your time.
sq with css to display database contents
Posted - 2009-01-11 : 07:50:59
