Jump to content

jazzman1

Staff Alumni
 View Profile  See their activity

  • Posts

    2,713

  • Joined

  • Last visited

  • Days Won

    12

 Content Type 

Posts posted by jazzman1

    get score based on max week no

    in MySQL Help

    Posted · Edited by jazzman1

    Barand will kill me if he sees my previous reply. Try next (already tested) :)

    select 
    u.firstname,
    u.surname,
    a.userID,
    X.week as 'Max Week',
    X.score as 'Gameweek'
from
    POINTS a
        inner join
    (select 
        userID, week, score
    from
        POINTS a1
    where
        week = (select 
                max(week)
            from
                POINTS a2
            where
                a2.userID = a1.userID)
    group by userID) as X ON X.userID = a.userID and X.week = a.week
        inner join
    USERS u ON u.userID = X.userID

    I needed to use a subquery after the where clause or you could use another inner join inside the first join table instead!

    get score based on max week no

    in MySQL Help

    Posted · Edited by jazzman1

    Try,

    SELECT 
    u.firstname, u.surname, a.userID, max_week, gameweek
FROM
    POINTS a
        inner join
    (select 
        userID, max(week) as max_week, score as gameweek
    from
        POINTS
    group by userID) as b ON a.userID = b.userID
        and b.max_week = a.week
        inner join
    USERS u ON u.userID = b.userID

    "Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 36 bytes)" what does it mean?

    in PHP Coding Help

    Posted

    Try (second page):

    <!doctype html>
<html>
    <head>
        <title>Test array attendence</title>
    </head>
    <body>
        <table border="1">
            <?php
            if (!empty($_GET['member'])) {
                
                $data = $_GET['member'];

                foreach (array_chunk($data, 2) as $row):
                    ?>
                    <tr>
                        <?php foreach ($row as $value): ?>
                            <td><?php echo htmlentities($value); ?></td>
                    <?php endforeach; ?>
                    </tr>
                <?php
                endforeach;
            }else {
                echo "Fail to get data from previous";
            }
            ?>
        </table>
        <table><tr><td><?php echo count($_GET['member']) . " are attending this meeting tonight." ?></td></tr></table>
    </body>
</html>

    php permission denied

    in PHP Coding Help

    Posted

     

    the php user account on the server does not have read/execute permission for either those files or their containing folder.  Just fix the permissions and you should be good to go.

    Well, I have the same problem :)

    [newuser@centos-box ~]$ whoami
newuser

[newuser@centos-box ~]$ touch file.php

[newuser@centos-box ~]$ ls -l file.php 
-rwxrwxr-x. 1 newuser newuser 0 Jun 16 07:55 file.php

[newuser@centos-box ~]$ ./file.php 
bash: Permission denied

    kill Gwenview: how to do that?

    in Linux

    Posted

    Use a "top" command to see all list of the current processes to this particular user then fetch the searching text using a "grep" command and kill the PID. 

    [lxc@lxc-centos ~]$ top -u lxc | grep sshd
775 lxc       20   0  106m 2188 1520 S  0.0  0.0   0:00.13 sshd

// kill the proccess id
[lxc@lxc-centos ~]$ kill -9 775

    Call undefined function mysqli_connect()

    in PHP Coding Help

    Posted · Edited by jazzman1

    Do you have any problem with some other php function or only with this one? Could you run this script and give us the output (should be mysqli_connect function is not available).  Try also the old mysql_connect instead mysqli_connect.

    <?php

if (function_exists('mysqli_connect')) {
    echo "mysqli_connect function is available.<br />\n";
} else {
    echo "mysqli_connect function is not available.<br />\n";
}

    PHP exec with variables

    in PHP Coding Help

    Posted

    Without any additional arguments to the exeftool app and some redirect output files (using just for testing purposes) everything works fine to me.

    Here is an example using different php command-line apps (exec, eval and shell_exec).

    Try to set also an absolute path to exiftool. 

    <?php

$uploaddir = '/var/www/html/public_html/lxc/uploads/';

$uploadfile = $uploaddir . basename($_FILES['fileToUpload']['name']);

