PHP - Ascii Code Breaking In_array

onlinegamekey. com/MTGT-Auction.php is the page I'm working on.

The problem I'm having is cards with an apostrophe in the name breaks the operation.

I am populating the Select Box with the Card Names and those are coming in fine, its not until I try to use the select value to get that specific card data do I have an issue.
This query specifically
Code: [Select]
$quer2=mysql_query("SELECT * FROM auctions WHERE Card_Name ='$cards' Order By Price_Per") or die;
I've tried
$quer2=mysql_query("SELECT * FROM auctions WHERE Card_Name =" . htmlspecialchars($cards) . " Order By Price_Per") or die;
but then I get no data for any card.

Here is the page code I'm working with.

Code: [Select]
<?php
$cards = $_POST['cards'];
//SELECTING DATA FOR THE DROPDOWN
$sql = "Select Card_Name From auctions Group BY Card_Name ASC" or die;
$result = mysql_query($sql);
?>
<script type="text/javascript">
<!--
var optList;
var optsValue = new Array();
var optsText = new Array();
//when the page loads get the original options values and text and store them in arrays
window.onload = function() {
optList = document.getElementsByTagName("option");
for(var i=0; i<optList.length; i++) {
     optsValue[i] = optList[i].value;
     optsText[i] = optList[i].text.toLowerCase();   
}   
}
function searchSel(txtSearch) {
//clear all the current options
document.getElementById("items").options.length = 0;
var count = 0;
for(var i=0; i < optsValue.length; i=i+1) {
    if(optsText[i].indexOf(txtSearch.toLowerCase()) == 0) {  //match found
         //add this option to the select list options
         var newOpt = new Option(optsValue[i],optsText[i],false,false);
         document.getElementById("items").options[count] = newOpt;
         count = count+1;
    }
    }
}
function reload(form)
{
var f1 = document.forms['f1']
var val=f1.cards.options[f1.cards.options.selectedIndex].value;
self.location='MTGT-Auction.php?card=' + val ;
}
//-->
</script>
<style type="text/css">
body {
background-color:#000000;
}
.row-one {
    background-color: #666666;
    font-family: Arial, Helvetica, sans-serif;
font-size:12px;
font-weight: bold;
    line-height: 17px;
    color:#CCFF33;
}
.row-two {
    background-color: #333333;
    font-family: Arial, Helvetica, sans-serif;
font-size:12px;
font-weight: bold;
    line-height: 17px;
    color: #FF0;
}
.th {
background-color:#000000;
font-family:Arial, Helvetica, sans-serif;
font-size:14px;
font-weight:bold;
color:#CC0000;
padding: 2;
}
</style>
<!-- CREATE FORM & SELECT BOX -->
<form method="post" name="f1" action="MTGT-Auction.php">
    <select name="cards" id="items">
    <option value='0'>Select...</option>
    <?php while ($row=mysql_fetch_array($result)) {
if ($row['Card_Name']==@$cards) {
echo "<option selected value='$row[Card_Name]'>$row[Card_Name]</option>";
} else {
echo "<option value='$row[Card_Name]'>$row[Card_Name]</option>";
}
}
 ?>
    </select>
    <br />
     <input type="text" id="txt" value="Card Name?" onfocus="this.value==this.defaultValue?this.value='' :null" onkeyup="searchSel(this.value);" style="color:#000000; font:Arial; font-size:12px; background-color:#e1e1e1;" />
     <BR />
<input type="submit" value="Submit" name="submit" />
                        <input type=button onClick="location.href='MTGT-Auction.php'" value='Reset' />
            </form>
            <!-- CREATE TABLE WHERE DATA GOES -->
