PHP - Count Matches

I have this query to show the current class I'm in:
Code: [Select]
$GetTimeTable = "SELECT * FROM timetable WHERE username='$username' AND Subject_date='$today_date'";
Then I have this to display current class:
Code: [Select]
if($TimeNow >= $Start_time && $TimeNow <= $End_time){
echo "Current Class: ";
echo $Subject;}
How would I find next class that day?

Hello,

I am trying to get this backlink checker that checks to make sure another website has my link on their website, so far I can check to make sure the "href" link is there and is correct, but I cant get the textContent to prove valid or not it seems to always be proving true even when the textConent is not in the mysql database.

The other persons website will have this:
<a href="http://businessinvestingsorce.com">Business Investing Source</a>

I need to make sure Business Investing Source (the textContent) matches the anchor in the database.

Here is my code:

Code: [Select]
<?php

function CheckForAnchorMatch($anchortext) {    

$query = mysql_query("SELECT * FROM allowed_anchor WHERE anchor='$anchortext'");
if(mysql_num_rows($query) != 0) {
return true;
}

return false;

} 

function CheckForTargetUrl($links, $target) {    
    foreach ($links as $link) {
        if (strpos($link, $target) !== false) {
            return true;
        }
    }

    return false;
} 
                          
function ExtractHrefLinks($html) {
    $dom = new DOMDocument;
    $linkUrls = array();
     

    @$dom->loadHTML($html);
    $links = $dom->getElementsByTagName('a');
     
    foreach ($links as $link){
        $linkUrls[] = $link->getAttribute('href');
    }
    
    return $linkUrls;
}

function ExtractAnchorText($html) {
    $dom = new DOMDocument;
    $AnchorTexts = array();
     

    @$dom->loadHTML($html);
    $links = $dom->getElementsByTagName('a');
     
    foreach ($links as $link){
        $AnchorTexts[] = $link->textContent;
    }
    return $AnchorTexts;
}

function backlink_check($contenturl){

$url = 'businessinvestingsource.com';
$source = $contenturl;

$falseFound = false;

    $html = file_get_contents ( $source );
    $links = ExtractHrefLinks($html);
 
    if (CheckForTargetUrl($links, $url) === false) {
        $falseFound = "true";
        $reportArray[$source] = 0;
    } else {
        $falseFound = "false";
    }


    $html = file_get_contents ( $source );
    $anchortext = ExtractAnchorText($html);
    
    if (CheckForAnchorMatch($anchortext) === false) {
        $falseFound = true;
    } else {
        $falseFound = false;
    }

return $falseFound;
}
?>
Help greatly appreciated

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!

Im trying to insert a name into my database but I need it to go into the column that matches the sessions user id


Code: [Select]
"INSERT INTO users SET name = '".$_POST['name']."'";

how do I tell it to put name into name column with id matching Session id.

really appreicate if someone could please help me with this.

Hi guys and girls,

I am having trouble finding out wether the query made no matches rather than just displaying the matches.

So what I would want is for the search term to look at the database, and if there's not matches then say, "No match for your search term"

Code: [Select]
function search_applications() {

global $dbc;

echo '<form method="post" action="" id="search">'. "\n";
echo '<label for="search_applications">Search for an application</label>'. "\n";
echo '<input type="text" name="search_applications" />'. "\n";
echo '<input type="submit" name="submit" />'. "\n";
echo '</form>'. "\n";


if(isset($_POST['submit'])){

$search_applications = $_POST['search_applications'];


if ($search_applications == "")
 {
 echo "<p>You forgot to enter a search term"; 
 }

//if (preg_match("/\b$search_applications\b/i")){
if(preg_match("/^[  a-zA-Z]+/", $search_applications)){


//for testing the variables
//echo $search_applications;

$sql="SELECT title, category, content FROM distributors_content WHERE  title LIKE '%" . $search_applications . "%' OR category LIKE '%" . $search_applications  ."%' OR content LIKE '%" . $search_applications  ."%'";
$result=mysqli_query($dbc, $sql);
//-create  while loop and loop through result set
while($row=mysqli_fetch_array($result)){
          $title  =$row['title'];
       $category=$row['category'];
       $content=$row['content'];
       
//-display the result of the array
echo "<ul>\n";
echo '<li> <a href="index.php?article='.$row['title'].'&&page=application" title=""> '.$title . ' ' . $category .  '</a></li>'."\n";
echo "</ul>";
}
}else{

echo "<p>Enter another search term</p>";
}
}
}

Any pointers would be good

Thank you

Hi,

I am doing an EDIT user page and would like to check records with a dropdown and then set as selected, please help!


<select name="BrokerID" class="small-input">

<option value="Please select an option">Please select a Broker</option> 

<?php 

while($row2 = mysql_fetch_array($broker))

{

echo '<option name="BrokerID" value="'.$row2['BrokerID'].'">'.$row2['BrokerName'].'</option>';

}

?>

</select>

First time post, be easy on me...   I'm using preg_match_all to return an array with all the matches.  I know I'm missing something fundamental, but I either keep looking past it or am more screwy than I know.   Sample String

CC-BY-ND-NC

I'm using the following code

preg_match_all("/cc|creative commons|copyright|by|sa|nc|nd/i",$exifmeta['copyright'],$cmeta)

I would expect to see

Array
(
    [0] => Array
        (
            [0] => CC
            [1] => BY
            [2] => ND
            [3] => NC
        )

)

What I get is

Array
(
    [0] => Array
        (
            [0] => CC
            [1] => BY
            [2] => ND
            [3] => NC
            [4] => sa
        )

)

Anyone can help me?

<?php
$tbl_name="menu";
$kategorije = mysql_query("SELECT * FROM $tbl_name WHERE Left(menu_name, 1) BETWEEN 'A' AND 'M' ORDER BY menu_name ASC");
if (!$kategorije) {
die("Database query failed: " . mysql_error());
}

while ($row=mysql_fetch_array( $kategorije )) {
echo "<div id=lista-header><h4>{$row["menu_name"]}</h4></div>";
$id_sub=$row['id_menu'];
$podkategorije = mysql_query("SELECT * FROM submenu WHERE id_menu=$id_sub ORDER BY sub_name ASC", $connection);
if (!$podkategorije) {
die("Database query failed: " . mysql_error());
}
echo "<ul class=\"pod\">";
while ($pod=mysql_fetch_array( $podkategorije )) {
echo "<li><a href=index.php?=podkate?".$pod["id_sub"]." class=black>{$pod["sub_name"]}</a><hr size=1 align=left width=100px color=#cccccc></li>";
}
echo "</ul>";
}


?>

In this way, I get list with categories and hes subcategories. How to count how many subcategories have each categories, and count how many articles have each categories?

Example (I wanna get this kind of look):

Categories name (3)
subcategoriesname (2)
subcategoriesname (4)
subcategoriesname (7)

