PHP - Missing One Record From My Display...

Hey guys, I can't wrap my head around how to make this work right...

I have three tables:
Code: [Select]
CREATE TABLE `games` (
  `g_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`g_id`));

CREATE TABLE IF NOT EXISTS `game_player` (
  `r_id` int(11) NOT NULL AUTO_INCREMENT,
  `p_id` int(11) DEFAULT NULL,
  `g_id` int(11) DEFAULT NULL,
  `bool` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`r_id`));

CREATE TABLE IF NOT EXISTS `players` (
  `p_id` int(11) NOT NULL AUTO_INCREMENT,
  `playerid` varchar(150) NOT NULL,
  PRIMARY KEY (`p_id`),
  UNIQUE KEY `playerid` (`playerid`));

The players table is my list of users, and they're tied to the list of games via the game_player table.

So here's my issue... I'm trying to show the full list of games, and then check mark each record where the player does play it. 
This is what I have so far - it shows all the games,  but it's not checking the boxes.

Code: [Select]
$result = mysql_query("SELECT * FROM games") or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$newquery = "SELECT * FROM game_player, players
WHERE game_player.p_id = players.p_id
AND game_player.g_id = ".$row['g_id']. "
AND players.playerid = {$userid}";
$query = mysql_query($newquery) or die(mysql_error());
if($query['bool'] == 1) { $set_checked = " CHECKED";
}
else{ $set_checked = "";
}
echo "<input type=\"checkbox\" name=\"box1\" value=\"".$query['g_id']."\"" . $set_checked . "/>".$row['name']."<br />\n";
}

Really not seeing where my missing parenthesis goes.

Code: [Select]
if(isset($this->uri->segment(3)) AND ((empty($this->uri->segment(3))||($this->uri->segment(3) === FALSE)||(trim($this->uri->segment(3)) == '')))

Hi. I am new to PHP and trying out database connections. I am trying to query the database, to see if the date matches a record in the field 'date'. If it does echo yes, if there are no matches 'no'.

Can anyone tell me what is missing from my code:

Code: [Select]
<?php

$con = mysql_connect("localhost","root","root");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("date_picker", $con);

$date= $_POST['date'];

$new_date = date('Y-m-d',strtotime($date));

$sql = 'SELECT date FROM availability'

if (date = $new_date) echo "Yes";

else echo "No";
   
mysql_close($con)

?>

To make a long story short, I have a series of forms, where certain options are visible depending on what the user selected on the previous form. The final form processing is where I'm having issues.

I have the following for each option, to check if that option was selected (this is all somewhat pared down for clarity):

Code: [Select]
if (isset($_POST['option1']) && $_POST['option1'] > 0){
$option1 = mysql_real_escape_string($_POST['option1']);
$query1 = "DELETE FROM table WHERE itemid = '$option1'";
}
I have that basic thing for each of the options, where it assigns a deletion query based on each individual option. Later in my code, I have the following, which again checks if each option was selected (it's restated because it's after several error checks) then is supposed to run the query that was assigned in the previous part:

Code: [Select]
if ($_POST['option1'] > 0){
mysql_query($query1);
}
if ($_POST['option2'] > 0){
mysql_query($query2);
}
if ($_POST['option3'] > 0){
mysql_query($query3);
}
(etc, for all the options)

My problem is that the queries are not executing and I can't see any reason why not. Query #1 is working... it executes the deletion query and all is well, but if I try to select any options other than #1, the query doesn't execute.

I tried echoing the queries within the second if statements above (where it runs the queries) and it's echoing them fine (and they look normal), so I know it's able to run the queries, it just isn't...

Am I blind? lol. I must be missing something obvious because this is driving me crazy.


Thank you in advance. Please let me know if you need more info.

The user will click on the first button (.Applybutton) which opens a bootstrap modal with the ID ApplyModal. From then on an apply button (.SendButton) will send the job id that is passed in the first button press $_POST['jobid'] to the database.

Let's say I have an array:

$myArray[0] = "AtG2";
$myArray[1] = "AtG4";
$myArray[2] = "AtG1";
$myArray[3] = "AtG3";
$myArray[4] = "AtG5";

I want to sort it alphanumerically, so that the key/value pairs are as follows:
[zero*] => "AtG1"
[1] => "AtG2"
[2] => "AtG3"
[3] => "AtG4"
[4] => "AtG5"

* = I have to write [zero] because putting an actual zero number inside of [ and ] braces converts it to an HTML list bullet.

It *appears* that natsort() is the proper function for this. The only problem I'm having is that natsort() doesn't manipulate key/value pairs.  To confuse me even more, literally every example I can find on using natsort() uses it in conjunction with print_r() like so:

natsort($someArray);
print_r($someArray);

Obviously, something is happening to $someArray when passed to natsort(), otherwise, print_r() wouldn't be able to order the indices in synch with the natural ordering algorithm.

Well, I don't need my web app to use print_r()! I just need the darn key/value pairs reordered so that when I echo $myArray[3], I know I'm going to get "AtG4".

What am I missing here? What is the point of calling it a "sort" if it doesn't manipulate the key/value pairs??? How can I get what I want?!?

well when i am in my forum thing and i go to click on a 'topic' it says no topic exists. and there is one there idk what im missing in the code to make it view it in my table..

Code: [Select]
<?php require("top.php");

?>
<div id='content'>

<div id='homepageright'>
<?php

include_once("scripts/connect.php");

if($username){


$cid = $_GET['cid'];
$tid = $_GET['tid'];

$sql = "SELECT * FROM topics WHERE category_id='".$cid."' AND id='".$tid."' LIMIT 1";
$res = mysql_query($sql) or die(mysql_error());

if(mysql_num_rows($res) == 1){

echo "<table width='100%'>"; 
if($username){
echo "<tr><td colspan='2'><input type='submit' value='Add Reply' onClick=\"window.location = post_reply.php?cid=".$cid."&tid=".$tid."\" /><hr /> ";
}

While ($row = mysql_fetch_assoc($res)) {
$sql2 = "SELECT * FROM posts WHERE category_id='".$cid."' AND topic_id= '".$tid."'";
$res2 = mysql_query($sql2) or die(mysql_error());
while ($row2 = mysql_fetch_assoc($res2)) {
echo "<tr><td valign='top' style='border: 1px solid #000000;'><div style='min-height: 125px;
'>".$row['topic_title']."<br /> by ".$row2['post_creator']." - ".$row2['post_date'].
"<hr /> ".$row2['post_content']."</div></td><td width='200' valign='top' 
align='center' style='border: 1px solid #000000;'>User Info Here</td></tr><tr><td 
colspan='2'><hr /></td></tr>";
}
echo "</table>";

}

}

else{
echo "This Topic Does Not Exist.";
}

}
else{
echo "You Must Be Logged In To Continue.";
}
?>
</div>
<div id='homepageleft'>
<?php


?>
</div>

</html>
</body>

I am running a search query from MYSQL and it works, but now I want to get a little custom.

I am selecting one field, out of many called paid1 which in database is either Yes or No. I want to do this: if paid1 is NO display Pay Now and everything else display Yes. I want this to be under new heading of paid1b. So the code should look something like this:

$paid1b= if(['paid1'}==No){echo "Pay Now";} else {echo "YES";}

But I am missing something somewhere. What is it?
Thanks

nothing is echoed
for the second foreach???
foreach($pictures as $picture)
-im breaking cause it's a large file


Code: [Select]
$doc = new DOMDocument();
$doc->load('accommodation.xml');

$i = 0;

$accommodations = $doc->getElementsByTagName('accommodation');
foreach($accommodations as $accommodation) {
if(++$i > 2) break;
$supplierID = $accommodation->getElementsByTagName('code')->item(0)->nodeValue;
 $pictures = $accommodation->getElementsByTagName('pictures')->item(0)->nodeValue;
 $pictures=array();
foreach($pictures as $picture) {
echo $url = $picture->getElementsByTagName('url')->item(0)->nodeValue;

}



}//end


//XMl schema
<?xml version="1.0" encoding="utf-8"?>
<accommodations>
<accommodation>
<code>1</code>
<pictures>
<picture>
<url>http://example.com/images.k.jpg</url>
</picture>
</pictures>

I have a form with a table that contains ONLY dropdown menus for users to select quantities from 25 dinner items.  It contains some Javascript, but nothing fancy.  In an effort to establish my database and TEST to see how some PHP functions might respond so I could improve my form, I created a mini version of the db in MySQL.

But when I click the submit button, the page blinks, the address bar fills with field names, but there is no connect.  No error messages.  No data transfer.  NO NOTHING!

I searched the web and copied a form and plugged it in (an html form, a php insert file, and a MySQL database) and it worked fine.  I peared down my page to mirror it, and still, no success.

What little detail am I missing??  If I have 25 fields but create a db for the first 6, should it function?
If I reduce it and try to re-use the same db, am I persuing a problem?
I've tried error trapping and changing the form inputs, but it just still doesn't connect.

Please help!

Hi,

I have set up a new website, but the old website is using /mainpage.html as it's homepage when searching in Google. This page no longer exists, so when a user clicks on the page in Google, the website is not found.

Is there a way i can set up a forwarder to point the missing file to the new index.php page?

Thanks

Hi guys,
I apologize for the number of posts regarding this particular class that I am writing (really, at this point, you've probably done more in it), but I have another issue. I've decided to re-write the pieces that were giving me trouble, and instead of using a for loop, I went to a foreach loop.

Here's what it in the database for the particular query:


Here's what I get when I dump the array with print_r():
Array (
    => Array ( [0] => 4
        [id] => 4
        [1] => Test
        [label] => Test
        [2] => ?r=test
        [link] => ?r=test
        [3] =>
        [relation] =>
        [4] => 0
        [parent] => 0
        [5] => 5
        [sort] => 5
        [6] => 1
        [active] => 1 )
    [1] => Array (
        => 2 [id] => 2
        [1] => About Us
        [label] => About Us
        [2] => ?r=about
        [link] => ?r=about
        [3] =>
        [relation] =>
        [4] => 0
        [parent] => 0
        [5] => 10
        [sort] => 10 [6] => 0
        [active] => 0 )
    [2] => Array (
        => 3 [id] => 3 [1] => Fleet
        [label] => Fleet
        [2] => ?r=about/fleet
        [link] => ?r=about/fleet
        [3] =>
        [relation] =>
        [4] => 2
        [parent] => 2
        [5] => 0
        [sort] => 0
        [6] => 0
        [active] => 0 ) )

And the SQL statement:
SELECT * FROM `menu` ORDER BY `parent` ASC, `sort` ASC

With the corresponding PHP code (The issue starts in formatMenuItems()):
Code: [Select]
<?php
/**
 * Menu Class
 *
 * This file is used to create a dynamic menu based on the user's permissions and status
 * @author Max Udaskin <max.udaskin@gmail.com>
 * @version 1.0
 * @package navigation
 */

/**
 * @ignore
 */
if(!defined('ALLOW_ACCESS')) { // Do not allow the file to be accessed by itself
    die('Restricted File.');
}

require_once("Database.php");

class Menu
{
    protected $login;
    protected $all_rows;
    protected $menu_items;
    protected $html = NULL;

    /**
     * The constructor
     * @param Login $login
     */
    function _construct()
    {
    }

    /**
     * Get All Items
     * Retrieves all database menu items
     */
    private function getAllItems()
    {
        $sql = 'SELECT * FROM `menu` ORDER BY `parent` ASC, `sort` ASC';
        $database = new Database('default');
        $database->connect();
        $database->fetchArray($sql);
        $query = $database->getLastQuery();

        $i = 0;
        while($row = mysql_fetch_array($query))
        {
            $this->all_rows[$i] = $row;
            $i++;
        }
        print_r($this->all_rows);
    }

    /*
     * Selects the menu items that are appropriate for the user
     */
    private function chooseMenuItems()
    {
        $this->menu_items = $this->all_rows;
    }

    /**
     * Formats the menu items for the HTML output
     */
    private function formatMenuItems()
    {
        $menu = array();
        $menu_imploded = '';
        
        foreach($this->menu_items as $item) {
            if($item['parent'] == 0) {
                $menu[] = $this->parseItem($item);
            }
        }

        $menu_imploded = $this->combineMultiArray('', $menu);
        
        echo '<div id="menu">';
        echo $menu_imploded;
        echo '</div>';
    }

    /**
     * Searches an array and it's sub arrays for a defined value ($for)
     * @param array $array
     * @param mixed $for
     */
    private function search(array $array, $for) {
        foreach ($array as $key => $value) {
            if ($value === $for) {
                return ($key);
            } else if (is_array($value)) {
                $found = $this->search($value, $for);
                if (is_array($found)) {
                    array_unshift($found, $key);
                    return $found;
                }
            }
        }
        return false;
    }

    /**
     * Gets the array item and returns it
     * @param array $arr
     * @param string $string
     */
    function variableArray($arr, $string)
    {
        preg_match_all('/\[([^\]]*)\]/', $string, $arr_matches, PREG_PATTERN_ORDER);

        $return = $arr;
        foreach($arr_matches[1] as $dimension)
        {
            $return = $return[$dimension];
        }

        return $return;
    }

    /**
     * Parses HTML for the item, as an array
     * @param array $item
     */
    private function parseItem($item)
    {
        if($item['parent'] == 0) {
            $h2_s = '<h2>';
            $h2_e = '</h2>';
        } else {
            $h2_s = '';
            $h2_e = '';
        }
        $return[0] = '<ul><li>' . $h2_s . '<a href="';
        $return[0] .= $item['link'] . '">';
        $return[0] .= $item['label'] . '</a>' . $h2_e;
        $return[1] = false; // Children
        $return[2] = '</li></ul>';
        $return['parent'] = $item['parent'];

        return $return;
    }

    /**
     * Puts all of the HTML in the array together
     */
    private function produceHtml()
    {
        $this->getAllItems();
        $this->chooseMenuItems();
        $this->formatMenuItems();
    }

    /**
     * Get HTML
     * @return string The HTML menu
     */
    public function getHtml()
    {
        $this->produceHtml();
        return $this->html;
    }
    
    /**
     * Combine Multi Array
     * Takes any array of any dimension and combines it into a single string
     * @param unknown_type $array
     */
    private function combineMultiArray($glue, $array)
    {   
        $return = '';
        foreach($array as $piece) {
            if(is_array($piece)) {
                $return .= $glue . $this->combineMultiArray($glue, $piece);
            }
            $return .= $glue . $piece;
        }
        
        return $return;
    }
}

I am trying to get a paragraph from a website. Everything works but the first letter is kept on missing. The code shown below is used to get the paragraph. Not sure why the first letter is missing. Please help!!!

Code: [Select]
if ( isset( $offer[ 0 ] ) )
{
// Tidy it up - remove commas and weird Word chars
$off = strip_tags( $offer[ 0 ] );
$off = substr( $off, strpos( $off, ";" ) + 1 );
$off = str_replace("'", "", $off );
$off = trim( $off );

}
else
{
$off = "0";
}

I've been trying to figure out this issue for a couple of days now.  I have a client that insists in using the Innovaeditor in IE.  I have placed a stylesheet in on the editors, and it breaks the scrollbar in IE.  When I take it out it returns.  I still want to preserve the styles I want to set, and be able to scroll down the editor box.  It works fine in Firefox.

Any help would be MUCH appreciated.