PHP - Need Help Breaking Up Code

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,

I am trying to break down the tables i have on my website in order to place them into my mySQL database. I am new to php and have been having some trouble and any help would be greatly appreciated.

So far I have this but it doesnt seem to be working. I am using DOMDocument but I wonder if maybe preg_match woulf be better?


Fatal error: Call to a member function getElementsByTagName() on a non-object in D:\Hosting\5915198\html\2.php on line 11




<?php
// Load html string
$dom = new DOMDocument();
$dom->loadHTML('www.empirebuildingsestate.com/company.html');

// Get tables from html
$tables = $dom->getElementsByTagName('tr');


// Get rows from tables
$rows = $tables->item(0)->getElementsByTagName('td');

// Loop over each row
foreach ($rows as $row)
{
   // Get each column by tag name
   $cols = $row->getElementsByTagName('td');
   
   
   // Echo values (here you can assign them in array for example)
   echo $cols->item(0)->nodeValue.'<br />';
   
   echo '<hr />';
   }
?>

I have a site that everything was typed manually, but I want to get all this info off so I can put all info into a database for easier editing and so forth.   I'm trying this code, which works to a point.

function curl($Url){
  
    if (!function_exists('curl_init')){
        die('cURL is not installed. Install and try again.');
    }
  
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $Url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$output = curl_exec($ch);
curl_close($ch); 
 
$start = strpos($output, '<h2 style="text-align: center;"><span style="text-decoration: underline;">Alabama Tattoo Shops</span></h2>');
$end = strpos($output, '<p>', $start);
$length = $end-$start;
$site = substr($output, $start, $length);
 
$site = explode("<p>", $site);
 
foreach ($site AS $line) {
 
    print_r($line);
  }
 
    return $output; 
}
$site = curl('http://www.tattooshopusa.com/alabama/');

 

I'm experimenting with a basic CRUD App.  The table created by the code below renders, however when I view source, the last tag is the closing </tr> after the while loop finishes.  There's nothing after that.  No closing table, html, or body tags.  I can't see what I've done wrong.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Eric's PHP CRUD App</title>
<style type="text/css">
table {
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-size: 10px;
    text-align: center;
    margin: 0 auto;
}
table td {
     text-align:center;
    border: 1px solid #dfdfdf;
}
tr:nth-child(odd) {
    background: #fdfdfd;
}
tr:nth-child(even) {
    background: #B8D3FF;
}
th {
    background-color:#ccc;
}
.center {
    width: 1050px;
    margin:0px auto;
}
h1 {
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-size: 14px;
    padding-bottom: 15px;
    text-align: center;
    margin: 0 auto;
    color: white;
}
</style>
</head>

<body bgcolor="#999">
<?php

   require_once("db_connect.php");
   
   echo "<h1>Update Student Records</h1>";
   echo "<table cellpadding='10'>";
   echo "<tr bgcolor='#cccccc'>";       
   echo "<th>First Name</th>";
   echo "<th>Last Name</th>";
   echo "<th>Test 1 Grade</th>";
   echo "<th>Test 2 Grade</th>";
   echo "<th>Test 3 Grade</th>";
   echo "<th>Test 4 Grade</th>";
   echo "<th>Final Exam Grade</th>";
   echo "<th>Average Grade</th>";
   echo "<th>Final Grade</th>";
   echo "<th>delete</th>";
   echo "<th>edit</th>";
   echo "</tr>";
 
  $sql = "SELECT * FROM students";
  $result = mysqli_query($link, $sql) or die(mysql_error());
 
 
   while($row = mysqli_fetch_array($result, MYSQLI_ASSOC) or die(mysql_error())) {
       $final = "";
       $average = (($row["test1Grade"]) + ($row["test2Grade"]) + ($row["test3Grade"]) + ($row["test4Grade"]) + ($row["finalExamGrade"])) / 5;
       if ($average >= 90)
       {
          $final = "A";  
       } else if ($average >= 80)
       {
          $final = "B";   
       } else if ($average >= 70)
       {
          $final = "C";   
       } else if ($average >= 60)
       {
          $final = "D";   
       } else if ($average < 60)
       {
          $final = "F";   
       }
       echo "<tr>";       
       echo "<td>" . $row["firstName"] . "</td>";
       echo "<td>" . $row["lastName"] . "</td>";
       echo "<td>" . $row["test1Grade"] . "</td>";
       echo "<td>" . $row["test2Grade"] . "</td>";
       echo "<td>" . $row["test3Grade"] . "</td>";
       echo "<td>" . $row["test4Grade"] . "</td>";
       echo "<td>" . $row["finalExamGrade"] . "</td>";
       echo "<td>" . round($average) . "</td>";
       echo "<td>" . $final . "</td>";
       echo "<td><a href='delete.php?id=" . $row['studentID'] . "'>&rsaquo;</a></td>";
       echo "<td><a href='update.php?id=" . $row['studentID'] . "'>&rsaquo;</a></td>";
       echo "</tr>";
   }
   echo "</table>";
