StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Try this:</p> <pre><code><?php $host = "localhost"; // Host name $username = ""; // Mysql username $password = ""; // Mysql password $db_name = "db"; // Database name $tbl_name = "sentence"; // Table name // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sn = $_POST['numberofsentences']; $s_count_orig = $s_count = 1; // Sentence counter $p_count = 1; // Paragraph counter $per_para = 4; // 4 sentences per paragraph $paras = array(); // Array to hold the paragraphs $para = array(); // Array to hold the sentences $query = "SELECT line FROM `sentence` ORDER BY rand() LIMIT $sn"; $result = mysql_query($query); while ( $row = mysql_fetch_array($result) ) { // do something with $row. The following echos the results and adds a space after each sentence. // If there is room in the paragraph array for a sentence... if($s_count <= $per_para) { // Add the sentence to the array $para[$p_count] = $row['line']; // Next sentence $s_count++; } else { // We have a full paragraph, add it to our master array $paras[] = $para[$p_count]; // Next paragraph $p_count++; // Reset sentence counter $s_count = $s_count_orig; } } // Iterate our master array of paragraphs foreach($paras as $p){ // Echo each paragraph, and each sentence in each paragraph separated by two spaces echo '<p>' . implode('&nbsp;&nbsp;',$p) . '</p>'; } // Close the database connection mysql_close(); ?> </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload