PHP - Moved: Php Like Case Sensitive?

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=327423.0

I have taken over a wordpress site that a web developer set up and he is no longer working with me so I cant get his help with it, I have a custom front page that has been pulling press releases that where posted previously and categorized as "press" I was asked to add a blog which I did by categorizing the post as "blog"

In a nutshell, I now need the front page code to pull a mixture of both the "press" and "blog" each category has a numerical id so blog is 7 and press is 3

This is the current code that is in the page
<?php query_posts('category_name=press&showposts=10&offset=0'); ?>

I looked up wordpress support for this, and found this
query_posts(array('category__in' => array(2,6)));

How can I integrate this if possible with the top line so it pulls the newest posts from both categories? Any suggestions could REALLY help me out!

Thanks!

Hello,

I am completely new to php so please forgive me ahead of time. I am trying to create a link button on a website for a client that only directs to a certain external website on certain days and hours. Specifically, this is a web radio button that the client only wants to link to the web radio site when their live broadcast is on the air during certain hours on the weekend (i.e. Sundays 8-10 PM). Any other time, the client wants the web radio button to link to a default page since the web radio station plays unrelated music all other hours of the week. Does anyone know the best way to create such a time sensitive link for a button on a webpage?

Thanks.

I am by no means a security expert, but I would like to know if storing MySQL database information in an environment variable would be a good or bad idea. What are your thoughts?

Hi, I have the following code:

Code: [Select]
case "Twitter";
        echo 'Twitter gadget will show here';
   break;

I  need to make it so it's like this:

Code: [Select]
case "Twitter" AND $member['top'] == "1"
echo "Twitter Gadget will show here";
break;

I need to add a IF onto the CASE is it possible?

Thank you.

hey guys im having a few problems with my query if anyone can please help...the two problems im having is   1.the total price returning as 00106. price = 100.00 and p_and_p = 6.00 in the database...im after a figure that looks like 106.00   2. @category will be a parameter like :category which will be binded to a value like 'al'l, 'videos', 'dvd's', but if the parameter is ALL i dont want to join my categories table allowing it to select all rows regardless of the category   any help, pointer would be truly appreciated...thank you

SELECT @category := 'Videos',
		         i.item_id, 
		         i.title, 
		         i.price,
		         i.p_and_p,
		         SUM(i.price + i.p_and_p) AS `total_price`,
		         i.listing,
		         i.condition,
		         CONVERT_TZ(DATE_ADD(i.start_date_time, INTERVAL concat(i.listing_duration) DAY), '+00:00', u.time_zone) AS `end_date_time`
		  FROM items i
		  LEFT JOIN sub_categories sc ON sc.sub_category_id = i.sub_category_id
  		  CASE @category != 'All'
          THEN 
		  LEFT JOIN categories c ON c.name = 'Videos'
          END CASE		
		  JOIN users u
		  WHERE u.user_id = '7'
		  AND MATCH (i.title, i.description) AGAINST ('bla' IN BOOLEAN MODE)
		  AND i.start_date_time < NOW() 
		  AND DATE_ADD(i.start_date_time, INTERVAL concat(i.listing_duration) DAY) >= NOW()
		  GROUP BY i.i

hi,

i just wanted to know...

$arr[0] $arr[1] $arr[2] also this $arr[1] would be called a value, but how are the numbers 0,1 and 2 called? are that keys?

didn't know where else to post this question.

can i do something like this?

Code: [Select]
<?php
switch ($i) {
    case 0:
        echo "i equals 0";?>
////////////// html stuff ////////
<?php
        break;
    case 1:
        echo "i equals 1"; ?>
///////////////////html stuff//////////////
<?php
        break;
    case 2:
        echo "i equals 2"; ?>
////////////html stuff///////////////
<?php
        break;
}
?>

i've read and seen there are variations of what im trying to achieve but havent seen a exact example...what im trying to do is put a where clause in my query depending on if a set variable has a value

CASE WHEN (@category_id IS NOT NULL)
THEN
LEFT JOIN sub_categories sc ON sc.sub_category_id = i.sub_category_id
JOIN categories c ON c.category_id = sc.category_id AND c.category_id = :category_id
END

is this possible or have i just got the syntax wrong somewhere...thank you guys

I have a pspell script and I want it to ignore upper case. ie at the moment if I check spelling for say christopher it returns spelling error of Christopher (upper case C)



<?php

