PHP - Compare Variable With Multiple Words

I run an article directory. I was wondering how I could check an article that is currently pending review against published articles in our database. What I am looking to do is to place the content of the body in the pending article into a variable. That much is easy and I know how to do that. Then I would like to use that variable to compare against other content in our database and have it output a percentage of how close it is to any other article already published in our database. Any direction our guidance with this would be so greatly appreciated.   


Thanks!

I typically only use the first two solutions.  Is there anything wrong with the third?  Is there any more streamlined way to do it?

function f1($x){return $x*1;}
function f2($x){return $x*1;}

$x=2;$y=1;

if(f1($x)>f2($y)){echo(f2($y)."\n");}

// or

$f2_y=f2($y);
if(f1($x)>$f2_y){echo($f2_y."\n");}

// or

if(f1($x)>$f2_y=f2($y)){echo($f2_y."\n");}

Hi again everyone,

I am trying to compare a php variable to the value of a row in mysql, but keep getting the following error:

Code: [Select]
Wrong perameter count for mysql_result()

What syntax would I use to accomplish this?

Here is my code:


// connects to server and selects database.
include ("../includes/dbconnect.inc.php");

// table name
$table_name = "availability";

// split up date into 3 separate fields
$date = "12/25/2010";
$date_split = explode("/", $date);
$month = $date_split[0];
$day = $date_split[1];
$year = $date_split[2];

// check if earth room is already reserved
$taken = "Reserved";
$sql = "SELECT earth_room FROM $table_name WHERE month='$month' AND day='$day' AND year='$year' LIMIT 1";
$result = mysql_query($sql) or trigger_error("A mysql error has occurred!");
$row = mysql_result($result);

if($row == $taken){
echo "Room Already Reserved";
}
else{
echo "Room Available";
}


Thanks for the help,

kaiman

I found this regex, which is what I want, here:

(?=.*\bdog\b)(?=.*\bpuppet\b)(?=.*\bfuzzy\b)

It is suppose to 'succeed' if it can find all the given words in any order.   Yet, when I try to test it against this sequence of words (or any other order of these words):

need fuzzy hand puppet in dogpen for dog

I get no indication of a match.   What am I not understanding?

I have a cart script, and I need to display the products the user has added.  This is a school assignment and I'm very stuck on this seemingly 'little' error.

Right now, I have two tables:

For time's sake, I am showing duplicate products with different prod_id's:
Table: products
prod_id category sub_category thumb_href image_href title desc summary manufacturer price 17 sofa leather red_leather_sofa_small.jpg red_leather_sofa_main.jpg Red Leather Sofa [BLOB - 134B] [BLOB - 59B] Balenty 999.99 18 sofa leather red_leather_sofa_small.jpg red_leather_sofa_main.jpg Red Leather Sofa [BLOB - 134B] [BLOB - 59B] Balenty 999.99 19 sofa leather red_leather_sofa_small.jpg red_leather_sofa_main.jpg Red Leather Sofa [BLOB - 134B] [BLOB - 59B] Balenty 999.99
And this is the cart table that holds temporary cart items (storing the product ID to pull later):
Table: cart
temp_cart_item cart_id (assigned by session_id() ) prod_id user_id 22 jier11u0e7cl2ghosjodpaark2 17 asdfasdf 23 jier11u0e7cl2ghosjodpaark2 17 asdfasdf 24 jier11u0e7cl2ghosjodpaark2 35 asdfasdf 25 jier11u0e7cl2ghosjodpaark2 5 asdfasdf 26 jier11u0e7cl2ghosjodpaark2 19 asdfasdf
SO, user 'asdfasdf' is logged in and has selected 5 items for his cart - two of which are the same (prod_id 17).  Basically,

I need to compare the prod_id's of each table and output all products (and quantities) matching the temporary cart prod_id.

What I have now to loop through and display the cart items are (bear with me):


echo "<h1>Cart</h1>";
}
// Display welcome and navigation links
displayWelcome();
displayNav();