if (move_uploaded_file($_FILES['fileToUpload']['tmp_name'], $uploadfile)) {

//echo exec('/usr/local/bin/exiftool "'.$uploadfile.'"'); // Megapixels : 0.345

//eval('$array=' . `/usr/local/bin/exiftool -php -q $uploadfile`);

//print_r($array);

echo shell_exec('/usr/local/bin/exiftool "'.$uploadfile.'"');

} else {
   echo "Upload failed";
}

    Outputs:

     

     

     

     

    ExifTool Version Number : 9.97 File Name : 166688_1813367933281_1212517464_2171202_461168_n.jpg Directory : /var/www/html/public_html/lxc/uploads File Size : 96 kB File Modification Date/Time : 2015:06:13 09:47:56-04:00 File Access Date/Time : 2015:06:13 09:47:56-04:00 File Inode Change Date/Time : 2015:06:13 09:47:56-04:00 File Permissions : rw-r--r-- File Type : JPEG File Type Extension : jpg MIME Type : image/jpeg JFIF Version : 1.01 Resolution Unit : inches X Resolution : 72 Y Resolution : 72 Profile CMM Type : Profile Version : 2.0.0 Profile Class : Display Device Profile Color Space Data : RGB Profile Connection Space : XYZ Profile Date Time : 2009:03:27 21:36:31 Profile File Signature : acsp Primary Platform : Unknown () CMM Flags : Not Embedded, Independent Device Manufacturer : Device Model : Device Attributes : Reflective, Glossy, Positive, Color Rendering Intent : Perceptual Connection Space Illuminant : 0.9642 1 0.82491 Profile Creator : Profile ID : 29f83ddeaff255ae7842fae4ca83390d Profile Description : sRGB IEC61966-2-1 black scaled Blue Matrix Column : 0.14307 0.06061 0.7141 Blue Tone Reproduction Curve : (Binary data 2060 bytes, use -b option to extract) Device Model Desc : IEC 61966-2-1 Default RGB Colour Space - sRGB Green Matrix Column : 0.38515 0.71687 0.09708 Green Tone Reproduction Curve : (Binary data 2060 bytes, use -b option to extract) Luminance : 0 80 0 Measurement Observer : CIE 1931 Measurement Backing : 0 0 0 Measurement Geometry : Unknown Measurement Flare : 0% Measurement Illuminant : D65 Media Black Point : 0.01205 0.0125 0.01031 Red Matrix Column : 0.43607 0.22249 0.01392 Red Tone Reproduction Curve : (Binary data 2060 bytes, use -b option to extract) Technology : Cathode Ray Tube Display Viewing Cond Desc : Reference Viewing Condition in IEC 61966-2-1 Media White Point : 0.9642 1 0.82491 Profile Copyright : Copyright International Color Consortium, 2009 Chromatic Adaptation : 1.04791 0.02293 -0.0502 0.0296 0.99046 -0.01707 -0.00925 0.01506 0.75179 Image Width : 720 Image Height : 479 Encoding Process : Baseline DCT, Huffman coding Bits Per Sample : 8 Color Components : 3 Y Cb Cr Sub Sampling : YCbCr4:2:0 (2 2) Image Size : 720x479 Megapixels : 0.345

    Routing issue: Cannot see a wireless router from a wired router on the same network.

    in Linux

    Posted

     

    Routing issue: Cannot see a wireless router from a wired router on the same network.

    How did you get this output then? 

    (the wireless router)
# ping 192.168.1.2
PING 192.168.1.2 (192.168.1.2) 56(84) bytes of data.
64 bytes from 192.168.1.2: icmp_req=1 ttl=64 time=0.378 ms
64 bytes from 192.168.1.2: icmp_req=2 ttl=64 time=0.381 ms
64 bytes from 192.168.1.2: icmp_req=3 ttl=64 time=0.452 ms

    installation of linux: should i go with the new default BTRFS file system?!

    in Linux

    Posted

     

    what else shoud i safe - more than the /home/my_name

    You don't have to backUp all the /home directory, but only -> your documents, music, vidoes, pictures and thunderbird (mozilla) directory.  If you have a data (websites) in /var/www apache home dir, you should backUp it as well.

     

     

    i only want to use one operating system

    Then, approximately, 13 - 15GB for root, 2 - 3GB for swap and the rest for /home.

     

     

    i am not sure about the BTRFS question

    BTRFS is a new file system, use ext4 instead.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.