?>
   <a href='insert.php'>Add new student</a>
</body>
</html>

Edited by Ch0cu3r, 13 November 2014 - 01:07 PM.
Added code tags

If i have a list of categories like:
1. Billboards and advertisement section
  1(a)City Clock
    1(a)(i)Application fee  (has columns for approved price and proposed price)
    1(a)(ii)Advertisement Per year (has columns for approved price and proposed price)

  1(b)Billboards
    1(b)(i)Application fee for construction (has columns for approved price and proposed price)
    1(b)(ii)Charge per year without advertisement (has columns for approved price and proposed price)

  1(c)Something here.....
    1(c)(i) something here...(has columns for approved price and proposed price)
    1(c)(ii)something here...(has columns for approved price and proposed price)
    1(c)(iii) something here... (has columns for approved price and proposed price)
     e.t.c

THEN SOME CATEGORIES LOOK LIKE:category 2
2. Category name
  2(a)something here..(has columns for approved price and proposed price)
  2(b)something here..
    2(b)(i)something here..(has columns for approved price and proposed price)
    2(b)(ii)something here..(has columns for approved price and proposed price)



NOW: i have categories without sub categories and others with sub-sub categories , a main category doesn't does have a column for prices ( or lets just say other columns) , a sub category WITHOUT its sub category will have columns for prices, if a sub category has its sub category, then its subcategory should have columns for prices (this is where my problem is - how do i handle such a situation in php Mysql?? )

Hey guys,
How can i break just one cycle of a foreach loop.

Example:


$arr = array('0','1','2');

foreach ($arr as $value){
 if($value == 1){ break from this iteration and continue onto next one}
echo $value;
}


So the output should be
02

If I break up this long line of code will it still work correctly?

Original...
Code: [Select]
define('WEB_ROOT', ENVIRONMENT === 'dev' ? 'http://localhost/example.org/' : 'http://example.org/');

Desired...
Code: [Select]
define('WEB_ROOT', ENVIRONMENT === 'dev'
? 'http://localhost/example.org/' : 'http://example.org/');
Or maybe...
Code: [Select]
define('WEB_ROOT', ENVIRONMENT === 'dev'
? 'http://localhost/example.org/'
: 'http://example.org/');

Debbie

First of all... this is a GREAT forum. Been lurking around here for a long time and searched all over but still can't find a solution to a problem I'm facing.

Here's my cURL code - I am basically retrieving data from a web site:
<?php

$curl_handle=curl_init();
curl_setopt($curl_handle,CURLOPT_URL,'http://myprimemobile.com/update.html');
curl_setopt($curl_handle,CURLOPT_CONNECTTIMEOUT,2);
curl_setopt($curl_handle,CURLOPT_RETURNTRANSFER,1);
$buffer = curl_exec($curl_handle);
curl_close($curl_handle);

if (empty($buffer))
{
    print "Connection Timeout<p>";
}
else
{
    print $buffer;
}
?>