<table border="1" bordercolor="#000000">
<tr align="center">
<th class="th">Auction ID</th>
<th class="th">Card Name</th>
<th class="th">Cards Per Auction</th>
<th class="th">Auction Price</th>
<th class="th">Cost Per Card</th>
<th class="th">Date Listed</th>
<th class="th">Seller Name</th>
</tr>
<?php
//GET DATA FOR TABLE BASED ON SELECTED CARD & LOOP THROUGH
$quer2=mysql_query("SELECT * FROM auctions WHERE Card_Name ='$cards' Order By Price_Per") or die;
$i =1;
WHILE($row = mysql_fetch_array($quer2)) { 
if ($i%2 !=0)
$rowColor = "class='row-one'";
else
$rowColor = "class='row-two'";
echo "<tr $rowColor>" . "<td>" . $row[Auction_ID] . "</td><td>" . $row[Card_Name] . "</td><td>" . $row[Qty_Listed] . "</td><td>" . $row[Price] . "</td><td>" . $row[Price_Per] . "</td><td>" . $row[Date] . "</td><td>" . $row[Seller] . "</td></tr>";
$i++;
}
//}
?>
<?php
//QUICK CHECK IS OUR VARIABLE SET???
echo "<font color=\"#FFFFFF\">". $cards . "</font>";
?>
</table>
I image this is probably a very common problem & easy fix that has been answered many times, but I haven't found any thing that worked for me so any help.. or links to similar issues would really be appreciated.

Thank you,

Hey guys I'm having a bit of a problem trying to convert this string to UTF-8 encoding

Quote

&#32068;&#12391;&#12377;&#12364;&#12289; &#20013;&#12395;&#12399;&#65301;&#65293; &#65302;&#26412;&#12398;&#12362;&#12377; &#12377;&#12417;&#30058;&#32068;&#12398; &#12456;&#12483;&#12475;&#12531;&#12473; &#12364;&#12289;&#12366;&#12387;&#12375; &#12426;&#35440;&#12414;&#12387;&#12390; &#12356;&#12414;&#12377;&#12290;


I've used
$strTem = mb_convert_encoding($strTem, "UTF-8", "auto");
and while that detects the correct current encoding it doesnt change it at all and utf8_encode doesnt work at all, dont know what to use.

Thanks

I am writing a script to read a mail box and fetch mail body using php function "imap_fetchbody".
If mail content encoding is UTF-8 then no problem but mail send from IPAd having ascii encoding and replace the new line with =20  along with many other changes.

can anyone help me out with this in converting it to UTF-8 ??

Heres my code:

Code: [Select]
$string = '&#73&#116';
html_entity_decode($string);
echo $string;
It should be echoing "It", but its just echoing the ASCII codes. Am I using the wrong function? I also tried htmlspecialchars_decode and it changes nothing.

Hey there,
wondering if anyone knows what this topic will be about okay lets start:

I have a search function on my site. Basically I do this:

Code: [Select]
if $_POST -> redirect ?search=$_POST

if $_GET['search'] - > sql_query($search);
Of course I am working with functions like
mysql_real_escape_string - addslashes - htmlspecialchars , but I have the following problem:

when redirecting chars like & % ? ! kill my $_GET var.

Which function solves this?

My solution:
I convert every char in $_POST into an ascii code -> redirect ?search=$ascii_codes
convert back into $string and do safe search.

I have the following code:

Code: [Select]
$str = ($stringcontents[$step+38]);
$str1 = ord($str);
$bgcolor = convertchar($str1);
?>
<td bgcolor='<?php echo $bgcolor;?>'>
<span title='<?php echo $fieldname;?>' style='color: <?php echo $fgcolor;?>; font-size: 12pt'><font color="<?php echo $fgcolor;?>"><?php echo $stringcontents[$step];?></font></span>

the convertchar function takes the ord value of the ASCII chr and sets a variable for bgcolor and fgcolor using HTML color codes.  The background sets correctly, but the foreground ASCII chr is always black and does not use the font color code.

What do I need to do to get the ASCII chr to change to a color other than black?


Added:
I am using a default charset:

<META http-equiv="Content-Type" content="text/html; charset=IBM437">

I can't access an array value in a multidimensional array.  The if should be echoing true.  $news['companyid'] is equal to 1, but I must not be using in_array correctly.

Code: [Select]
echo '<pre>';
print_r($own_company);

if (in_array($news['companyid'], $own_company))
{
echo "true";
}

Output
Array
(
    => Array
        (
            [companyid] => 1
            [companyname] => Oaysus
            [companytag] =>
            [companywebsite] => http://oaysus.com
            [country] => 1
            [state] => 0
            [city] =>
            [industry] => 4
            [stage] => 2
            [capitalrequested] =>
            [guestviews] => 0
            [iviews] => 3
            [eviews] => 3
        )

)