Categories name (5)
subcategoriesname (1)
subcategoriesname (14)
subcategoriesname (9)
subcategoriesname (2)
subcategoriesname (


Categories name (2)
subcategoriesname (28)
subcategoriesname (17)

Where the numbers represent how many categories and sub-items have articles

Hi    I want to echo out something when I post the value of a radio button and this value matches the same name of a html file. How can I formulate my code to achieve that?     What I have so far:

 <?php  
 
   if (isset($_POST['submitradio']))
{ 
    $selected_dir = $_POST['radio1'];

  echo substr($selected_dir, 0, -4);
  echo '<img src="'.$selected_dir.'" />';
  
} 
?>

So far I get for example the name of the image(order.gif) and the image order. gif.   What I now want is to formulate my code so that I can say if I have an image called "order.gif" and a file called "order.html" that I can then echo out some thing. I don't want to actually name the image or the html file. I just want to say if I have two different file types that start with the same name then I can echo out what ever. How can I do that?

I have a website http://www.pbm-biz.com/cricket/ where I am streaming Live Cricket world cup matches. My question is that during the streaming, I would like to keep the code in PHP so that others don't copy it. I can't find any solution. Any suggestions.

Thanks,

Faisal

Hello,

I am trying to get this backlink checker to work i have it working so it checks that the link itself matches and is there but this is the harder part that I don't understand.

I want to have it also check the nodeValue to make sure that it matches one of the nodeValue's from a mysql table

this is the code I have to make it check the href link

Code: [Select]
function CheckForTargetUrl($links, $target) {   
    foreach ($links as $link) {
        if (strpos($link, $target) !== false) {
            return true;
        }
    }

    return false;
}
                         
function ExtractHrefLinks($html) {
    $dom = new DOMDocument;
    $linkUrls = array();
     

    @$dom->loadHTML($html);
    $links = $dom->getElementsByTagName('a');
     
    foreach ($links as $link){
        $linkUrls[] = $link->getAttribute('href');
    }
   
    return $linkUrls;
}

function backlink_check($contenturl){

$url = 'businessinvestingsource.com';
$source = $contenturl;

$falseFound = false;

    $html = file_get_contents ( $source );
    $links = ExtractHrefLinks($html);
 
    if (CheckForTargetUrl($links, $url) === false) {
        $falseFound = "true";
        $reportArray[$source] = 0;
    } else {
        $falseFound = "false";
    }

return $falseFound;
}
Now this all works fine, I just need it to check the actual nodeValue (anchor text as well) meaning check this:

<a href="http://google.com">Google</a>

There is a mysql table called "allowed_anchors" with 2 rows "id" and "anchor"

I need it to check if the nodeValue matches 1 of the allowed_anchors from the table.

If anyone knows how I can do this that would be very great i have been trying to figure it out for hours with no luck.

Thanks very much for any help to come.

Folks,

I have a dropdown, once values are selcted, these values should be put in a URL structure so that it matches with the one MoD_rewrite rule in my .htaccess.

Here is my Mod_Rewrite Rule:

   RewriteRule ^(.*)/([^/]*)\.html$ search.php?q=$1&sc=$2 [QSA,L] 


Here is my Dropdown Code:

 <div id="search" >

<form id="searchform" method="get" action="search.php">
<label>Search By Brand/ Manufacturer: </label>

<select name="q">

<option value="SelectBrand">Select Brand</option>

<?php if(isset($this->search->options)): ?>
<?php foreach($mfg as $lolachild): ?>

  <option value="<?php echo $lolachild; ?>"><?php echo ucwords($lolachild); ?></option>

<?php endforeach; ?>
<?php endif; ?>

</select>

<select name="sc">

  <option value="All"><?php eprint(LangAll); ?></option>
<?php if(isset($this->search->options)): ?>
<?php foreach($this->search->options as $cat): ?>

  <option value="<?php echo $cat->value; ?>"><?php echo $cat->name; ?></option>
<?php endforeach; ?>
<?php endif; ?>

</select>

        <input type="submit" value="<?php eprint(LangSearch); ?>" />

</form>

 </div> 



Problem is, upon Submit, it goes to this link structu

http://mydomain.co.uk/search.php?q=fisher&sc=302

It should rather be:

http://au2.co.uk/fisher/302.html

What am i missing or doing wrong?

Cheer
Natasha

This code works, I am trying to disqualify certain keywords from a website I am scraping. For some reason, the D in the word dishwasher keeps a match from happening so i have to do this without the d. I just dont understand WHY.
I tried it where both of them use Clean_String() which has a strtolower and tirm in it. The subject looks right, I tried utf8_encode() to make sure they were both the correct encoding but nothing works.

Can anyone explain why the letter D is causing the word 'dishwasher' to not trigger strpos when I have the word 'dishwasher' in my disqualify array?

$disqualify = array("ish-washer","ishwasher");
foreach($disqualify as $dis)
{
if(strpos(Clean_String($subject[0]), $dis))
{
$status = 0;
$color = "FF0000";
}
}

Hey All,

I need to count and display the number of rows I have.


<?php

//declare the SQL statement that will query the database
$query = "
SELECT COUNT(id) FROM connectvisits
WHERE staffid = '$staffid'
 ";

//execute the SQL query and return records
$result = mssql_query($query);

$thismonth = mssql_num_rows($result);

echo "Total Meetings This Month: ";
echo $thismonth;
echo "<br />";

?>


For some reason I keep getting a result of 1. Everything else I try gives me a "Resource ID" number. Any help would be apprecaited. Maybe I have the completely wrong code. Thanks!