PHP - Help Echoing Numbers With

Hi,
I need to sort variables in groups of up to 15 and put it in an array. For example:
$exstract['center_tabOpBody_0'] =5
$exstract['center_tabOpBody_1'] =6
$exstract['center_tabOpBody_2'] =8
$exstract['center_tabOpBody_3'] =1


Should yield:
ARRAY(
          = center_tabOpBody_1,center_tabOpBody_2,center_tabOpBody_3 // <-----15 [1] = center_tabOpBody_0 //<----5
)

Is there some simple function do do the "efficiency" sort?

Thanks,
Vadim

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