PHP Knowledge Base
sprintf
Simple Examples
echo sprintf("<p>\$php__username = $php__username</p>");
$old = "index.html"; $new = "index.php"; echo sprintf('%s was renamed to %s',$old,$new);
$num = 5; $location = 'tree'; $format = 'There are %d monkeys in the %s'; echo sprintf($format, $num, $location);
Argument Swapping
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $mysql__dataset_name = $row['dataset_name']; $i++; $input_id = "radio".$i; $html__input = '<input type="radio" id="%2$s" name="form__dataset" value="%1$s"><label for="%2$s">%1$s</label>'."\n"; echo sprintf($html__input, $mysql__dataset_name, $input_id);
PDO Select Query
Connection, Query, While Loop, and Table Header
$conn = new PDO("mysql:host=$host;dbname=$dbname", $user, $password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "SELECT title, year, genre, rt_score FROM $whichTable"; $stmt = $conn->query($sql); echo "<table class=\"center\">\n<tr><th>Title</th><th>Year</th><th>Genre</th><th>RT</th></tr>\n"; while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
Replace:
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) { echo "<tr>\n<td>" . $row['title'] . "</td>\n<td>" . $row['year'] . "</td>\n<td>" . $row['genre'] . "</td>\n<td>" . $row['rt_score'] . "</td>\n</tr>\n"; } echo "</table>"
With:
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $title = $row['title']; $year = $row['year']; $genre = $row['genre']; $rt_score = $row['rt_score']; $html_row = "<tr>\n<td>%s</td>\n<td>%s</td>\n<td>%s</td>\n<td>%s</td>\n</tr>\n"; echo sprintf($html_row, $title, $year, $genre, $rt_score); } echo "</table>";
NULL