I know this works and that's why I'm puzzled. I'm bringing in data from a textarea and trying to compare it.

index.php
Code: [Select]
<form name"fruit-farm" action="fruit-check.php" method="POST">
<textarea name="fruit-list">
Apples
Bananas
Oranges
Pickles
Hamburgers
Grapes
</textarea>
<input type"submit" name="submit" value="Check The Fruit">
</form>

fruit-check.php
Code: [Select]
if (isset($_POST['submit'])) {

//Bring in the data
$fruit-list = explode("\n", $_POST['fruit-list']);

//Search for Hamburgers
$hamburgers = "Hamburgers";

 if (in_array($hamburgers,$fruit-list)){
echo "That is not a fruit";
 }

}

What's puzzling me is that it's not working. It must be something blantently obvious. It has something to do with the '$fruit-list' array and how it is being brought into the form. It posts fine. The reason I think this is the case is because if I simply create an array that is identical to the form coming in it works:

Code: [Select]
if (isset($_POST['Submit'])) {

//Bring in the data
$fruit-list = explode("\n", $_POST['fruit-list']);

//Search for Hamburgers
$hamburders = "Hamburgers";

$fruit-list = array('Apples', 'Bananas', 'Oranges', 'Pickles', 'Hamburgers', 'Grapes);

 if (in_array($hamburders,$fruit-list)){
echo "That is not a fruit";
 }

}

When I 'print_r' both arrays they both look identical. What is wrong and/or different with the way I'm bringing in the textarea that's causing this not to work?

Code: [Select]
$colorarray = isset($_POST['form']['color']) ? intval($_POST['form']['color']) : 0;

$color = array(
"1",
"2",
"3",
"4",
"5",
"6",
"7",
"8",
"8",
"9",
"10",
"11",
"12",
"13",
"14",
"15",
"16"
);
if (in_array($color, $colorarray)) {
    echo "search found";
exit;
}else{
echo "hacker";
exit;
}
i submit  my $_POST['form']['color'] as 1 through 16 and it always says hacker? 

This is PHP 101, but I'm struggling to see the obvious.  I have the query below which brings back a list of quizids.   I put them into an array using mysql_fetch_array. I then want to check to see if a certain quizid is actually in the quizzes table, so I thought I could simply us in_array.  But it's only checking the first quizid.  That doesn't make sense to me. Isn't mysql_fetch_array creating an array with all values automatically? 

If I actually have to use a "while" loop or something, can someone help me with how to write that code most efficiently.

Code: [Select]
$query = "SELECT quizid FROM quizzes";
$getquizids = mysql_query($query, $connection);
if (!$getquizids) {
die("Database query failed: " . mysql_error());
} else {
$allquizids=mysql_fetch_array($getquizids);
                    if (in_array($_GET['quizid'], $allquizids)) {
//continue since quiz exists
} else {
redirect_to('index.php');
}
 }

I have a section in one of my scripts that checks for a value in array and the value doesn't exist in the array then it add it.  This works fine for single array but not for mulit-dimensional arrays.  Has anyone had a similar problem and knows a good solution?

Code: [Select]
if(in_array($words[$i], $searchWords)){
    //Do nothing
}else{
    $searchWords[] = $words[$i];
}

hi i wants to skip few categories from xml feed but have problem, here is my code which is working:

foreach ($xml->channel->item as $item) { 

                foreach ($item->children() as $child) {
                    if ($child->getName() == 'category') {
                        $categories[] = (string) $child;
                    }
                }
if((in_array("one",$categorie) || in_array("two",$categorie)  in_array("three",$categorie))  {
continue;
}
// other code here
}


and here is what i wants to separate categories in $skipcats but its not working.

$skipcats = array("one","two","three");
foreach ($xml->channel->item as $item) { 

                foreach ($item->children() as $child) {
                    if ($child->getName() == 'category') {
                        $categories[] = (string) $child;
                    }
                }
foreach ($skipcats as $skip) {
if(in_array($skip,$categorie)) {
continue;
}
}
// other code here
}

please what i am missing.
thanks for any guidance .