PHP - Echoing Search Variables..

Hello guys,

I want to get the values of 3rd level of my referral but it did not echo any value but if i put the ref id directly on the code, it will echo the values. why is it so? or am i doing it the wrong way?

in my database i have a table test_referral

id    acct_name    ref_id    refer_id
1    john        J1234    0
2    bull        B3456    J1234
3    doe        D5567    J1234
4    frank        F7788    J1234
5    jimmy        J9990    J1234
6    tommy        T6784    F7788
7    tom        T9988    F7788
8    girly        G8866    D5567
9    fred        F0099    J9990
10    ronaldo        R7722    B3456

thanks
 

$stmt= $pdo->query("SELECT * FROM test_referral WHERE acct_name='Chidi Okafor'");
$parent = $stmt->fetch(PDO::FETCH_LAZY);
echo "<ul><li>";
echo $parent['acct_name'];
$ref_id  = $parent['ref_id'];
echo "</li><ul>";



$stmt= $pdo->query("SELECT * FROM test_referral WHERE refer_id='$ref_id'");
$child_count = $stmt->rowCount();
while($child = $stmt->fetch(PDO::FETCH_LAZY)){
echo "<li>";
echo $child['acct_name'];
$ref_ids  = $child['ref_id'];
echo "</li>";
}

//$reff = "F7788";
//$stmt= $pdo->query("SELECT * FROM test_referral WHERE refer_id='$F7788'");
$stmt= $pdo->query("SELECT * FROM test_referral WHERE refer_id='$ref_ids'");
$child_count2 = $stmt->rowCount();

while($children = $stmt->fetch(PDO::FETCH_LAZY)){
echo "<ul><li>";
echo $children['acct_name'];
echo "</li></ul>";

}

Edited by Mr-Chidi, 25 December 2014 - 05:34 AM.

$lastfm = file_get_contents('http://www.last.fm/group/Rishloo/members');
$users = explode('" id="r4_', $lastfm);
$users = explode('">', $users[1]);
var_dump($users[0]);



that is only echoing one ID

http://www.last.fm/group/Rishloo/members

1 id for each member it should be echoing.. any idea why it isnt?



$lastfm = file_get_contents('http://www.last.fm/group/Rishloo/members');
$grab_id=explode('" id="r4_', $lastfm);
for($b=1; $b<count($grab_id); $b++){

$getid=explode('">', $grab_id[$b]);

echo count($getid[0]);
}



that echos all 1's.. any help is appreciated.. thanks


thanks

This problem is existing on a few pages so I'll be in the clear if I can figure out to solve it on one page. Problem is on form submission its still echoing back that sortorder variable which makes it hard for it to compare on the success function to display the right message because the message should be good, bad1, bad2, ... . So is there anyway around that or do I need to do something on the client side of the form page.


<?php

// Include the database page
require ('../inc/dbconfig.php');

if ( isset( $_POST['menuid'] ) ) {
    $menuid = (int)$_POST['menuid'];
    $query = "SELECT COUNT(sortorder) AS numOrder FROM `menuitems` WHERE `menu_id` = '".$menuid."'"; 
    $result = mysqli_query ($dbc, $query);  
    $row = mysqli_fetch_array( $result, MYSQL_ASSOC );
    $sortorder = $row[ 'numOrder' ] + 1; 
    echo $sortorder;
}

