PHP - Get Last Row In A Column?

Hi

Hey,

I've got a query in which a variable is interpreted as a column and I don't why this is caused.


$upgrade_time_sql = "SELECT * FROM todo_upgrades WHERE profile_id = ".$profile_id." AND level = ".$profile_data['level2_'.$show.'']." AND type = ".$show."";
$upgrade_time_res = mysql_query($upgrade_time_sql) or die (mysql_error());


$show is filled with the content "storage"

The mysql_error is

"Unknown column 'storage' in 'where clause'"

Thanks for helping.

I fairly new to PHP. This seems very obvious but I cannot find an answer.

O programmer friend of mine said that I should never store a calculated value in a table because it was redundant. SO I have a very simple shopping cart. In the confirmation email, I ask the database for the line items of the order. So I'm pulling the quantity and price from the database. In the email I created a var called $ext which is $price * $disc which works.  I cannot figure out how to total $ext.

I created a var called $subtotal. Heres the code.

$result = mysql_query("SELECT * FROM order_detail, products
WHERE $ordid = orderid AND
order_detail.productid = products.serial");

while($row = mysql_fetch_array($result))
{
   $prodid = $row['productid'];
   $qty = $row['quantity'];
   $price = $row['price'];
   $prodname = $row['name'];
   $proddesc = $row['description'];
   $ext = $qty * $price;
   $subtotal = 0;
   $subtotal = ($subtotal + $ext);
}

Any help would be appreciated. 

How can i get the last row data from a certain column?

hello.
can (or rather how can) i put multiple checkboxes in to 1 db column?

so, can i do this in 1 table:

id - tick box id
1  - 1,2,3
2  - 4,5,6
3  - 7,8,9

and then relate that table to another table

tick box id   -   name
1                -   name1
2                -   name2
3                -   name3
etc..


if so,
what format would i use in the db?  varchar, enum or set  (1,2,3 or '1','2','3')
and
how would i echo them out with the names from the second table?

thanks

I need to write a query that will sum  a column 'serv_cc_total' from the first day of the month to the date the record was saved to the db when the record for that date is viewed.
Any help would be appreciated.

Doug

Hi,
I'm quite new to this and I'm trying to get this to line up in a table with 3 columns (unlimited rows)
I have searched and tried but I'm not having any luck.

Can any one help?
Thank you

Code: [Select]
<?php 
echo '<div class="resultados_sub_cat">';

foreach($this->subcats as $key => $subcat) {

$subcat->link = JRoute::_('index.php?option=classcliff&view=list&catid='.$subcat->id."&Itemid=".$this->Itemid);
if ($key != 0)
echo ' - ';
echo '<a href="'.$subcat->link.'">'.$subcat->name.'</a>';

} 
?>

I am trying to find a loop type script that starts at a particular row in a particular column in an excel file and keeps adding values in each row until the last value is reached.

I have searched and am pretty new to loops. can anyone point me in the right direction please?

Hi,

Stuck again with the Joomla/K2 coding.  Trying to output this field in a 2 column table but failing badly.  Any help or ideas would be greatly appreciated.

     <?php if($this->item->params->get('catItemExtraFields') && count($this->item->extra_fields)): ?>
     <!-- Item extra fields -->
     <div class="catItemExtraFields">
        <h4><?php echo JText::_('K2_ADDITIONAL_INFO'); ?></h4>
        <ul>
         <?php foreach ($this->item->extra_fields as $key=>$extraField): ?>
         <?php if($extraField->value): ?>
         <li class="<?php echo ($key%2) ? "odd" : "even"; ?> type<?php echo ucfirst($extraField->type); ?> group<?php echo $extraField->group; ?>">
            
            
               <?php if ($extraField->name =='Closing date') : ?>

                    <span class="catItemExtraFieldsLabel"><?php echo $extraField->name; ?></span>
                      <span class="catItemDateCreated"><?php echo JHTML::_('date', $this->item->publish_down ); ?></span>
                    <?php else :?>
                     <span class="catItemExtraFieldsLabel"><?php echo $extraField->name; ?></span>
                    <span class="catItemExtraFieldsValue"><?php echo $extraField->value; ?></span>
       
                    <?php endif; ?>
               
         </li>
         <?php endif; ?>
         <?php endforeach; ?>
         </ul>
       <div class="clr"></div>
     </div>
     <?php endif; ?>
 

Php Buddies,

Just how do you insert an uploaded img via html for ($_POST) to mysql tbl and what type of column should it be ?

Also, how to link the img from the mysql column to a webpage ?

Following html links the img from a folder/directory to a webpage:

<a href="../html-link.htm"><img src="flower.jpg" style="width:82px; height:86px" title="White flower" alt="Flower"></a>

Hello, 
I think this question is a bit of both php and mysql related. I hope I can get some help here. Especially with the mysql part. 

 

I have a table like this:

CREATE TABLE days (
    id INT AUTO_INCREMENT,
      daya INT,
      dayb INT,
    PRIMARY KEY (id)
);


INSERT INTO days VALUES
    (70, 19, 18),
    (69, 20, 17),
    (68, 24, 25),
    (67, 19, 18),   
    (66, 19, 17),    
    (65, 17, 16);

and mysql query and php snippet is this:

 $sql = "SELECT
    d1.id AS id1,
    d2.id AS id2,
    IF((d1.daya-d2.daya)=1,1,0) +
    IF((d1.daya-d2.dayb)=1,1,0) +
    IF((d1.dayb-d2.daya)=1,1,0) +
    IF((d1.dayb-d2.dayb)=1,1,0)   AS tcount
FROM days AS d1 , days AS d2
WHERE d1.id IS NOT NULL AND d2.id IS NOT NULL AND d1.id > d2.id";

  $result = $conn->query($sql);
  if ($result->num_rows > 0) {

   while($row = $result->fetch_assoc()) 
   {
        echo "<tr><td>" . $row["id1"] . "</td><td>". $row["id2"] . "</td><td>" . $row["tcount"]. 
                        "</td></tr>";   
             
    }
echo "</table>";

which gives me a table like this:

Id1  Id2   Count
50    49    1
50    48    0
49    48    0
50    47    1
49    47    1
48    47    0
50    46    1
49    46    1
48    46    0
47    46    1
50    45    1
49    45    1
48    45    0
47    45    1
46    45    1

I need to convert the table into this form: id1 goes down the first column, and id2 is in the first row.  How can i do this, please? can you give me some help? thank you!

id2    49    48    47    46    45
id1                    
50     1      0     1     1     1
49            0     1     1     1
48                  0     0     0
47                        1     1
46                              1
45                    

 

I have a table with "votes" column. I basically want to retrieve the sum of all the votes columns associated with a user.

This is the full code. It gives me "NULL" output.

$count_votes = $db->prepare("SELECT SUM(votes) as total FROM entries WHERE user_id = :user_id");
$count_votes->bindParam(':user_id', $user_id);
$count_votes->execute();
$t_votes = $count_votes->fetchColumn();
$get_votes = $t_votes['total'];

echo $get_votes;

 

But if I remove the user_id bind paramter, it gives me the results. But I need that parameter to show which user has how many votes.

$count_votes = $db->prepare("SELECT SUM(votes) as total FROM entries");
$count_votes->execute();
$t_votes = $count_votes->fetchColumn();
$get_votes = $t_votes['total'];

echo $get_votes;

 

What am I doing wrong?

Php Buddies,

Line 67:

$query = "SELECT page_url,link_anchor_text,page_description,keyphrases,keywords FROM links WHERE $_SESSION['search_column'] = ?";

I get error for the above:

Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting '-' or identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in C:\xampp\htdocs\test\select.php on line 67

 

How to fix this ?

 

Context:

	<?php
//include('error_reporting.php');
ini_set('error_reporting','E_ALL');//Same as: error_reporting(E_ALL);
ini_set('display_errors','1');
ini_set('display_startup_errors','1');
require('conn.php');
?>
	<form name = "search" method = "POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<label for="keywords">Keywords:*</label>
<input type="text" name="keywords" id="keywords" placeholder="Input Keywords" required>
<br>
<label for="search_column">Search in ... ?</label>
<select name="search_column" id="search_column">
<option value="page_url">Page Url</option>
<option value="link_anchor_text">Link Anchor Text</option>
<option value="page_description">Page Description</option>
<option value="keyphrase">Keyphrase</option>
<option value="keywords">Keywords</option>
</select>
<br>
<label for="tos_agreement">Agree to TOS or not ? *</label>
<select name="tos_agreement" id="tos_agreement" required>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
<br>
<input type="button" name="search_links" id="search_links" value="Search Links!">
<br>
<input type="reset">
<br>
</form>
	<?php
	if($_SERVER['REQUEST_METHOD'] === 'POST')
{
    if(ISSET($_POST['search_links']))
    {
        if(ISSET($_POST['page_url']))
        {
            $_SESSION['search_column'] = $_POST['page_url'];
        }
        elseif(ISSET($_POST['link_anchor_text']))
        {
            $_SESSION['search_column'] = $_POST['link_anchor_text'];
        }
        elseif(ISSET($_POST['page_description']))
        {
            $_SESSION['search_column'] = $_POST['page_description'];
        }
        elseif(ISSET($_POST['keyphrase']))
        {
            $_SESSION['search_column'] = $_POST['keyphrase'];
        }
        elseif(ISSET($_POST['keywords']))
        {
            $_SESSION['search_column'] = $_POST['keywords'];
        }
        
        //Re-write the following 4 lines ...
        mysqli_report(MYSQLI_REPORT_ALL|MYSQLI_REPORT_STRICT);
        mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
       $conn->set_charset('utf8mb4'); //Always set Charset.
	        $query = "SELECT page_url,link_anchor_text,page_description,keyphrases,keywords FROM links WHERE $_SESSION['search_column'] = ?";
	        $stmt = mysqli_stmt_init($conn);
	        if(mysqli_stmt_prepare($stmt,$query))
        {
            mysqli_stmt_bind_param($stmt,'s',$_SESSION['search_column']);
            
            $result = mysqli_stmt_bind_result($stmt,$page_url,$link_anchor_text,$page_description,$keyphrase,$keywords);
            mysqli_stmt_execute($stmt);
            
            mysqli_stmt_fetch($stmt);
            
            while(mysqli_stmt_fetch($stmt))
            {
                echo "url"; echo "<br>";
                echo "anchor_text"; echo "<br>";
                echo "description"; echo "<br>";
                echo "keyphrases"; echo "<br>";
                echo "keywords"; echo "<br>";
                echo "|";
                echo "<br>";
            }
            
            mysqli_stmt_close($stmt);
            mysqli_close($conn);
        }
        else
        {
            echo "1. QUERY failed!";
        }
	        if(mysqli_stmt_prepare($stmt,$query))
        {
            mysqli_stmt_bind_param($stmt,'sssss',$_POST['page_url'],$_POST['link_anchor_text'],$_POST['page_description'],$_POST['keyphrases'],$_POST['keywords']);
            mysqli_stmt_execute($stmt);
            
            $result = mysqli_stmt_get_result($stmt);
            
            while($row = mysqli_fetch_array($result,mysqli_assoc))
            {
                $page_url = $row['page_url']; echo $page_url; echo "<br>";
                $link_anchor_text = $row['link_anchor_text']; echo $link_anchor_text; echo "<br>";
                $page_description = $row['page_description']; echo $page_description; echo "<br>";
                $keyphrases = $row['keyphrases']; echo $keyphrases; echo "<br>";
                $keywords = $row['keywords']; echo $keywords; echo "<br>";
                echo "|";
                echo "<br>";
            }
            
            mysqli_stmt_close($stmt);
            mysqli_close($conn);
        }
        else
        {
            die("2. QUERY failed!");
        }
    }
}
	
?>
	

Edited July 16, 2020 by 2020

I have become able to display due data in due column but the same value is showing for each customer - what is the wrong I am doing? Here is the code, please somebody help!

while ($row_custact = mysqli_fetch_assoc($query_custact)){
				$currentuser = $row_custact['cust_id']; 
				$sql_inccur ="SELECT i.inc_date, t.inctype_type, i.inc_amount, i.inc_text, c.cust_no, c.cust_name, i.inc_receipt
                From customer AS c
                LEFT JOIN incomes AS i ON c.cust_id = i.cust_id 
                LEFT JOIN inctype AS t ON i.inctype_id = t.inctype_id
                WHERE c.cust_id = '$currentuser'
                ORDER BY inc_date DESC";

                $query_inccur = mysqli_query($db_link, $sql_inccur);
	            checkSQL($db_link, $query_inccur);      
				
				
					
				while ($row_inccur = mysqli_fetch_assoc($query_inccur)){
					
				$inc_amount = $row_inccur['inc_amount'];
				$inc_text = $row_inccur['inc_text'];	
				
				
				//Iterate over income types and add matching incomes to $total
					 
						$total_row = $total_row + $row_inccur['inc_amount'];  
						$total_paid = $total_paid + $total_row;
				
				// part for total due finding.. and "inc_text" is due column
				        $total_row_due = $total_row_due + $row_inccur['inc_text'];  
				        $total_due = $total_due + $total_row_due;
				
				// this part gathers only total due paied for an account
				if($row_inccur['inctype_type']=='Duepay')
				{
					$total_duepay = $total_duepay + $row_inccur['inc_amount']; 
				}
				$remaining_due = $total_row_due - $total_duepay;	
				//echo $remaining_due; 	
					
				}
				
				
				//echo $currentuser; 
					
				echo '<tr>
								<td>
									<a href="customer.php?cust='.$row_custact['cust_id'].'">'.$row_custact['cust_no'].'</a>
								</td>
								<td>'.$row_custact['cust_name'].'</td>
								<td>'.$row_custact['custsex_name'].'</td>
								<td>
								    '.$remaining_due. '  // showing due left, here is the problem 
								</td>
								
								<td>'.$row_custact['cust_address'].'</td>
								<td>'.$row_custact['cust_phone'].'</td>
								<td>'.date("d.m.Y",$row_custact['cust_since']).'</td>
							</tr>';
				}

 

I have an existing two table structure where sub-data is related to main data in a many-to-one relationship.   There are several identically named columns in both tables.   (The PHP database class will return an associative array that did not deal with identical keys in the row.)   I'm LEFT JOINing the sub-data to the main-data tables.   When using a stand-alone query browser (to experiment), the display shows all columns, even those column names that appear more than once in the row.   Is there a general approach to making keys (column names) unique strictly using a MySQL SELECT statement?   Perhaps using table aliases, how can I concat the alias to the columns that come from each table?   What I am trying to avoid is giving an alias to each column in a list of column names, such as: SELECT C.name AS C_name C.numb AS C_numb D.name AS D_name D.numb AS D_numb etc.   I am wanting more like the result one could guess would be from: C.* AS C_* D.* AS D_*   Or better: * AS CONCAT(__TABLE__, '_', *) if __TABLE was a magic constant (like PHP's __LINE__, __FILE__, etc).