So today, let’s look at the php code string replace (str_replace)l; This is especially handy when you want to take out spaces and replace with underscores (if you’re dynamically creating pages, links, etc). You can find and replace pretty much anything. Here’s some code:
$title = str_replace(" ", "_", $title);
Let’s assume $title is originally set to: my new page
Once that is run through the code, $title will now be: my_new_page
The code has three parts. The first section (” “) is seeking out all the spaces in the variable $title. It’s searching for what we want to change.
The second section (“_”), is telling it what to put in place of the spaces (or whatever you want to replace).
The third section ($title), is telling the code what variable is being changed (you can set the variable to edit a text file, html file, etc).
The first “$title” just means that I want to override the old content (with spaces) with the new content (with underscores). You can set it to a new variable if you’d rather, which would look like this:
$new_title = str_replace(" ", "_", $title);
And that’s about it! Very handy, especially if you want to change something just for display (like email addresses or birthdays), but keep the original info in the database.
]]>Starting off, we need to write the mySQL statement:
$table = mysql_query("SELECT COUNT(*) FROM senior_photos");
What the says is that the “table” variable (one I created) is going to equal whatever the mySQL query returns. The query, in quotations, is selecting the info requested from the table “senior_photos”, and counting them. The results are displayed in a table, with the first spot containing the answer.
Now in order for php to be able to interpret the table, a few things have to happen:
$row = mysql_fetch_row($table);
For starters, I create a new variable, “row”, which is telling it where to find the row containing the information.
$column = $row[0];
Then the variable “column” (another one I created), is telling it to read the first column of the first row with “[0]” (already told it to look at the first row in the previous statement).
echo $column;
Then all that’s left is to echo the last variable, and we have our answer!
Voila! Finished code:
$table = mysql_query("SELECT COUNT(*) FROM senior_photos");
$row = mysql_fetch_row($table);
$column = $row[0];
echo "Total Images on Site: ".$column;
First off, the code:
<?
$findFolder = mysql_query("SELECT * FROM folders where username = ".$_SESSION['id']);
echo"<select name='folder'>";
while($folder = mysql_fetch_array($findFolder))
{
?>
<option value='<?php echo $folder['folder']?>'><?php echo $folder['folder']?></option>
<?
}
echo "</select>";
?>
First off you have run a mySQL select statement to go to your database and grab the information you’ll need. I’ve used the *, which selects all, but if you only need to display one column, replace the * with that name.
Second I echo the html code to open the selector.
Third I use the while loop, which will display all the selection options.
<option value='<?php echo $folder['folder']?>'><?php echo $folder['folder']?></option>
I chose to write out this line in html, which seemed easier than echoing all the info, but the echo would look like this:
echo "<option value='".$folder['folder']."'>".$folder['folder']."</option>";
What’s going on, if an option is being formed for every row in the table in the column “folder”. The section $folder['folder'] needs to be in there twice, once as the value that will be passed through the form, the second to display the name in the browser (made that mistake once
Then you simply close the select statement, and you’re done!
]]>