if (isset($_POST['submitmenuitem'])) {
    $menuid = mysqli_real_escape_string($dbc, $_POST['menuid']);
    $itemname = mysqli_real_escape_string($dbc, $_POST['itemname']);
    $itemurl = mysqli_real_escape_string($dbc, $_POST['itemurl']);
    $sortorder = mysqli_real_escape_string($dbc, $_POST['sortorder']);
    $contentpage = mysqli_real_escape_string($dbc, $_POST['contentpage']);
    $newscategory = mysqli_real_escape_string($dbc, $_POST['newscategory']);
    $application = mysqli_real_escape_string($dbc, $_POST['application']);

    $query = "SELECT * FROM `menuitems` WHERE (`itemname` = '".$itemname."') OR (`itemurl` = '".$itemurl."') OR (`contentpage_id` = '".$contentpage."') OR (`application_id` = '".$application."') OR (`newscategory_id` = '".$newscategory."') AND `menu_id` = '".$menuid."'";
    $result = mysqli_query ( $dbc, $query ); // Run The Query
    $rows = mysqli_num_rows($result);
    
    if ($rows == 0) {
    
        $query = "INSERT INTO `menuitems` 
                (menu_id, itemname, itemurl, sortorder, contentpage_id, newscategory_id, application_id, creator_id, datecreated, enabled) 
            VALUES 
                ('".$menuid."','".$itemname."','".$itemurl."','".$sortorder."','".$contentpage."', '".$newscategory."', '".$application."', 1, NOW(), 0)";
        
        mysqli_query($dbc, $query);

        echo "good";
    
    } else {
        
        $row = mysqli_fetch_array($result); 
        if (($row['itemname'] == $itemname) && ($row['newscategory_id'] == $newscategory)) echo 'bad9';
        elseif (($row['itemname'] == $itemname) && ($row['application_id'] == $application)) echo 'bad8';  
        elseif (($row['itemname'] == $itemname) && ($row['contentpage_id'] == $contentpage)) echo 'bad7';    
        elseif (($row['itemname'] == $itemname) && ($row['itemurl'] == $itemurl)) echo 'bad6';  
        elseif ($row['newscategory_id'] == $newscategory) echo 'bad5';
        elseif ($row['application_id'] == $application) echo 'bad4';
        elseif ($row['contentpage_id'] == $contentpage) echo 'bad3';
        elseif ($row['itemurl'] == $itemurl) echo 'bad2'; 
        elseif ($row['itemname'] == $itemname) echo 'bad1';    
        
    }
    
}

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

    $menuitemID = (int)$_POST['menuitemID'];

    $query = "UPDATE `menuitems` SET `enabled` = '1' WHERE `id` =  '".$menuitemID."' LIMIT 1"; 

    mysqli_query($dbc,$query);
    
}        
?>

Hello,

I have a PHP page (below) that is suppose to update a field in my database. For some reason it does not update. I am trying to echo that sql with this script. Any help would be greatly appreciated. Thanks JR

Code: [Select]
$p = (100-$_POST[$c])/100;
        $sql = "delete from products_groups where customers_group_id = ".$sppc['customers_group_id'];
        echo $sql;
tep_db_query($sql);
 
        $sql = "insert into products_groups select '". $sppc['customers_group_id'] ."' as customers_group_id, ( " . $p . " * p.products_price) as customers_group_price, p.products_id from products p";
        echo $sql;
tep_db_query($sql);
Below is the complete code,

Code: [Select]
<?php
  require('includes/application_top.php');
 
?>
<!DOCTYPE html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();">
<div id="popupcalendar" class="text"></div>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'template_top.php'); ?>
<!-- header_eof //-->
 
 
<?php
if (isset($_POST['Update']))
{
        $sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
        $sppc_query = tep_db_query($sppc_query_raw);
        while( $sppc = tep_db_fetch_array( $sppc_query ) ) {
 
         if ($sppc["customers_group_name"] != "Retail"){
//$sppc['customers_group_id']
        $c = "CG_".$sppc['customers_group_id'];
        $tmp = $_POST[$c];
        if ($tmp != 0)
        {
        $p = (100-$_POST[$c])/100;
        tep_db_query("delete from products_groups where customers_group_id = ".$sppc['customers_group_id']);
 
        tep_db_query ("insert into products_groups select '". $sppc['customers_group_id'] ."' as customers_group_id, ( " . $p . " * p.products_price) as customers_group_price, p.products_id from products p");
        }  //if not 0
        }  //if not Retail
        }
}
 
?>
<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
  <tr>
        <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
        </table></td>
<!-- body_text //-->
        <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
          <tr>
                <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
                  <tr>
                        <td class="pageHeading"><?php echo "Special Pricing Discount Setup"; ?></td>
                        <td class="specialPrice" align="right"> </td>
                  </tr>
                </table></td>
          </tr>
 
          <tr>
                <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
                  <tr>
                        <td valign="top"><table border="0" width="100%" cellspacing="2" cellpadding="2">
                          <tr class="dataTableHeadingRow">
                                <td class="dataTableHeadingContent" align="left">
                                <?php
                                if (isset($_POST['Update']))
                                {
                                        echo "<center>Updated!</center>";
                                }
                                ?>
                                 </td>
                          </tr>
<?php
 
        $sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
        $sppc_query = tep_db_query($sppc_query_raw);
        while( $sppc = tep_db_fetch_array( $sppc_query ) ) {
?>
                          <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">
                                 <td class="dataTableContent" align="left">
                                  <?php
                                  if ($sppc["customers_group_name"] != "Retail"){
                                          echo $sppc["customers_group_name"];
                                  }
                                  if (isset($_POST['Update']))
                                  {
                                                if ($sppc["customers_group_name"] != "Retail"){
                                                $c = "CG_".$sppc['customers_group_id'];
                                                $tmp = $_POST[$c];
                                                echo " Current Discount is $tmp%" ;
 
                                                }
                                  }
                                  ?>
 
                                  </td>
                          </tr>
<?php
         }