$query = 'helllo';

    $pspell_config = pspell_config_create("en");
    pspell_config_ignore($pspell_config, 5);
    pspell_config_mode($pspell_config, PSPELL_FAST);
    pspell_config_personal($pspell_config, "/home/*/public_html/custom.pws");
    pspell_config_repl($pspell_config, "/home/*/public_html/custom.repl");
    $pspell_link = pspell_new_config($pspell_config);

    $words = preg_split ("/\s+/", $query);
    $ii = count($words);

    global $spellchecked;
    $spellchecked = "";

    for($i=0;$i<$ii;$i++){

        if (pspell_check($pspell_link, $words[$i]))
        {
            $spellchecked .= $words[$i]." ";
        }
        else
        {
            $erroneous = "yes";
            $suggestions = pspell_suggest($pspell_link, $words[$i]);
            $spellchecked .= $suggestions[0]." ";
        }
    }
    if($erroneous == "yes")
    {
        $spellchecked2 = str_replace(" ", "+", $spellchecked);
        echo "Did you mean: <a href=GetSearchResults.php?Query=$spellchecked2&catID=&siteID=3><i>".$spellchecked."</a></i>?";
    }
    else
    {
        echo $spellchecked . " is a valid word/phrase";
    }
?>

I have this $str variable which say holds "String" and in my comparison I'm checking if it's content is "string" and it is supposed to return true but it isnt because of the case, how do I compare them without the case being an issue ?

Hello, I am having a small issue with a case switch array that uses a range of data. I am using it to set the background of table cells depending on the data. I.E. 0-0.9, 1-1.9 etc with each one being a different color. Issue I am having is it doesn't change. It sets it based on the first array entry. What might I be missing? This is the first time I have used a case switch with a range.    -Thanks

$magScale = '';

           switch($magnitude)
{
              case myInterval >= 0 && myInterval <= 0.9: $magScale = 'rgb(195, 218, 236)';
                             break;
              case myInterval >= 1 && myInterval <= 1.9: $magScale = 'rgb(210, 238, 197)';
                             break;
              case myInterval >= 2 && myInterval <= 2.9: $magScale = 'rgb(244, 240, 202)';
                             break;
              case myInterval >= 3 && myInterval <= 3.9: $magScale = 'rgb(244, 223, 202)';
                             break;
              case myInterval >= 4 && myInterval <= 4.9: $magScale = 'rgb(240, 199, 205)';
                             break;
              case myInterval >= 5 && myInterval <= 10:  $magScale = 'rgb(212, 195, 236)';
                             break;

}

My case statement is not working. What happened is that two students got a $markgrade of 61 and 67. So they both should get grade B but instead they both get Grade A. 1 student got 55 which should be grade C but gets grade A. why is it not following the switch statement?

Code: [Select]
    function outputModule($moduleID, $moduleName, $sessionData)   
     
      {       
     
      if(!count($sessionData)) { return false; } 
   
   
    $markTotal = 0;       
          $markGrade = 0;
          $weightSession = 0;
          $grade = "";
          $sessionsHTML = ''; 
         
          switch($grade){
        case ($markGrade >=70):
        $grade = 'A';
        break;
        case ($markGrade >=60 && $markGrade <=69):
        $grade = 'B';
        break;
        case ($markGrade >=50 && $markGrade <=59):
        $grade = 'C';
        break;
        case ($markGrade >=40 && $markGrade <=49):
        $grade = 'D';
        break;
        case ($markGrade >=30 && $markGrade <=39):
        $grade = 'E';
        break;
        case ($markGrade >=0 && $markGrade <=29):
        $grade = 'F';
        break;
        };     
         
          foreach($sessionData as $session)        {           
         
           $sessionsHTML .= "<p><strong>Session:</strong> {$session['SessionId']} {$session['Mark']} {$session['SessionWeight']}%</p>\n";           
           $markTotal += ($session['Mark'] / 100 * $session['SessionWeight']);
           $weightSession  += ($session['SessionWeight']); 
           $markGrade = ($markTotal /  $weightSession * 100);   
           
           }       
           
           $moduleHTML = "<p><br><strong>Module:</strong> {$moduleID} - {$moduleName} {$markTotal} {$markGrade} {$grade}</p>\n";     
   
     return $moduleHTML . $sessionsHTML;    }

Is there a way to change the statement below so that it ignores case sensitivity of the variable?  for instance, the statement would be true if $category == 'Admissions', 'ADMISSIONS', 'admissions', etc.   For some reason I'm having the worst time finding this via google search and know y'all will be able to help!

if ($category == 'Admissions') {
echo '&nbsp;&nbsp;<a href="#">-Forms</a><br />&nbsp;&nbsp;<a href="#">-Tuition</a><br />'; } ?>

Thanks!

i want to make a simple forced lower case  form but i got stuck on it  to begin with i want to everything user's write and submit convert to lowercase am i using the right code? i'm not sure about using preg_match in this situation but i dont know what else to do
don't be harsh with me i'm noob     

<?php
if(isset($_GET['user'])&&!empty($_GET['user']))
{
$user = $_GET['user'];
if (preg_match('$englishUpperAlphabet'//English alphabet Upper case  array//',$user)){
$user = mb_strtolower($user);
echo $user;
}
else{
echo 'none';
}}
?>

<form action="t.php" action="GET">
name:
<input type="text" name="user" > <br>
<input type="submit" value="submit" >
</form>