// Getting the prod_id's from the table cart to compare with the product table
$cart_id = session_id();
$user_id = ($_SESSION['login_username']);
$query = "SELECT prod_id FROM cart WHERE cart_id='$cart_id' AND user_id='$user_id'";
$result = mysqli_query($cxn,$query) or die("<h2 class=\"warning\">Whoa! Problem with the cart script here!</h2>");
$nrows = mysqli_num_rows($result);
if($nrows < 1)
{
echo "<h2>Your cart is empty</h2><p><a href=\"catalog.php\">Go back to the catalog</a></p>";
}
else {  // Continue to gather products for all the product IDs in the products DB table...
echo "<h4>$nrows items in your cart</h4>";
while($row = mysqli_fetch_array( $result )) {
$user_id = ($_SESSION['login_username']);
$product = $row['prod_id'];

// Is the query my problem?
$query = "SELECT * FROM products WHERE prod_id='$product'";
$result = mysqli_query($cxn,$query) or die("<h2 class=\"warning\">Whoa! Problem with the cart script here!</h2>");
$nrows = mysqli_num_rows($result);
if($nrows < 1) { // If the item doesn't exist, display an error
echo "<h2>That is not a valid product, or any of the items you had in your cart are missing or have been deleted.</h2><p><a href=\"catalog.php\">Go back to the catalog</a></p>";
// Protect from continually displaying an error by deleting the invalid cart record
$deletequery = "DELETE FROM cart WHERE prod_id='$product'";
$deleteresult = mysqli_query($cxn,$deletequery) or die("<h2 class=\"warning\">Whoa! Problem with the cart script here!</h2>");
exit();
}
while($row = mysqli_fetch_array( $result )) {  //  Then disply them in a table
echo "<h2>Items in Your Cart:</h2>";
echo "
<table id=\"products\">
<thead>
<tr>
<th class=\"col1 headercol\" scope=\"col\">Thumbnail</th>
<th class=\"col2 headercol\" scope=\"col\">Summary</th>
<th class=\"col3 headercol\" scope=\"col\">Manufacturer</th>
<th class=\"col4 headercol\" scope=\"col\">Price</th>
</tr>
</thead>

<tbody>\n";
$query = "SELECT SUM(price) FROM products WHERE prod_id='$product' GROUP BY price";
$priceResult = mysqli_query($cxn,$query) or die("<h2 class=\"warning\">Whoa! Problem with the cart script here!</h2>");
// keeps getting the next row until there are no more to get
// Print out the contents of each row into a table
echo "<tr>
<td class=\"col1\">"; 
echo "<a class=\"imgHref\" href=\"detail.php?prod_id=".$row['prod_id']."\" title=\"".$row['title']."\"><img src=\"../images/".$row['thumb_href']."\" alt=\"".$row['title']."\" /></a>";
echo "</td>\n"; 
echo " <td class=\"col2\">"; 
echo "<h3 class=\"title\"><a href=\"detail.php?prod_id=".$row['prod_id']."\" title=\"".$row['title']."\">".$row['title']."</a> <span class=\"inlineh3\">by <a href=\"categories.php?manufacturer=".$row['manufacturer']."\" title=\"View all products by ".$row['manufacturer']."\">".$row['manufacturer']."</a></span></h3>";
echo "<p class=\"summary\">".$row['summary']."</p>
<p class=\"descHeading\">&#38;#9758; <em>Full Description:</em></p>
<p class=\"desc\">".$row['desc']."</p>";
echo "</td>\n"; 
echo " <td class=\"col3\">"; 
echo "<p class=\"manufacturer\"><a href=\"categories.php?manufacturer=".$row['manufacturer']."\" title=\"View all products by ".$row['manufacturer']."\">".$row['manufacturer']."</a></p>";
echo "</td>\n"; 
echo " <td class=\"col4\">"; 
echo "<p class=\"price\">$".$row['price']."</p>";
echo "</td>
</tr>\n"; 
}
while($priceRow = mysqli_fetch_array( $priceResult )) {
echo "<tr class=\"short\"><td class=\"col1\"><h3><a href=\"clear_cart.php\">Empty Cart</a></h3></td><td class=\"col2\"></td><td class=\"col3 nobackground\">Total:</td><td class=\"col4\">$".$priceRow[0]."</td></tr>";
}
echo "</tbody>
</table>";
echo "<p class=\"submitOrder\"><form action='submit_order.php' method='post' id='form'>
  <input type='submit' name='pButton' value='Submit Order'>
  <input name='order_total' type='hidden' id='order_total' value='".$priceRow[0]."' />
</form>
</p>";
}
}



And so the cart.php looks something like this (this example asdfasdf has 6 items in his cart):



So you can see that it only displays ONE item, even though asdfasdf DOES have 6 items in his cart (proven by checking database).  And the price is not accurate, either.

Can anyone help me in where my problem might be?  Is it my query?  Or my while clause?