If you take a look at the site http://myprimemobile.com/update.html -- it will begin to update new information. I want to basically retrieve the data from that page but in my own way.

I want to loop through the page and search for all the names, addresses, and phone numbers only (not store hours or anything else), and want to put it in a variable so I can create a table with all that information on my page.

Based on the code, all the information is stored in the $buffer variable. I want to break this variable down to extract certain data in a 'div' or a 'table'. Please help me out. Thanks!

Hi guys,

So here is the deal.

We have a list of brands that excists in a database. There are also images associated with the names. But not all the brands have images. So in the script i read if the file excists.

Well this all works fine but it looks horrible. So i want to break the list in half (or limit it to 24). But i cant limit the sql query.

Is there a way to "limit" a while loop and let it resume on the same page, just to change the layout (multiple collumns)? (I hope i am clear on this... i confuse even myself)



$host = 'localhost';
$user = 'qwerty';
$pass = 'qwerty';
$db = 'qwerty';

$query = "SELECT * FROM ros_brands";

$result = mysql_query($query) or die(mysql_error());

$filename = "/resources/images/mm_files/" . $row['image_file_id'] . ".gif";

while($row = mysql_fetch_array($result)){

$filename = "/var/www/vhosts/test.nl/httpdocs/resources/images/mm_files/" . $row['image_file_id'] . ".gif";

if (file_exists($filename)) {
        echo    "<a href='#'><img src='/resources/images/mm_files/" . $row['image_file_id'] . ".gif' /><span>". $row['name'] ."</span></a>";

} else {
//    echo "The file $filename does not exist";
}

}

Hi all,

In order to teach myself php I am developing a simple cms system to display my graphic design work. Basically I am working on developing a simple portfolio website powered by a custom made CMS.

So far, I can create new posts which are being stored in a MySQL db.

My index page runs a sql query to get the latest posts and sorts them by category.

Currently the results look like this:

Quote

Title1
Category A
Text

Title2
Category A
Text

Title3
Category B
Text

Title4
Category B
Text


The code to generate this looks like this:

$content = mysql_query("SELECT * FROM posts ORDER BY category, date DESC");

while($row = mysql_fetch_array($content))
  {
  echo '<h2 class="post_title">'.$row['title'].'</a></h2>';
  echo '<p class="cat">category: '.$row['category'].'</p>';
  echo '<p class="post_body">'.$row['body'].'</p>';
  echo '<p class="image">image: '.$row['image'].'</p>';
  echo '<p class="lowerlefttext_metainfo">by <span class="lowerlefttext_author">'.$row['author'].'</span> on '.$row['date'].'</p>';
  }

What I would like however is this:

Category A

Title 1
Text

Title 2
Text

Category B

Title 3
Text

Title4
Text

I am not sure how to do this elegantly without having to code an sql query per category, which I don't think is efficient?

Thank you!

Hey all

I'm working on an auction website. I've added a new column to the 'Auctions' table, however the 'sell.php' page now does not work with this new column (I've deleted the column and tested again and it works, so that's definitely the cause). The new column can not be in a separate table as it needs to pull 'id' values from the 'Auctions' table for various functions.

My question to you is, is there any PHP snippet I can use to tell sell.php to stop reading the 'Auctions' table once it reaches the column I've added? The new column is called 'shipped' if that's of any relevance.

