eMonk

How can I check if the text entered in a textarea field equals the text I have stored in a mysql table? $submitted_description = trim(mysqli_real_escape_string($db,$_POST['description'])); $query = "SELECT description FROM pets"; $result = $db->query($query); $row = $result->fetch_assoc(); $sql_description = $row['description']; Here's what they echo: I tried adding the following to get rid of \r\n from $submitted_description but they both still don't equal but echo the same text. $submitted_description = str_replace(array("\r","\n",'\r','\n'),' ', $submitted_description); They following code only matches when no spaces are entered in the textarea field. if($submitted_description == $sql_description) { echo "Match!"; } else { echo "Don't Match!"; } How can this be done? I also tried adding nl2br() to both variables but that didn't work either.

<?php mysql_connect ("pdb1.awardspace.com", "anastasov_db","moscow1945") or die (mysql_error()); mysql_select_db ("anastasov_db"); $term = $_POST['term']; $sql = mysql_query("select * FROM countries WHERE cocode = '$term'"); $num_rows = mysql_num_rows($sql); if ($num_rows == 0) { echo "No results found."; exit; } while ($row = mysql_fetch_array($sql)){ echo '<br/> Code: '.$row['cocode']; echo '<br/> Country: '.$row['coname']; echo '<br/><br/>'; } ?>

My old query was: $query = "SELECT city_name FROM city WHERE province_id = 9"; Now I'm using: $city = $_GET['city']; and just have the city name now but need to fetch all the cities in the province that $city is in. Here are my tables: Table: city column: city_name = Vancouver, Victoria, Edmonton column: province_id = 9, 9, 8 Table: province column: id = 8, 9 column: name = Calgary, British Columbia So if $city is in province British Columbia, what type of join to I need to fetch all cities listed in British Columbia?

The problem seems to be when I use $region: if (isset($_GET['region'])) { $region = ucwords($_GET['region']); } I tried changing: $_SERVER['PHP_SELF'] to $_SERVER['REQUEST_URI'] because ?region= doesn't appear in the url on page 2 but it's still displaying a blank page.

Any ideas why the script works with my old queries but not the new ones?

It returns 6 which is correct on the first page but when I click on page 2 it returns 0 and doesn't display the final link.

Here's the code. It was working before I edited $strqry and $data_p old queries: $strqry = "SELECT id from model WHERE status = 'Active' "; $data_p = "SELECT * FROM model WHERE status = 'Active' ORDER BY RAND($rand) $max"; new queries: $strqry = "SELECT DISTINCT model.id from model INNER JOIN model_in_city ON (model_in_city.model_id = model.id) INNER JOIN city ON (city.city_id = model_in_city.city_id) INNER JOIN province on (city.province_id = province.id) WHERE province.name = '$region' AND model.status = 'Active' "; $data_p = "SELECT DISTINCT(model.id), model.thumbnail, model.name, model.location FROM model INNER JOIN model_in_city ON (model_in_city.model_id = model.id) INNER JOIN city ON (city.city_id = model_in_city.city_id) INNER JOIN province on (city.province_id = province.id) WHERE province.name = '$region' AND model.status = 'Active' ORDER BY RAND($rand) $max"; pagination script: <?php session_start(); $rand = $_SESSION['rand']; // session code here if (isset($_GET['region'])) { $region = ucwords($_GET['region']); } ?> <-- html tables --> <?php $LIMIT = 5; $page = (isset($_REQUEST['page']) ? intval($_REQUEST['page']) : 1); $page = ($page < 1 ? 1 : $page); include("includes/connect.php"); $LimitValue = $page * $LIMIT - ($LIMIT); $strqry = "SELECT DISTINCT model.id from model INNER JOIN model_in_city ON (model_in_city.model_id = model.id) INNER JOIN city ON (city.city_id = model_in_city.city_id) INNER JOIN province on (city.province_id = province.id) WHERE province.name = '$region' AND model.status = 'Active' "; $result = $db->query($strqry); $TOTALROWS = $result->num_rows; $NumOfPages = $TOTALROWS / $LIMIT; $max = 'limit ' .($page - 1) * $LIMIT .',' .$LIMIT; $data_p = "SELECT DISTINCT(model.id), model.thumbnail, model.name, model.location FROM model INNER JOIN model_in_city ON (model_in_city.model_id = model.id) INNER JOIN city ON (city.city_id = model_in_city.city_id) INNER JOIN province on (city.province_id = province.id) WHERE province.name = '$region' AND model.status = 'Active' ORDER BY RAND($rand) $max"; $result_2 = $db->query($data_p); echo "<p>Number of models found: ".$TOTALROWS."</p>"; while ($list = $result_2->fetch_assoc()) { echo "<table width=\"480\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\">" ; echo "<tr>" ; echo "<td width=\"50\"><a href=\"view.php?id=" . $list["id"] . "\"><img src=\"" . $list["thumbnail"] . "\" class=\"img\" border=\"0\" width=\"60\" height=\"60\"></a></td>" ; echo "<td valign=\"middle\" class=\"text\"><a href=\"view.php?id=" . $list["id"] . "\">" . stripslashes($list['name']) . "</a><br /><font color=\"#999999\">" . stripslashes($list['location']) . "</font></td>" ; echo "</tr>" ; echo "<tr>" ; echo "<td colspan=\"2\"><hr class=\"hr\" /></td>" ; echo "</tr>" ; echo "</table>" ; } echo "<div id=\"paginating\" align=\"left\">Page:"; // Check to make sure we’re not on page 1 or Total number of pages is not 1 if ($page == ceil($NumOfPages) && $page != 1) { for($i = 1; $i <= ceil($NumOfPages)-1; $i++) { // Loop through the number of total pages if($i > 0) { // if $i greater than 0 display it as a hyperlink echo "<a href=\"".$_SERVER['PHP_SELF']."?page={$i}\">{$i}</a> "; // ?region=".strtolower($region)."& } } } if ($page == ceil($NumOfPages) ) { $startPage = $page; } else { $startPage = 1; } for ($i = $startPage; $i <= $page+6; $i++) { // Display first 7 pages if ($i <= ceil($NumOfPages)) { // $page is not the last page if($i == $page) { // $page is current page echo " [{$i}] "; } else { // Not the current page Hyperlink them echo "<a href=\"".$_SERVER['PHP_SELF']."?page={$i}\">{$i}</a> "; // ?region=".strtolower($region)."& } } } echo "</div>"; ?> The problem is when I click on page 2 it comes up blank with 0 results. The first page however shows the correct results which is currently 6. When I use my old queries it works fine. Why doesn't the script like my new queries? They are fetching the results correctly from what I know. Does anyone see anything wrong with the code?