I've been trying to go around with str_replace to replace numbers with words.
I have a database which has table actions. The actions are saved in numbers from 0 to 20.
I'd need to get something to replace the numbers with words to explain what actions these are.

I've tried using this.
$action1 = str_replace("5", "Command", "action1");
But that doesn't work. Not even 100% sure if that is even correct, because I am new to the str_replace thing anyway.

Could someone help me with this, please?

Hi there

I am beginning to learn regex in php.  I was wondering why the following regex pattern wasn't finding the two words in the string and replacing them with welcome? '/(Hello).*?(Hi)/is'

Code: [Select]
$patterns = array();
$patterns[0] = '/(Hello).*?(Hi)/is';

$replacements = array();
$replacements[0] = 'Welcome';


ksort($patterns);
ksort($replacements);
echo preg_replace($patterns, $replacements, $string);

Any help would be much appreciated.  Thanks a million!

First off, hello all!

I want to improve our website's search but unfortunately don't know enough to get there!

I'm not a PHP programmer but I'm generally able to tweak things... 

Our search page has 3 options - All words, Any word, Exact. 

I want to concentrate on the default "All words" which is the default parameter.

The code is essentially as follows -

Code: [Select]
$gotcriteria=TRUE;
$Xstext = mysql_escape_string($stext);
$aText = split(" ",$Xstext);
$aFields[0]="products.pId";
$aFields[1]="products.pName";
$aFields[2]="products.pDescription";
$aFields[3]="products.pLongDescription";
if($stype=="exact")
$sSQL .= "AND (products.pId LIKE '%" . $Xstext . "%' OR ".getlangid("pName",1)." LIKE '%" . $Xstext . "%' OR ".getlangid("pDescription",2)." LIKE '%" . $Xstext . "%' OR ".getlangid("pLongDescription",4)." LIKE '%" . $Xstext . "%') ";
else{
$sJoin="AND ";
if($stype=="any") $sJoin="OR ";
$sSQL .= "AND (";
for($index=0;$index<=3;$index++){
//$sSQL .= "(";
$rowcounter=0;
$arrelms=count($aText);
foreach($aText as $theopt){
if(is_array($theopt))$theopt=$theopt[0];
$sSQL .= $aFields[$index] . " LIKE '%" . $theopt . "%' ";
if(++$rowcounter < $arrelms) $sSQL .= $sJoin;
}
//$sSQL .= ") ";
if($index < 3) $sSQL .= "OR ";
}
$sSQL .= ") ";
}

Here's the important bit - as far as I can see, the search looks at each of the 4 fields in the array individually?  So if the search text is "RED APPLE", to get a result for the "All Words" option will require that both "RED" AND "APPLE" will need to be present in one of the searched fields...?

What I want to achieve is that if the product name is "RED FRUIT" and the description mentions "APPLE", then an "All words" search for "RED APPLE" will pick this up.

I'd guess that the easiest way would be to string the table fields together for searching but I don't know how to do this as a query... now I'm thinking I'll get flamed for not posting this in the MySQL forum too!! 

Thanks in advance for any help!

Say I have this array:

Code: [Select]
array(
0 => time
1 => time
2 => to
3 => to
4 => to
5 => fly
);
and 2 variables - $occMin and $occMax as number of occurrences.

If:

Code: [Select]
$occMin = 2;
$occMax = 3;

I want to produce sorted list with most occurrences at the top:

Code: [Select]
array(
0 => array('to', 3),
1 => array('time', 2)
);
My face just melted at the thought of even beginning to tackle this. Is this somewhat possible? would it require a monster function or am I missing some native php functions which could lend a hand?

Hi Guys,

I don't know how to do this but basically I want the value of $postcode3 to equal the value of $postcodep1 aswell as $postcodep2 like this...

else {$postcode3 = $postcodep1 $postcodep2;}

That doesn't work...

Say
$postcodep1 = LS14
$postcodep2 = 2AB

Then
$postcode3 = LS14 2AB

How do I write this in the above php code?!

Thanks,
S

Hi there im trying to set a single variable multiple rows of data that are echoed using a single variable. The trouble is i just cant seem to make it work by trying to add a while or do loop..

The variable is $alderaanfleetalt  and consists of:

Code: [Select]
$fleetname = "FleetName";
$shipname = "Ship Name";
Which is just text stored in two other variables. The select query row of data is added the $alderaanfleetalt variable.

Code: [Select]
$alderaanfleetalt =  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName'];
At the moment only a single row appears. ive tried to add a while/do loop so that multiple rows are outputted but its not working.