Below is some of  the PHP I'm working on on the sell.php page.


  #//Populate arrays
                $UPLOADED_PICTURES[] = $file;
                $UPLOADED_PICTURES_SIZE[] = filesize($image_upload_path.session_id()."/".$file);
              }
            }
          }
          $_SESSION["UPLOADED_PICTURES"] = $UPLOADED_PICTURES;
          $_SESSION["UPLOADED_PICTURES_SIZE"] = $UPLOADED_PICTURES_SIZE;
          $_SESSION["GALLERY_UPDATED"]=true;
          if($sessionVars['SELL_action']=='edit') {
            $sessionVars["OLD_GALLERYFEE"] = $SETTINGS["picturesgalleryvalue"] * count($UPLOADED_PICTURES);
          } else {
            $sessionVars["OLD_GALLERYFEE"] = 0;
          }
        }
      }
    }
    $with_reserve = $sessionVars["SELL_with_reserve"];
    $reserve_price = $sessionVars["SELL_reserve_price"];
    $minimum_bid = $sessionVars["SELL_minimum_bid"];
    
    $duration_hours = $sessionVars["SELL_duration_hours"];
    $duration_minutes = $sessionVars["SELL_duration_minutes"];
    
    $pict_url=$sessionVars["SELL_pict_url"];
    $imgtype = $sessionVars["SELL_file_uploaded"];
    $title = $sessionVars["SELL_title"];
    $description = stripslashes($sessionVars["SELL_description"]);
    $pict_url = $sessionVars["SELL_pict_url"];
    $atype = $sessionVars["SELL_atype"];
    $adultonly = $sessionVars["SELL_adultonly"];
    $TPL_item_value = $item_value = $sessionVars["SELL_item_value"];
    $TPL_number_of_bids =$number_of_bids=$sessionVars["SELL_number_of_bids"];
    $TPL_bid_value = $bid_value = $sessionVars["SELL_bid_value"];
    $iquantity = $sessionVars["SELL_iquantity"];
    $buy_now = $sessionVars["SELL_with_buy_now"];
    $buy_now_price = $sessionVars["SELL_buy_now_price"];
    $duration = $sessionVars["SELL_duration"];
    $duration_second = $sessionVars["SELL_duration_second"];
    $minimum_users = $sessionVars["SELL_minimum_users"];
    $relist = $sessionVars["SELL_relist"];
    $increments = $sessionVars["SELL_increments"];
    $customincrement = $sessionVars["SELL_customincrement"];
    $international = ($sessionVars["SELL_international"])?"on":"";
    $sellcat = $_SESSION['sellcat'];
    $private = $sessionVars["SELL_private"];
    if($private != 'y') $private = 'n';
    $sendemail = $sessionVars["SELL_sendemail"];
    $txt = $sessionVars["SELL_txt"];
    $num = $sessionVars["SELL_num"];
    $buy_now_only = $sessionVars["SELL_buy_now_only"];


and...


