vagrant up by apache user

Install centos 6 on vagrant + virtualbox and make it php’s local development environment.

If you use vagrant, the execution user becomes ‘vagrant’, but is it possible to make it ‘apache’?

I created ssh.config in the directory where vagrantFile exists and tried to make user ‘apache’, but it did not work.

<?php exec("whoiam"); ?>  return 'vagrant'

The reason for this is because the executing user of the production environment is ‘apache’, so we want to match the local development environment with the production environment.

Source: stackoverflow-php

How to define global SESSION in CakePHP’s AppController?

I am using CakePHP 3.3

My Controller:

class ConfigsController extends AppController

    public $session;

    public function initialize()

        $this->session = $this->request->session();

I have this line below in every controller of my project

$this->session = $this->request->session();

Is there a way to define this in AppController’s initialize() and then I can access it by parent::session? Or anywhere else which makes it global.

Source: stackoverflow-php

How to resize image using php

I want to convert the image in low resolution with GD. I’m working on IBM Server under these speces
Version: PHP 7.0.15-0ubuntu0.16.04.4 (cli) ( NTS )
and I have also comment out the extension from php.ini but can’t enabled the GD on php server.
I Just received this error.

Run Command: sudo apt-get install libgd

Reading package lists… Done
Building dependency tree
Reading state information… Done
E: Unable to locate package libgd

Second Command When I run give this message:

1) packages have unmet dependencies

Cause of this Problem:

PHP Fatal error: Uncaught Error: Call to undefined function imagecreatefromstring()

Note please anyone tell me the step-by-step command to enable this GD Library on my this Linus machine.
thanks alot

Source: stackoverflow-php

filtering mysql results which are dynamically loaded

I have 3 pages

  • index.php
  • fetch_pages.php
  • script.js

and a list of artists, the get page fetches the results and the script.js asks for more to dynamically load it into index php, but it loads all of the artists.

loading all the artists dynamically took me a long time and I didn’t fully understand all of the code I’ve copied to achieve this, but now as I don’t fully understand it it’s hard to play around with it, but I believe that I’ll learn along the way

what I want to do is instead of loading all the artists to load the results according to user input (if he clicks photographers load photographers, if he enters a search term to look for results LIKE what he searched for)

What I’ve tried is the $_GET method, but it posts the searchterm in the url of index.php, and when I try to use $_GET in fetch_pages.php it doesn’t see the parameter.

my question is how to $_GET the url parameter from index.php to fetch_pages.php

below is my code


// including the config file
<!DOCTYPE html>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <link rel="stylesheet" href="" integrity="sha384-rwoIResjU2yc3z8GV/NPeZWAv56rSmLldC3R/AZzGRnGxQQKnKkoFVhFQhNUwEyJ" crossorigin="anonymous">
  <link href="" rel="stylesheet">
  <link href="//" rel="stylesheet">
  <link rel="stylesheet" href="css/style.css" />

Deploy the bitbucket code directly on production server

I am using the bitbucket to store our project. Now the problem is the project is very large and having more then 20k files in it. My server having FTP connection so i am not able to copy and paste the complete project code on server. So i want to direct deploy my code from bitbucket to my production server.

I can connect to the bitbucket server and make a git pull but i really want to find something to automate this.

I am looking for a easy and fast solution but i did not find anything for bitbucket, all solution seems to be designed for github…

Any service or tool for that to automate this process ?

Source: stackoverflow-php

How to convert Array to JSON

need your help about this one…
how can i convert this arrays to json code…

here’s my code:

$ch = curl_init();
// Disable SSL verification
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
// Will return the response, if false it print the response
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_USERPWD, "$username:$password");
// Set the url
curl_setopt($ch, CURLOPT_URL,$url);
// Execute
// Closing

// Will dump a beauty json :3
var_dump(json_decode($result, true));

$result = file_get_contents($url);
// Will dump a beauty json :3
var_dump(json_decode($result, true));

enter image description here

Source: stackoverflow-php

PHP if runs twice and generates duplicate records to the MySQL database

I am writing a little piece of code for the one game where users can bid and the biggest bid wins the round (like the auction). There is a 1-minute timer and when it ends, some actions occur. I will write all the details below.

Timer script:

$auctionTimer = 1;

$target_time = strtotime('+' . $auctionTimer .  'minutes', strtotime($r1['date']));
$current_time = time();
$seconds_left = $target_time - $current_time;
$minutes_left = floor($seconds_left / 60);

if (strlen($minutes_left) != 2) {
  $minutes_left = sprintf("%02d", $minutes_left);

$seconds_left -= $minutes_left * 60;
$seconds_left = floor($seconds_left);

if (strlen($seconds_left) != 2) {
  $seconds_left = sprintf("%02d", $seconds_left);

Something is bad with the if ($current_time > $target_time && $ragr1['count'] >= 1) { check:

$stmt1 = $pdo->prepare("SELECT id, user_id, user, bid, date FROM 
    tb_auction_bids ORDER BY id DESC");
$stmt1_while = $pdo->prepare("SELECT id, user_id, user, bid, date FROM 
$stmt3 = $pdo->prepare("SELECT id, user_id FROM tb_auction_winners ORDER BY 
    id DESC LIMIT 1");
$stmt11 = $pdo->prepare("SELECT id, user_id, user FROM tb_auction_bids ORDER 
    BY id DESC LIMIT 1");
$stmt12 = $pdo->prepare("TRUNCATE TABLE tb_auction_bids");

$agr1 = $pdo->prepare("SELECT COUNT(id) AS count FROM tb_auction_bids");
$agr2 = $pdo->prepare("SELECT SUM(bid) AS sum FROM tb_auction_bids");



$r1 = $stmt1->fetch(PDO::FETCH_ASSOC);
$r3 = $stmt3->fetch(PDO::FETCH_ASSOC);
$r11 = $stmt11->fetch(PDO::FETCH_ASSOC);

$ragr1 = $agr1->fetch(PDO::FETCH_ASSOC);
$ragr2 = $agr2->fetch(PDO::FETCH_ASSOC);

if ($current_time > $target_time && $ragr1['count'] >= 1) {
    ':user_id' => $r11['user_id'],
    ':user' => $r11['user'],
    ':win' => $ragr2['sum']
    ':win' => $ragr2['sum'],
    ':user_id' => $r1['user_id']
  while ($r1 = $stmt1_while->fetch(PDO::FETCH_ASSOC)) {
        ':user_id' => $r1['user_id'],
        ':aukciono_id' => $r3['id'],
        ':user' => $r1['user'],
        ':date' => $r1['date'],
        ':bid' => $r1['bid']
  } to

I guess I should not post PDO queries because the problem is not about SQL, it is about PHP. If you are not in this page (…/auction, e.g.), when the 1-minute timer ends, it does nothing at all. You have to go again to the …/auction, e.g., to get a reward. Should I use JavaScript to check if the timer ended and then execute the file?

This is how it looks like (video):

Also, I get

“SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘post’
cannot be null” error and I looked into this thread:
SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘post’ cannot be null

but it did not help. The $r1['aukciono_id'] is defined also as another variables but only the $r1['aukciono_id'] gives an error.

if ($current_time > $target_time && $ragr1['count'] >= 1) { should run only once but it runs twice and generates duplicate MySQL records. Am I doing something bad with PDO or PHP? Maybe it is because of that PDO error? Help me, please.

Source: stackoverflow-php