PHP - Counting All Values In Column Without Creating A New Columnhi, I Have Downloads

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=344739.0

Hi there,

I am working on a page. That has all the products listed on it. Every product has a Shipping profile associated with it.

Whenever a new product is created, we assign a Shipping profile to that new Product. And its product ID is then inserted into the Shipping profile table.

Note: One Shipping Profile can have multiple Products under it.

The scenario is that when we create the 2nd product and assign Shipping Profile and insert the 2nd product ID to Shipping Profile, the old value gets replaced with the new ProductID.

We just need to somehow append the new ProductID to the existing ProductIDs in the Shipping Profile table.

We can do an Update query but that will replace the Old Product ID with the new ProductID. Here we just need to append the new Product ID to the Old product ID. eg
...............................
Shipping Profile Table|
``````````````````
ShippingProfileID      ProductID
1                            1,4,6
2                            3,7

Now at the moment, the ProductID gets stored but it just replaces the Old product ID. We just need to append to the existing IDs
 
Any comments or feedback are always welcomed.

Thank you!

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?

Hello,
I am trying to add all rows in the same column together.
So here is the basic scheme:
id  l    column1
1   l         1
2   l         2
3   l         3


Second table

id   l      variable1

1   l               3
2   l               5
3   l               6

I basically want to add 5+3+6 and set it to a variable named '$total'. Would this be done using while loops? Here is the code I have been messing with.

$sql="SELECT column1 from table1 where id='$userid'";   // userid would be set near the top of the page
   $sql2=mysql_query($sql,$conn);
          while($rows=mysql_fetch_array($sql2)){
              $getid = $rows['column1'];
                          $sql3="SELECT variable1 FROM table2 where id='$getid'";
                          $sql4=mysql_query($sql3,$conn);
           while($items=mysql_fetch_array($sql4)){
              // Then I'm getting lost...
           } 
           }


Can you at least see what I am trying to do? I'm not even sure if this is the right approach, any help would be appreciated!

Hi,

I have this form currently setup and is showing the value from the table.

<form action="updaterates.php" method="post">
<table width="350">
<tr>
<td width="100">7 Nights</td>
<td width="100"><input type="text" name="rates1" value="<?php echo ($row['rates1']); ?>" maxlength="3" size="3"></td>
</tr>
</table>
</form>

What do I need to do in order for it to update the value in the table... Thanks in advance...

Hi all, I have a table...

id   |   Name       |   Downloads   |
01  |   tom          |    5
02  |   thomas     |    2
03  |   tommy      |    15

I need a button in my page whcih on submit would resent the 'downloads' column so all values are set to 0, Is this possible and how if it is?

Thanks for any advice

Hello,
I am trying insert the values of csv file into a table. I want to concatenate the values of some columns of csv into one String column of table by delimiting them my commas.
 
$im="INSERT into TB1 (col1, col2 ) values ('$a[2]','$a[3]')";
$b = "";
$b=".'$a[6]'."||".'$a[7]'."||".'$a[8]'."||".'$a[9]'.";
$im1=$im+"UPDATE TB1 set latlng=.'$aline'.";
mysql_query($im1) OR die(mysql_error());

I need to enter the value of $a[6] till $a[9] into a string column with delimiters and insert into the column col3 of TB1 with value as $a[4].
I am stuck up here could anyone help me with this issue.

PHP script return 20 UL LIST values like,

< ul >

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T

< /ul >

How to display UL LIST into row wise 5 columns like

A B C D
E F G H
I J K L
M N O P
Q R S T (20 ITEMS)

Edited December 7, 2019 by aveeva

I'm creating a CSV file on the fly for download in the backend - a stock management function.

The script works fine extracting from the database fine and creates the CSV. But the next step of the script is to download the file using:

header('Content-type: application/octet-stream');
header('Content-Disposition: attachment; filename="' . $filename . '"');

This works, in as much as it downloads the file specified by $filename but when I open the file it's empty and the File Size in properties is 0.

But if I go into my FTP and download the file it contains all the data as expected?


Anyone have any ideas whats wrong? Thoughts I've had:
File size too large would using ob_start('ob_gzhandler'); help? Or is there an INI setting?
File encoding needs to be set? UTF8?
Content Type should be text/csv?

Thanks

Hi all,

I've tried many, many variations of php download script using readfile() fread() fpassthru() etc... but none seem reliable. I can download small files perfectly fine, but say I have a 30 or 90mb zip file the download ocassionally bombs out and says the download is complete even though the full file hasn't been transferred.
I have tired it on several browsers with pretty much the same issue. The interesting bit for me is that if I download the same file across different browsers (whether or not they start at the same time or not) on my computer the download stops at the same time (not same point into download) for each browser.  Its as if the connection is being reset on my website on a global basis...

The important part of my script as it is at the moment:

Code: [Select]
// resumable download?
$is_resume = TRUE;

//Gather relevant info about file
$size = filesize($path);
$fileinfo = pathinfo($path);

@ini_set('magic_quotes_runtime', 0);
set_time_limit(0);
apache_setenv('no-gzip', '1');
mb_http_output("pass");

// required for IE, otherwise Content-disposition is ignored
if(ini_get('zlib.output_compression')) { ini_set('zlib.output_compression', 'Off'); }
 