$auction_id=$sessionVars['SELL_auction_id'];
  } elseif ($sessionVars["SELL_action"] == "reopen") {
    $query =
    "UPDATE BPLA_auctions set
       title = '".addslashes($sessionVars["SELL_title"])."',
       starts = '".$a_starts."',
       starts_second = '".$a_starts_second."',
       description = '".addslashes($sessionVars["SELL_description"])."',
       pict_url = '".addslashes($sessionVars["SELL_pict_url"])."',
       category = ".$sessionVars["SELL_sellcat"].",
       minimum_bid = '".$sessionVars["SELL_minimum_bid"]."',
       reserve_price = '".(($sessionVars["SELL_with_reserve"]=="yes")?$sessionVars["SELL_reserve_price"]:"0")."',
       buy_now = '".(($sessionVars["SELL_with_buy_now"]=="yes")?$sessionVars["SELL_buy_now_price"]:"0")."',
       bn_only = '".$sessionVars["SELL_buy_now_only"]."',
       auction_type = '".$sessionVars["SELL_atype"]."',
       adultonly = '".$sessionVars["SELL_adultonly"]."',
       duration = '".$sessionVars["SELL_duration"]."',
       duration_second = '".$sessionVars["SELL_duration_second"]."',
       minimum_users = ".intval($sessionVars["SELL_minimum_users"]).",
       increment = ".doubleval($sessionVars["SELL_customincrement"]).",

       
       
       international = '".(($sessionVars["SELL_international"])?"1":"0")."',
       ends = '".$a_ends."',
       ends_second = '".$a_ends_second."',
       photo_uploaded = ".(($sessionVars["SELL_file_uploaded"])?"1":"0").",
       quantity = ".$sessionVars["SELL_iquantity"].",
         relist=".intval($sessionVars["SELL_relist"]).",
         relisted=0,
         closed='0',
       private='n',
       item_value = '".$sessionVars["SELL_item_value"]."',
       number_of_bids = '".$sessionVars["SELL_number_of_bids"]."',
       bid_value = '".$sessionVars["SELL_bid_value"]."',       
       suspended='".$SUSPENDED."',";
       $query .= "current_bid=0,
       num_bids=0,
       
       WHERE id = '".$sessionVars["SELL_auction_id"]."'";
    $backtoclosed=true;
    

if($BPLowbidAuction_TESTMODE == 'yes'){

echo $ERR = $ERR_9999;

}else{
    $res=mysql_query($query);
    if (!$res) {
      MySQLError($query);
      exit;
    }

    $auction_id=$sessionVars['SELL_auction_id'];
    $sessionVars["SELL_auction_id_old"]=$auction_id;
    $query = "DELETE FROM BPLA_bids WHERE auction='$auction_id'";
    $res = @mysql_query($query);
    if(!$res) {
      
      MySQLError($query);
      exit;
    }


Thanks in advance for any help and replies! 

I'm not sure what PHP considers an "aborted connection" and things like that, but the way this chat works is by updating a file and using the timestamp off it to determine if new posts exist.  Rather than re-checking the server over and over, this code will check once and keep the connection open until a response is made.  The only problem is, it works too well!  Even after the tab is closed and I try another script on the site or the same script, it all hangs until I update the file - here is the code snippet:


while (($currentmodif <= $lastmodif) && (connection_aborted() == 0) && (connection_status() == 0)){ // check if the data file has been modified

    usleep(10000); // sleep 10ms to unload the CPU
    if (connection_aborted ()) break;
    if (connection_status () != 0) break;
    clearstatcache();
    $currentmodif = filemtime($filename);
    }


I have put several measures in to attempt to break the loop when the user disconnects, but it just doesn't work!  It will continue to hang and hang and hang until I re-upload the file $filename

HOW CAN I BREAK THE WHILE LOOP WHEN THE MEMBER LEAVES THE PAGE?

I could post up an example but its ultimately useless after one load unless you have control over updating the file.

Thanks!

I am trying to add a background image via a custom style, but it breaks my site. I am a php novice, can someone point out my error please?

The echo is being used other places on this page, so I know this code is ok:

<?php echo $event->data->thumbnails['medium']; ?>

but I am missing something here, this keeps breaking the page:

<?php
        echo '<article data-style="'.$label_style.'" style="background-image:url(\<?php echo $event->data->thumbnails['medium']; ?>\")" class="mec-event-article mec-clear '.$this->get_event_classes($event).'"' . $colorful_bg_color . '>';
?>

Thanks for any help, as I learn!

Here's the site: http://www.secretauctions.com/thank_atv_cb754.php#  (If anyone wants to see how the problem is occurring.  The Username and Password shown on the page are functional.)

Here's the problem: Whenever anyone tries to click to the second page of results, the Session fails.  Here's a short version of the code:

Code: [Select]
<?php
$username = "user493d";
$password = "w7atv"; 

session_start();  
$my_array=array($username, $password);
$_SESSION['login']=$my_array;

if ($_SESSION['login'][0]=="user493d" && $_SESSION['login'][1]=="w7atv")
include("atv_list.php"); 
else
include("sorry1.php"); 
?>
This works GREAT on the initial log-in.  But the moment anyone tries to go to the second page of results, the Error state trips, and they get the "sorry" page.  This isn't supposed to happen.  This is my first foray into Sessions, so I'm certain there's something I'm not understanding, but shouldn't the above code store the username/password, then use it to verify page reloads?  Can anyone tell me why it's allowing the Fail state to trip, when the initial test succeeds?  Or am I doing the whole thing wrong?