I'm trying to list all the models listed in the province British Columbia. Here's my tables: Table: model column: id = 1,2 Table: city column: city_id = 33,34 column: city_name = Vancouver,Victoria column: province_id = 9,9 Table: model_in_city column: model_id = 1,2 column: city_id = 33,34 Table: province column: id = 9,10 column: name = British Columbia,Quebec I believe these are the conditions that are needed: model.id = model_in_city.model_id city.city_id = model_in_city.city_id city.province_id = province.id WHERE province.name = British Columbia I tried the following query but can't seem to LEFT JOIN 2 tables? SELECT id from model LEFT JOIN model_in_city ON (model_in_city.model_id = model.id) LEFT JOIN city ON (city.province_id = province.id); MySQL said: #1054 - Unknown column 'province.id' in 'on clause'

I need to include a pagination file in multiple pages or create a custom function but not sure which one to use. For example: <?php function test() { echo "Hello PHP Freaks!"; } ?> Or I can create a separate file that echos this statement and include it. When do you use include/require and when do you create your own custom function?

Thanks for the clearification. I'll go with the first one.

$query = "SELECT .... "; $result = $db->query($query); $num_results = $result->num_rows; if ($num_results == 0) { exit; } else { // do something $query = "SELECT .... "; $result = $db->query($query); $num_results = $result->num_rows; if ($result) { // do something } Do these both do the same?

This isn't the entire code just enough to see what I'm trying to do. Everything was working until I added the mysql update query in the if statement. Is this possible or am I doing something wrong? When I run the script it just echos "No results found" twice as $num_results = 2. <?php include("../includes/connect.php"); $query = "SELECT ........ "; $result = $db->query($query); $num_results = $result->num_rows; if ($num_results == 0) { exit; } else { $i=0; while ($i < $num_results) { $row = $result->fetch_assoc(); $id = $row['id']; if ($expiration_date > $today) { ### EMAIL CODE HERE ### $update = "UPDATE model SET reminder_sent = '1' WHERE id = '$id' "; $result_2 = $db->query($update); $i++; } else { echo "No results found."; $i++; } } } ?>

I have it working now. Had to flip the 2 CURDATE parameters around.

Thanks PFMaBiSmAd. I was looking into retrieving date ranges in sql queries last night. I was trying to find a CURMONTH operator to narrow down the results but I guess I doesn't exist because I couldn't find anything about it. I tried your query and tried to echo the number of results but it keeps returning 0. <?php include("../includes/connect.php"); $query = "SELECT expiry_date FROM model WHERE expiry_date BETWEEN CURDATE() AND CURDATE() - INTERVAL 3 DAY"; $result = $db->query($query); $num_results = $result->num_rows; echo "$num_results"; ?> $num_results should echo "1" because there is 1 expiry_date column with "2011-11-17". Any ideas? I'm trying to only fetch the rows where the expiry_date column is 3 days before today's date.

Thanks for the tips gents! It seems to be working now. PFMaBiSmAd: I will be using a WHERE clause in the final code but I want to retrieve all the rows from the expiry_date column to check if the user's page is going to expire within 3 days and if yes to send an email reminder to renew. Right now the table only has 11 test entries. It shouldn't be more then 100 once it goes online but if it does reach 100's of entries, is this approach right?

I recently added a mysql query and a while loop to my expiration date script but now it doesn't work. The script is suppose to send the user an email x days before it expires. <?php include("../includes/connect.php"); $query = "SELECT expiry_date FROM model"; $result = $db->query($query); $num_results = $result->num_rows; $exp_date = strtotime($row['expiry_date']); // YYYY-MM-DD $today = strtotime("now"); $expiration_date = strtotime("+3 days", $exp_date); $i=0; while ($i < $num_results); { $row = $result->fetch_assoc(); if ($expiration_date > $today) { echo "Valid: Yes<br />"; echo "Today: $today<br />"; echo "Expire date: $expiration_date"; include('../../pear/Mail-1.2.0b1/Mail.php'); ## EMAIL CODE HERE ## echo "<p>Your email has been sent to $recipients</p>"; $i++; } else { echo "No results found."; } } ?> Right now the script just echos "No results found". The mysql table has 11 entries and one of them is about to expire so the user should be sent an email but the code above doesn't work. Does anyone see anything wrong with the code above?

Can anyone explain what "of course you'll need to propagate the initial seed in the page requests" means in the following link? http://stackoverflow.com/questions/4192284/random-values-in-mysql-query-with-pagination

Now I have the results showing on the page but when I click on the next page of results I get a 404 error. Any ideas? For example: Pages: [1] 2 3 When I click on page 2 it doesn't exist and gives me a 404 error message.

My php/mysql book doesn't cover pagination so I've been searching the web for a simple pagination script that I can learn from. I got the following one working at http://www.phpsimplicity.com/tips.php?id=1 but it's just showing the next and prev links... no results on the pages and you can click on the next link forever when there's only 11 records in the table I queried. How can I display results on each page and have the info append to the next page? This is the second example I've tried and none seem to explain this part?

Ok now $TOTALROWS returns "11" and the html output is: Pages: [1] 2 3 Now when you click on the links, for example, http://www.test.com/2 ... it leads to a 404 page because it cannot be found... do I need to create a script like page.php and make the url output http://www.test.com/page.php?page=2 ???

I moved $LimitValue above $strqry so it looks like this: $LimitValue = $page * $LIMIT - ($LIMIT); $strqry = "SELECT id from model LIMIT $LimitValue, $LIMIT"; Now it's displaying: Pages: [1] I added an echo for $TOTALROWS and it's displaying "5" which is what $LIMIT is set to but $TOTALROWS should be "11".

It's working now.. there was also a missing closing bracket in the first if statement. Now it's echoing "Pages:" but not the hyperlink numbers, for example.. "Pages: 1 2" $strqry = "SELECT id from model LIMIT $LimitValue, $LIMIT"; The query above should have 11 records so it should create 2 pages. Any ideas?

That's the entire file... here's the complete error message... Line 29 is... $LimitValue = $page * $LIMIT – ($LIMIT);

Thanks MasterACE14. That line has been fixed however the problem still remains.

I tried to echo the html but still get the same error. Here's the entire code: <?php $LIMIT = 5; if (isset($_GET['page'])) { $page = $_GET['page']; if ($page <= 0) { $page = 1; } } else { $page = 1; } include("../includes/connect.php"); $strqry = "SELECT id from model"; $result = $db->query($strqry); $TOTALROWS = $result->num_rows; $NumOfPages = $TOTALROWS / $LIMIT; $LimitValue = $page * $LIMIT – ($LIMIT); echo "<div id=\"paginating\" align=\"right\">Pages:"; if ($page == ceil($NumOfPages) && $page != 1) { for($i = 1; $i <= ceil($NumOfPages)-1; $i++) { if($i > 0) { echo "<a href=\"/{$i}\">{$i}</a>"; } } } If ($page == ceil($NumOfPages) ) { $startPage = $page; } else { $startPage = 1; } for ($i = $startPage; $i <= $page+6; $i++) { if ($i <= ceil($NumOfPages)) { if($i == $page) { echo " [{$i}] "; } else { echo "<a href="\"/{$i}\">{$i}</a> "; } } } echo "</div>"; ?>