?>
                </table></td>
          </tr>
          <tr>
           <td valign="top">
           <form action="" method="post">
                <table border="0" width="40%" cellspacing="0" cellpadding="2">
                          <tr>
                                <td class="smallText" align="left"> </td>
                                <td> </td>
                          </tr>
<?php
        $sppc_query_raw = "select * from " . TABLE_CUSTOMERS_GROUPS . " order by customers_group_id";
        $sppc_query = tep_db_query($sppc_query_raw);
        while( $sppc = tep_db_fetch_array( $sppc_query ) ) {
 
        if ($sppc["customers_group_name"] != "Retail"){
?>
                          <tr>
                                <td class="smallText" align="left">Set New Percentage (%) Discount for <?=$sppc["customers_group_name"]?> :</td>
                                <td><input name="CG_<?=$sppc['customers_group_id']?>" type="text" size="5" value="0"></td>
                          </tr>
<?php
                          }
         }
?>
                          <tr>
                                <td colspan="2" align="center"><input type="submit" name="Update" value="Update"></td>
                          </tr>
                </table>
                </form>
           </td>
          </tr>
        </table></td>
<!-- body_text_eof //-->
  </tr>
</table>
<!-- body_eof //-->
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

It is not outputting anything after the third echo. This is where it is http://sambender.com/brandon/review.php?subject=Math%20Problems

echo "<table border='0'><tr><td><div id='question'><b>Question:</b><br/>$question</div></td></tr>";
echo "<tr><td><div id='answer' style='display:none;'><b>Answer:</b><br/>$answer</div>";
echo "<a href=\"javascript:showdiv('answer')\">Show Answer</a></td></tr>";
echo "<td><tr><a href='submitanswer.php?correct?=yes&correctid=$correctid>I got this correct!</a></tr></td></table>";

It just outputs
Code: [Select]
<table border='0'><tr><td><div id='question'><b>Question:</b><br/>What is your name?</div></td></tr><tr><td><div id='answer' style='display:none;'><b>Answer:</b><br/>Rooba holabint</div><a href="javascript:showdiv('answer')">Show Answer</a></td></tr><td><tr>

i am having issues checking which value is checked in a form.  here is my code for it:

Code: [Select]
<input type="radio" name="accountActivation" id="no" value="no" checked="
        <?
if (isset($register_errors)) {
if (($_POST['accountActivation']) == "no") {
echo "checked";
}
}
?>
        " />
when i first open the page, no is checked.  why is this, when there should be no errors, and the radio should not even be checked in the first place?

I am probably making a dumb mistake...but heres the code...

$gif = '.gif';
$jpg = '.jpg';
$jpeg = '.jpeg';
$png = '.png';
$jpeg1 = 'jpeg';
$gif1 = 'gif';
$jpg1 = 'jpg';
$png1 = 'png';
$max_file_size = '1048576';
$new_avatar = $_FILES['uploaded_avatar']['name'];
$avatar_ext = end(explode('.', $new_avatar));
if (isset($_POST['change_submit1'])) {
if ($_SESSION['logged_in'] != '1') {
echo 'You need to be logged in!';
} elseif ($_POST['change_box1'] != 'CHANGE') {
echo 'You must fill in the "CHANGE" box!';
}  elseif (($uploaded_a_file == '1') && ($avatar_ext != $jpg1) && ($avatar_ext != $png1) && ($avatar_ext != $gif1) && ($avatar_ext != $jpeg1)) {
echo 'File format not supported!';
} elseif ($uploaded_a_file != '1') {
echo 'No file selected!';
} elseif ($_FILES["uploaded_avatar"]["size"] > $max_file_size) {
echo 'File is too big!';
}
}

this is the code that should be echoing my avatar upload errors. Ive checked all the if statements ive changed the order around. still nothing. all of them work other than file format not supported. I can get this one to work...but at the cost of no file selected not working...help!

i'm not sure whether this should be in this section or the ajax section.

i'm trying to echo out an ajax script so that a page loads in a div tag after a link is clicked in the menu.
Without the "echo", it works fine, but as soon as i include it within the "echo", it stops working. Any help would be great
else echo"

<div id='fcontrol'>