Code: [Select]
do{
$alderaanfleetalt =  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName'];
} while ($row_Alderaanfleet = mysql_fetch_assoc($Alderaanfleet));

Im a bit lost here and not even sure it can be done this way... Any help would be ace.

Thank you

Hi folks,

I was wondering how to do this. I want the if statement to detect if the query string has any of these values. so im trying to assign them all to the same variable. However, this code wont work. Whats the trick here?

<?php
$primary=$_GET['intro'];
$primary=$_GET['port'];
$primary=$_GET['about'];
$primary=$_GET['contact']; 

         if(isset($primary)){
     echo "<img src='graphics/left-a.png'>";}
else {echo "<img src='graphics/leftb.png'>";}?>

Hey everyone,
I'm new to this forum and I came here looking for some help with PHP. I've just started
getting into PHP and you guys are probably a smile ahead.

So basically, I have some inputs and want them to be sent to my email in a basic layout shown below.

Code: [Select]
Inputs:

Title = _title
Forum Name = _forumname
Name = _irlname
Age = _age

I want the email to be sent to me like:

Code: [Select]
Email Title
---------------
Forum Name: TextGiven
Real Life Name: TextGiven
Age: TextGiven
Here is my current code which titles the email correctly, but I want to figure out how
to make $message set to the example email I showed above.

Code: [Select]
<?php 
$to = "******@*********.net";
$subject = $_REQUEST['_title'];
$headers = "From: ***** Applicant \r\n"; 
$headers .= "MIME-Version: 1.0\r\n"
  . "Content-Type: text/html; charset=\"iso-8859-1\"\r\n"
 . "Content-Transfer-Encoding: 7bit\r\n";
$message =  $_REQUEST['_forumname' & '_irlname'];  <--- Part I want fixed


if(mail($to, $subject, $message, $headers)) 
{
     echo 'MAIL SENT'; 
} else { 
     echo 'MAIL FAILED';
} 
?>

I have this code, and it works. But I want $message = "" to make the message contain not just the
forum name, but as well as the name, age, and all other inputs I want.

I'm not sure how to approach this but here is my problem.

I'm using a sql statement that counts the number of users in the database. I've created a session variable named $MerchantCount and then I need to multiple that number by this scheme

0-9  Needs to multiple by 2.5
10-19 Needs to multiple by 5.0
20 and up needs to multiple by 7.5

How would I do this? Thanks...

So i got the following problem:

i got some pages : index.php , comment.php, viewArticle.php

When i try to submit something from comment.php appear a error "Undefined variable:result"
The var result is defined in index.php
When i click on one article from the list the function viewArticle() is requiring viewArticle.php and the function addcomment() is requiring comment.php

The addcomment function() is in viewArticle function()

I can't figure out what's wrong but I guess have something to do whit the form action="index.php?action=viewArticle&articleid=<?php echo $result['article']->id?>"

index.php code
Code: [Select]
<?php

include('config.php');

$action = isset($_GET['action'])?$_GET['action']:"";

switch($action)
{
case 'viewArticle':viewArticle();break;
    default:homepage();
}

function homepage()
{
$result = array();
    $data = Article::getlist(1);
    $result['article']=$data['result'];
$result['total']=$data['totalrows'];
    require('homepage.php');
}

function viewArticle()
{
if( !isset($_GET['articleid']) )homepage();
$result = array();
    $result['article'] =  Article::getbyid((int)$_GET['articleid']);
$result['name'] = $result['article']->name;
addcomment();
require('viewArticle.php');
}

function addcomment()
{

   
if(isset ($_POST['submit'] ))
{
$comment = new Comment;
$set = array();
$set['usern']="HJhj";
$set['com']="aca wqeq";
$set['page']=7;
$comment->storeFormValues($set);
$comment->insertc();
}
    else require('comment.php');

}

?>
viewArticle.php code
Code: [Select]
<center>
<h1> <?php echo $result['article']->text ?> </h1>


comment.php code:

Code: [Select]
<form method='post' action="index.php?action=viewArticle&articleid=<?php echo $result['article']->id?>" >
<input type="hidden" name="id" value="56"/>

<ul>
<li>
  <input type="text" name="usern" id="usern" />
</li>

<li>
<textarea name="com" id="com" COLS=40 ROWS=6></textarea>
</li>

<input type="hidden" name="page" value="56" />
<input type="submit" name="submit" value="submit" />

</form>