PHP - Echoing Everything From The Database

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.

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);
    
}        
?>

$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

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'); ?>

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

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

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,
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

Hi all, I have this code which is suppose to display everymessage that the User has, but when im trying to display the messages its displaying them all in different tables..

Im trying to get it so it will be like:

inbox
------------------
subject | From
subject | username

Read Messages
------------------
subject | From
subject | username

So two tables which one displays the messages which havent been read while the other does


<?php
session_start();
include "includes/config.php";
include "includes/functions.php";
logincheck();
ini_set ('display_errors', 1);
error_reporting (E_ALL);
$user=$_SESSION['username'];

// Grab whats needed...
$all_msgs = mysql_query("SELECT `id` FROM `inbox` WHERE `to`='$user' ORDER BY `id` DESC") or die("Error on line 9 - " . mysql_error());
$get_msg = mysql_query("SELECT * FROM `inbox` WHERE `to`='$user' ORDER BY `id` DESC") or die("Error on line 10 - " . mysql_error());
$msg_num = mysql_num_rows($all_msgs);
// lets echo the subject + A linking to the message...

    echo '<table width="50%" cellpadding="0" align="center" cellspacing="0" border="1" class="table">
        <tr>
            <td class="header" algin="center" colspan="2">Inbox</td>
        </tr>
<tr>
<td class="omg" align="center">Subject</td><td align="center" class="omg">From</td>
</tr>';

for($number = 1; $number <= $msg_num; $number++)
{
    $line = mysql_fetch_array($get_msg);
 //if the message is not read...

 if($line['read'] == 0){
 
    echo '<tr>    
           <td width="50%" align="center"><a href="rmessage.php?messageid=' . $line['id'] . '">' . $line['title'] . '</a>(New)</td><td width="50%" align="center"><a href="profile.php?viewuser=' . $line['from'] . '">' . $line['from'] . '</a></td>
</tr></table>
<br />
<br />'; 
}else{ 
// If message is read...
echo '<br /><table width="50%" cellpadding="0" align="center" cellspacing="0" border="1" class="table">
        <tr>
            <td class="header" algin="center" colspan="2">Messages Read</td>
        </tr>
<tr>
<td class="omg" align="center">Subject</td><td class="omg" align="center">From</td></td>
</tr>
<tr>
<td width="50%" align="center"><a href="rmessage.php?messageid=' . $line['id'] . '">' . $line['title'] . '</a></td><td width="50%" align="center"><a href="profile.php?viewuser=' . $line['from'] . '">' . $line['from'] . '</td>
        </tr></table>';
}}
?>


Anyone see a way I can sort it so it don't show a table for every message they have?

Thanks for any help given

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?

how do i echo "checked=checked" for a checkbox?  here is what i have:

Code: [Select]
<input type='checkbox' name='ip_automatic_login' id='ip_automatic_login' value='1' if($IPCheck == true) {/"checked=checked/" } />
this code will be echoed!

I want to echo the contents of column 4 for my username only, and it doesn't show anything. I can do if ($memberQuery->fetchColumn(4) < 2)() though.

Code: [Select]
$host = 'localhost';
$database = '';
$db_username = '';
$db_password = '';

if (($db = new PDO("mysql:host=$host;dbname=$database", $db_username, $db_password)) == NULL) {
echo $db->getMessage();
}

$memberQuery = $db->prepare("SELECT * FROM members WHERE username=:username");
$memberQuery->execute(array(':username' => $_SESSION['username']));
$result = $memberQuery->fetchColumn(4);
echo "$result";

i have a form, and if the form has not been sent, it shows the form.  here is  my code for the beginning:

Code: [Select]
if($sent != true) {
echo"
?>

<div class='form'><form action='' method='post'> [b]!!![/b]
<p class='form'>User ID: <br /><input name='memberID' type='hidden' value='<?php echo $row['id'] ?>' />
  Your User ID will be logged for identity purposes.
    <br /><input type='checkbox' name='noIdentity' id='noIdentity' value='noIdentity'
    <?php 
if(isset($_POST['errors']) && isset($_POST[noIdentity])) { [b]!!![/b]
echo ' checked='checked '"; 
} 
?>
     />
and the end:

Code: [Select]
<?php 
";
}
?>
it doesn't like what i have the exclamations next to.  also, am i doing this right?

Folks,

I want to echo an HTML tag in PHP.

Code: [Select]
<td width="300" bgcolor="#ffffff" align="center" onmouseout="style.backgroundColor='#ffffff'" onmouseover="style.backgroundColor='#e8e8e8';" style="word-wrap: break-word; border: 1px solid rgb(238, 238, 238); font-size: 12px; background-color: rgb(255, 255, 255);">
So what i am doing is;

Code: [Select]
echo '<td width="300" bgcolor="#ffffff" align="center" onmouseout="style.backgroundColor='#ffffff'" onmouseover="style.backgroundColor='#e8e8e8';" style="word-wrap: break-word; border: 1px solid rgb(238, 238, 238); font-size: 12px; background-color: rgb(255, 255, 255);">';
And its now working because this tag already has ' (Single Quotes) & ; (Semicolon)  so its conflicting.

Any work around for this friends?

Cheers
N