<table border='1' class ='tstyle'>
<tr height ='700'><td valign='top' class='ssbg' width='120'><div id='menu'>

<a href='javascript:ajaxpage(''new_section.php'', ''contentarea'');'>Add new section</a><br/><br/>
<a href='javascript:ajaxpage('new_sub_section.php', 'contentarea');'>Add new section to forum</a><br/><br/><a href='index.php'>Back to forum</a><br/><br/></div></td><td class='tcontrol' width='700' valign='top'>
<center><div id='contentarea'>Control Panel</div></center></td></tr>
</table></div>

</div>
"; ?>

Hi,
I am trying to insert a variable in the body of an email lik so:

Code: [Select]
$message = "Dear Administrator,\n\nthe following distributor\n\n'.$row_admin_login_RS['distributor_company_name'].'\n\nHas modified his Distributor information record.\n\";
I know it must be a syntax error...but I can't figure it out.
Thanks

Hi all, ive got a script witch im wanting to echo all the selected users in a table..

It selects and echos the users but just dosent add on to the table.


<?php
$themembers = mysql_query("SELECT * FROM users WHERE crew = '$user->crew'");
$ammoutmembers = mysql_num_rows($themembers);
?>
<html>
<head>
<title>Crew Members || SD</title>
</head>
<body>
<?php
if ($crewstuff->boss == $username || $crewstuff->coowner == $username || $crewstuff->underboss == $username){
?>
<table width='80%' align='center' class='table' cellpadding='0' cellspacing='0' border='1'>
<tr>
<td class='header' colspan='3' align='center'>Current Crew Members</td>
</tr>
<tr>
<td class='omg' align='center' width='40%'>Username</td><td class='omg' align='center' width='30%'>Rep</td><td class='omg' width='30%' align='center'>Kick</td>
</tr>
<?php
if ($ammoutmembers != "0"){
while ($member11 = mysql_fetch_object($themembers)){
?>
<tr>
<td width='40%'><?php echo("<a href='profile.php?viewuser=$member11->username' target='mainFrame'>$member11->username</a>"); ?></td><td width='30%'><?php echo ("".number_format($member11->rep).""); ?></td><td width='30%'><?php echo("<a href='?action=members&kick=$member11->username'>Kick</a>"); ?></td>
</tr>
<tr>
<td colspan='3' class='omg' align='center'>Any member kicked is logged.</td>
</tr>
</table>
<?php
} // $member11
}// $ammoutmembers
}elseif ($crewstuff->member == $username){
echo ("Your not being here , without being staff.");
}
?>


Is there way I can make it so it will be something like this layout:

Username          | Rep | Kick
----------------------------------
username          | 0     | Kick
username          | 0     | kick

For each user thats echoed?

Thanks for help given

Hey i'm just woundering how i would echo numbers from a database like  1000000 lets say 1 million
how would i go about on echoing it like this 1,000,000



ZhsHero

This code is suppose to echo out ALL the custom pages that are in the database, but it's only show ONE. Why is this?


$query_get = mysql_query("SELECT COUNT(id),id,position,content,title FROM custom_pages ORDER BY id");

while($row = mysql_fetch_assoc($query_get))
{
echo '<table border="0">
<tr><th><p>Title</p><td>'. $row['title'] .'</td></tr>
<tr><th><p>Position</p><td>'. $row['position'] .'</td></tr>
<tr><th><p>Action</p><td><a href="index.php?pages=1&delete='. $row['id'] .'">Delete</a> or <a href="index.php?pages=1&edit='. $row['id'] .'">Edit</a></td></tr>
</table>
';
}

hi all, I have a piece of code which I coded where it selects all there cars out of the database and shows them, well it is meant to:


$getall = mysql_query("SELECT car, id FROM garage WHERE owner='$username'");
$gotall = mysql_fetch_object($getall);

echo "$gotall->car  - $gotall->id<br />";


Its meant to echo out all the cars which the user own, but for some reason its only echoing one car.

Can anyone see why its only showing one car with the id not all the cars they own?

Thanks.

Hi,
this is how I echo some results from my DB:

Code: [Select]
<?php if(mysql_num_rows($execute)>0){
do{
echo "
" .$result['id_cliente']. " " .$result['company_name']. " " .$result['cliente_tel']. "
" ;
}while($result = mysql_fetch_assoc($execute));
}else{
echo "
No customer found.
" ;
}
?>
and this echoes the results in one paragraph.
I need to print the results in rows...and I need help with that.
 :shy:Thanks