//workaround for IE filename bug with multiple periods / multiple dots in filename
//that adds square brackets to filename - eg. setup.abc.exe becomes setup[1].abc.exe
$filename = (strstr($_SERVER['HTTP_USER_AGENT'], 'MSIE')) ?
preg_replace('/\./', '%2e', $fileinfo['basename'], substr_count($fileinfo['basename'], '.') - 1) :
$fileinfo['basename'];

$file_extension = strtolower($fileinfo['extension']);

    //This will set the Content-Type to the appropriate setting for the file
    switch($file_extension) {
        case 'zip': $ctype='application/zip'; break;
        case 'pdf': $ctype='application/pdf'; break;
        default:    $ctype='application/force-download';
    }

    //check if http_range is sent by browser (or download manager)
    if($is_resume && isset($_SERVER['HTTP_RANGE'])) {
        list($size_unit, $range_orig) = explode('=', $_SERVER['HTTP_RANGE'], 2);
        if ($size_unit == 'bytes') {
            //multiple ranges could be specified at the same time, but for simplicity only serve the first range
            //http://tools.ietf.org/id/draft-ietf-http-range-retrieval-00.txt
            list($range, $extra_ranges) = explode(',', $range_orig, 2);
        } else {
            $range = '';
        }
    } else {
        $range = '';
    }

    //figure out download piece from range (if set)
    list($seek_start, $seek_end) = explode('-', $range, 2);

    //set start and end based on range (if set), else set defaults
    //also check for invalid ranges.
    $seek_end = (empty($seek_end)) ? ($size - 1) : min(abs(intval($seek_end)),($size - 1));
    $seek_start = (empty($seek_start) || $seek_end < abs(intval($seek_start))) ? 0 : max(abs(intval($seek_start)),0);

    //add headers if resumable
    if ($is_resume) {
        //Only send partial content header if downloading a piece of the file (IE workaround)
        if ($seek_start > 0 || $seek_end < ($size - 1)) {
            header('HTTP/1.1 206 Partial Content');
        }
header('Accept-Ranges: bytes');
        header('Content-Range: bytes '.$seek_start.'-'.$seek_end.'/'.$size);
    }

    header("Cache-Control: cache, must-revalidate"); 
    header("Pragma: public");
    header('Content-Type: ' . $ctype);
    header("Content-Disposition: attachment; filename=\"".$filename."\"");
    header('Content-Length: '.($seek_end - $seek_start + 1));

    //open the file
    $fp = fopen($path, 'rb');
    //seek to start of missing part
    fseek($fp, $seek_start);

    //start buffered download
    while(!feof($fp)) {
        //reset time limit for big files
        set_time_limit(0);
        print(fread($fp, 1024*8));
        flush();
        ob_flush();
    }
    fclose($fp);
exit();

I did have the following section in replace of the above fread section up until this morning (but same issue):

Code: [Select]
// http headers for zip downloads
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: public");
header("Content-Description: File Transfer");
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"".$filename."\"");
header("Content-Transfer-Encoding: binary");
header('Content-Length: '.$size);
ob_end_flush();
@readfile($path);

I have tried different headers and so forth, but all generally seem to bomb out occassionally before the download completes. But they don't bomb out at a particular point in the file size (ie at 25mb). Just seems to work and then die at the same time across different browsers, even when they are started at different times.

Very strange and I've spent days modifying the script and still no answers. Sometimes the files download fine, but bomb out too many times for it to be satifactory to leave.

Any help or pointers would be much appreciated.

Not sure if I'm putting this in the correct spot, but,
Can anyone give me a link or an idea of how to fix Drive-By downloads I have on a site I have created? Everything I search for online brings up how to repair an issue someone may have gotten on their computer from a drive-by download, but nothing talks about repairing it on the actual site itself. I don't have any injections or anything, but doing a check on my site from the norton site shows that I have 1 Threat and it's on a contact form page due to Drive-By Downloads, is this from the php tags on the form not being stripped or from the javascript possibly?

Some old lady submitted my site to http://safeweb.norton.com/report/show?url=gotmine.com, now I have to fix it I guess.

 

Any help would be great, Thanks.

Is there a way (in PHP) to prompt to download file regardless of it's type?  I have taken someone's suggestions and put files in a folder with HTAccess protection. ALL I want
to do is just grab the files and prompt download (regardless of what the type of file is), is there an easy way to do this in PHP.

Hi !

I am currently trying to develop a PHP application in which my server downloads a file and the user can do the same almost simultaneously. I already think about the problem "If the user downloads fastly than the server...", but it's not a problem at this moment.
To do so, I used the header and readfile functions of php. Here is my code :

Code: [Select]
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename="'.$data['name'].'";');
header('Content-Transfer-Encoding: binary');
header('Content-Length: '.$data['size']);
readfile($remoteFile);

I must to use the Content-length header to set the proper size of the file and not the size that is downloaded when the user clicks on the link. However, after some seconds or minutes, download is stopped and I need to restart...
If you think about a solution, even if it didn't use the header(); function, please tell me.

Thank you in advance...

This upload form code works successfully, where a file is chosen, renamed and stored in the 'upload' folder,