PHP - Keyword Tag Cloud, Array Scoring

I want to purchase cloud servers from DigitalOcean, however I know very little about managing and maintaining servers (I just develop the websites). I know what I need without knowing how to do it.

I have a tag column in the table of posts. I store tags as "tag1,tag2,tag3,...". When displaying tags in the post, I explode to have an array. Everything is OK, but I cannot create a tags cloud; as I need to have the occurrence of each tag to increase the font. What is a practical trick to create tag clouds?

I think the common method is to build a table for post tags and store each single tag in a separate cell. But I hope to keep my database tidy.

I read the conditions for hosting at PHP Fog, and they state that I can't use session variables as such variables are not copied between servers. Therefore I changed session variables for login info, language selection etc to cookies. Hence my own code is now free from session varibables, but Zend that I use for e.g. OAuth is not.

Is it typical that cloud hosting providers disallow session variables for the above reason, or are there others that can handle such replication between servers?

If not, is work going on to remove use of session variables from popular frameworks?

Cheers,
Anders

Hey Guys.

 

I want to implement google cloud vision api for recognise the image. Everything installed fine, I'm getting the error 

Google\Cloud\Core\Exception\ServiceException
{
"error": {
"code": 403,
"message": "The request is missing a valid API key.",
"status": "PERMISSION_DENIED"
}
}
1. in C:\xampp\htdocs\vofms\vendor\google\cloud-core\src\RequestWrapper.php at line 336
327328329330331332333334335336337338339340341342343344345                                case 504:
                $exception = Exception\DeadlineExceededException::class;
                break;
 
            default:
                $exception = Exception\ServiceException::class;
                break;
        }
 
        return new $exception($this->getExceptionMessage($ex), $ex->getCode(), $ex);
    }
 
    /**
     * Gets the exception message.
     *
     * @param \Exception $ex
     * @return string
     */
    private function getExceptionMessage(\Exception $ex)
                
2. in C:\xampp\htdocs\vofms\vendor\google\cloud-core\src\RequestWrapper.php at line 189 – Google\Cloud\Core\RequestWrapper::convertToGoogleException(GuzzleHttp\Exception\ClientException)
183184185186187188189190191192193194195                            try {
            return $backoff->execute($this->httpHandler, [
                $this->applyHeaders($request),
                $this->getRequestOptions($options)
            ]);
        } catch (\Exception $ex) {
            throw $this->convertToGoogleException($ex);
        }
    }
 
    /**
     * Deliver the request asynchronously.
     *
                
3. in C:\xampp\htdocs\vofms\vendor\google\cloud-core\src\RestTrait.php at line 96 – Google\Cloud\Core\RequestWrapper::send(GuzzleHttp\Psr7\Request, [])
90919293949596979899100101102                     
        try {
            return json_decode(
                $this->requestWrapper->send(
                    $this->requestBuilder->build($resource, $method, $options),
                    $requestOptions
                )->getBody(),
                true
            );
        } catch (NotFoundException $e) {
            if ($whitelisted) {
                throw $this->modifyWhitelistedError($e);
            }
                
4. in C:\xampp\htdocs\vofms\vendor\google\cloud-vision\src\Connection\Rest.php at line 59 – Google\Cloud\Vision\Connection\Rest::send('images', 'annotate', ['requests' => [['image' => ['content' => '/9j/4AAQSkZJRgABAQEBLAEsAAD/2wBD...'], 'features' => [['type' => 'FACE_DETECTION']]]]])
535455565758596061                     
    /**
     * @param array $args
     */
    public function annotate(array $args)
    {
        return $this->send('images', 'annotate', $args);
    }
}
                
5. in C:\xampp\htdocs\vofms\vendor\google\cloud-vision\src\VisionClient.php at line 272 – Google\Cloud\Vision\Connection\Rest::annotate(['requests' => [['image' => ['content' => '/9j/4AAQSkZJRgABAQEBLAEsAAD/2wBD...'], 'features' => [['type' => 'FACE_DETECTION']]]]])
266267268269270271272273274275276277278                            foreach ($images as $image) {
            $requests[] = $image->requestObject();
        }
 
        $res = $this->connection->annotate([
            'requests' => $requests
        ] + $options);
 
        $annotations = [];
        if (isset($res['responses'])) {
            foreach ($res['responses'] as $response) {
                $annotations[] = new Annotation($response);
            }
                
6. in C:\xampp\htdocs\vofms\vendor\google\cloud-vision\src\VisionClient.php at line 229 – Google\Cloud\Vision\VisionClient::annotateBatch([Google\Cloud\Vision\Image], [])
223224225226227228229230231232233234235                         * @param  Image $image The image to annotate
     * @param  array $options Configuration options
     * @return Annotation
     */
    public function annotate(Image $image, array $options = [])
    {
        $res = $this->annotateBatch([$image], $options);
        return $res[0];
    }
 
    /**
     * Annotate a set of images.
     *
                
7. in C:\xampp\htdocs\vofms\frontend\themes\admin_lte\site\index.php at line 22 – Google\Cloud\Vision\VisionClient::annotate(Google\Cloud\Vision\Image)
16171819202122232425262728                     
$image = $vision->image(
    fopen('C:\xampp\htdocs\vofms\frontend\themes\admin_lte\images\1.jpg', 'r'),
    ['faces']
);
 
$annotation = $vision->annotate($image);
 
// Determine if the detected faces have headwear.
foreach ($annotation->faces() as $key => $face) {
    if ($face->hasHeadwear()) {
        echo "Face $key has headwear.\n";
    }
                
8. in C:\xampp\htdocs\vofms\vendor\yiisoft\yii2\base\View.php at line 348 – require('C:\xampp\htdocs\vofms\frontend\t...')
9. in C:\xampp\htdocs\vofms\vendor\yiisoft\yii2\base\View.php at line 257 – yii\base\View::renderPhpFile('C:\xampp\htdocs\vofms\frontend\t...', ['dataProvider' => yii\data\ActiveDataProvider])
10. in C:\xampp\htdocs\vofms\vendor\yiisoft\yii2\base\View.php at line 156 – yii\base\View::renderFile('C:\xampp\htdocs\vofms\frontend\v...', ['dataProvider' => yii\data\ActiveDataProvider], frontend\controllers\SiteController)
11. in C:\xampp\htdocs\vofms\vendor\yiisoft\yii2\base\Controller.php at line 384 – yii\base\View::render('index', ['dataProvider' => yii\data\ActiveDataProvider], frontend\controllers\SiteController)
12. in C:\xampp\htdocs\vofms\frontend\controllers\SiteController.php at line 89 – yii\base\Controller::render('index', ['dataProvider' => yii\data\ActiveDataProvider])
83848586878889909192939495                            $dataProvider = new ActiveDataProvider([
            'query' => Offenses::find(),
        ]);
 
        return $this->render('index', [
            'dataProvider' => $dataProvider,
        ]);
    }
 
    /**
     * Displays a single Offenses model.
     * @param integer $id
     * @return mixed
                
13. frontend\controllers\SiteController::actionIndex()
14. in C:\xampp\htdocs\vofms\vendor\yiisoft\yii2\base\InlineAction.php at line 57 – call_user_func_array([frontend\controllers\SiteController, 'actionIndex'], [])
15. in C:\xampp\htdocs\vofms\vendor\yiisoft\yii2\base\Controller.php at line 157 – yii\base\InlineAction::runWithParams(['r' => 'site/index'])
16. in C:\xampp\htdocs\vofms\vendor\yiisoft\yii2\base\Module.php at line 528 – yii\base\Controller::runAction('index', ['r' => 'site/index'])
17. in C:\xampp\htdocs\vofms\vendor\yiisoft\yii2\web\Application.php at line 103 – yii\base\Module::runAction('site/index', ['r' => 'site/index'])
18. in C:\xampp\htdocs\vofms\vendor\yiisoft\yii2\base\Application.php at line 386 – yii\web\Application::handleRequest(yii\web\Request)
19. in C:\xampp\htdocs\vofms\frontend\web\index.php at line 17 – yii\base\Application::run()
11121314151617                        require _DIR_ . '/../../common/config/main.php',
    require _DIR_ . '/../../common/config/main-local.php',
    require _DIR_ . '/../config/main.php',
    require _DIR_ . '/../config/main-local.php'
);
 
(new yii\web\Application($config))->run()

Quote

 

Where I can set  GOOGLE_APPLICATION_CREDENTIALS environment variable in Yii2 framework.

 

 

Edited February 9, 2019 by PHPLazy

 I have questions but I also have some good info to share about putting your software in the cloud.  

The situation:

Some of you may have read about the nightmare stories. A developer had a infinite loop in his code that ran all night. This code did things inefficiently that devoured CPU in each iteration. This developer, greatly skilled,  opened his email the next morning and saw a email bill from his cloud provider totaling for $75K. True story. 

Most cloud providers let you define CPU usage thresholds that, when breached, send you a warning but these thresholds, if I understand them, are per account. 

It would seem the claim that cloud resources are available in whatever amounts you need, CPU, disk space, enough RAM to never have to wait on a page faults, etc... the claim that the cloud provides you with infinitely elastic  resources in an "all you can eat for one price" contract smells just a like a little like 💩

I did cloud development for many years with ServiceNow starting when it was a help desk and I watched it evolve into one of the best cloud development platforms out there. At one customer site I installed and managed it it out of the cloud and saw its insides and I can tell you its core code is not so terribly efficient. IMHO the cloud DOES take away 90% of a developer's worries about app performance..

If you call ServiceNow tech support and your problem is diagnosed as a performance issue with your code the first thing they will ask you is "did you follow the developer best practices"? They will politely say "sorry. Here's a link to them implying "fix your code". 

Questions: 

PHP Functions that devour CPU and where there is a better way?

What PHP functions or code techniques waste CPU? I am using similar_text and it does the job but it is slow. Better way?

What is the best way to measure CPU used by a PHP script or by a particular code module, defined as a set of related functions that fulfill a common purpose or by a single line of code? The purpose being to identify inefficient modules of code and improve them and even if the code is damn near perfect then at least can know what code modules are the most expensive.

CPU killin users (and developers too), how can they be identified?

I need to store data on cumulative CPU usage for any of the above and compare it with the free amount they give you and warn CPU hogs before they breach a threshold and generate $75K bills that were not in the plan.

Any info you have on avoiding surprise $75K CPU bills from a cloud provider are welcome

 

 

 

 

It would seem the 

Please can someone explain to me what the keyword as mean in the context of:

foreach ($row as $attribute)

I am new to php and some things just need a little explaining please.

Hi Everyone,
I'm trying to set up a system for my PHP MYSQL search that allows the user to type keywords. I've been doing this with one very long if statement, is there a better way? For example, I want to user to search for "chair" and have the thing return everything with a item number stating with 555. The length of the item number can vary between 10 and 12 numbers and that has slowed me down a bit.

Cheers, Rob

It's a function=>

Code: [Select]
function _wp_call_all_hook($args) {
global $wp_filter;
//var_dump($wp_filter);
//exit();

reset( $wp_filter['all'] );
do {
foreach( (array) current($wp_filter['all']) as $the_ )
if ( !is_null($the_['function']) )
call_user_func_array($the_['function'], $args);

} while ( next($wp_filter['all']) !== false );
}

Why is $wp_filter variable declared as global ? Was $wp_filter assigned before ?

Code: [Select]
if($keyword == ""){}else{

$get = mysql_query("SELECT * FROM domains, domains_keywords, keywords WHERE domains_keywords_domain=domains_id AND domains_keywords_keyword=keywords_id AND keywords_keyword='$keyword'");

}
so i have a textbox at the mo that you can put one keyword in and get results based on this one keyword.

how can I change this to a textarea and if say someone enters two keywords.. it will find results based on them having both keywords.

thanks in advance

I am having an error here with my code/script. I try and call sanitizeData($data) from functions.php class in createUser.php class. I end up with an expected 'new' T_NEW error.

createUser.php file

<?php
require('dbcon/dbcon.php');
include('fileUpload.php');
include('functions.php');

class createUser {

    public $functionsClassInstance = new helperFunctions();

    public $avatar;
    public $bio;
    public $video_count;
    public $c_status;
    public $usernameI;
    public $username;
    public $password;
    public $email;
    public $doc;
    public $last_logged_in;

       public function addUser(PDO $pdo) {
	// add user info to db
	       $avatar = "/soapbox/assets/soap.jpg";
	       $usernameI = $_POST['username'];
               $username = $functionsClassInstance->sanitizeData($usernameI);
	    //$username = strip_tags(trim($_POST['username'];))
            $password = password_hash($_POST['password'], PASSWORD_DEFAULT);
            $bio = $_POST['bio'];
            $email = $_POST['email'];
	    $c_status = 0;
            date_default_timezone_set('UTC');
	    $doc = date("Y-m-d h:i:s");
	    // account date last seen/logged in
	    // add account age

	    $query = $pdo->prepare("INSERT into profiles001 (username, password, email, c_status, bio, doc, avatar) VALUES (:username, :password, :email, :cstat, :bio, :doc, :avatar)");

	    $query->bindValue(':username', $username);
	    $query->bindValue(':password', $password);
	    $query->bindValue(':email', $email);
	    $query->bindValue(':doc', $doc);
	    $query->bindValue(':bio', $bio);
	    $query->bindValue(':cstat', $c_status);
	    $query->bindValue(':avatar', $avatar);

	    // if user uploads file, add path and file to database and server, if not revert to default.
            if ($_FILES["avatar"]["error"] == 4) {
	        $query->execute();
	    } elseif ($_FILES["avatar"]["error"] != 4) {
	        $file = new fileUpload();
		$file->processFile();
		$avatar = "/soapbox/uploads/" . $_FILES["avatar"]["name"];
	        $query = $pdo->prepare("INSERT into profiles001 (username, password, email, c_status, bio, doc, avatar) VALUES (:username, :password, :email, :cstat, :bio, :doc, :avatar)");
		
		$query->bindValue(':username', $username);
	        $query->bindValue(':password', $password);
	        $query->bindValue(':email', $email);
	        $query->bindValue(':doc', $doc);
	        $query->bindValue(':bio', $bio);
	        $query->bindValue(':cstat', $c_status);
	        $query->bindValue(':avatar', $avatar);
	        $query->execute();
	    }
	    // create variables
	    // initialize variables
	    // bind values of variables being entered into database
       }

}

// this file is responsible for creating the users
?>

functions.php class

<?php
// Functions are stored here
// Any code that is repeated more than once is put into a function to make my life easier
// The start of going from procedural to OOP

// checks if user is logged in or not, limits access to certain pages in/on site.
class helperFunctions {
    function sanitizeData($data) {
	    strip_tags($data);
	    trim($data);
	    return $data;
    }
}
?>

 

 

Hello Every one
 
 
Please see my code

<?php
include ("includes/config.php");
$afurl = $_SERVER['REQUEST_URI'];
$afurl = preg_replace('/\/+/', '', $afurl);
$afurl = preg_replace('/\;+/', '', $afurl);
$afurl = preg_replace('/\&+/', '', $afurl);
$afurl = preg_replace('/\#+/', '', $afurl);
$afurl = preg_replace('/\|+/', '', $afurl);
$afurl = preg_replace('/\@+/', '', $afurl);
$afurl = preg_replace('/\%5B+/', '', $afurl);
$afurl = preg_replace('/\%5D+/', '', $afurl);
$afurl = preg_replace('/\%27+/', '', $afurl);
$afurl = preg_replace('/\%C2+/', '', $afurl);
$afurl = preg_replace('/\%BB+/', '', $afurl);
$afurl = preg_replace('/quot+/', '', $afurl);
$afurl = preg_replace('/\%E2+/', '', $afurl);
$afurl = preg_replace('/\%80+/', '', $afurl);
$afurl = preg_replace('/\%93+/', '', $afurl);
$afurl = preg_replace('/\$+/', 'c', $afurl);
$afurl = preg_replace('/\"+/', '', $afurl);
$afurl = preg_replace('/\?+/', '', $afurl);
$afurl = preg_replace('/\.html+/', '', $afurl);
$afurl = preg_replace('/\-+/', ' ', $afurl);
$queryArray = explode(" ", $afurl);
for ($i=0; $i< count($queryArray); $i++) {
$keyworddd = mysql_real_escape_string($queryArray[$i]).",";
echo $keyworddd;
}
?>

I Want Set $keyworddd at he       <meta name="keywords" content="$keyworddd">     Can anyone tell me how to do this please?

This topic has been moved to Miscellaneous.

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

Hi All,

Just a couple of things with my site search, I am having trouble getting the search results to pickup any and all keywords. For example, if keywords for a search result are listed in the keywords column of my db as 'one, two, three' a search query for 'one two' is fine but a search for 'one three' will not display the search result. Instead of treating the keywords seperately it is treating all keywords as a whole phrase.

How can I make the search results pickup any keyword regardless of order.

Secondly I'm having trouble getting the search results to display by keyword relevance, any help is greatly appreciated.

Thanks.

Code: [Select]


function search()
{
parent::Controller();
$this->load->model('Templating');
$this->load->model('Company');
}

function index()
{
$this->load->view('search');
}
function search_redirect()
{
if ($_POST['keyword'] == '') $_POST['keyword'] = 'Keyword';
redirect('search/showlist/'.
urlencode(underscore($_POST['location'])).'/'.
urlencode(underscore($_POST['category'])).'/'.
urlencode(underscore($_POST['keyword'])));
}
function showlist($location = 'any', $category = 'any', $keyword = 'keyword',  $offset = '0')
{
/* get results */

$data['companies'] = $this->Company->search($keyword, $category, $location, $offset, $name);
/* paginate results */
$row = $data['companies']->row();

if($keyword == 'keyword' and $category=='any' ) {
$data['categoryList'] = $this->buildCategoryList($location);
}
elseif(isset($row->categoryId)) {
$categoryId = $row->categoryId;
$data['linkList'] = $this->buildRefineList($categoryId);
}
$this->load->library('pagination');
$config['base_url']    = site_url().'search/showlist/'.$location.'/'.$category.'/'.$keyword.'/';
$config['total_rows']  = $this->Company->total_companies;
$config['per_page']    = $this->Company->per_page;
$config['num_links']   = 3;
$config['uri_segment'] = $this->uri->total_segments();
$this->pagination->initialize($config);

$data['pagination'] = $this->pagination->create_links();
$data['logged_in'] = $this->session->userdata('logged_in');
$data['company_id'] = $this->session->userdata('company_id');
$data['search_category'] = $category;
$data['search_location'] = $location;
if ($this->session->userdata('admin') != ''){
$data['admin'] = $this->session->userdata('admin');
}

/* initialise template settings */
$center = 'center/list_companies';
$this->load->vars($data);
$this->Templating->show($center);
}

Problem: I'm trying to build a junction table for a many to many relationship. Table A contains a title string that contains in it names that are stored in Table B. Both tables have nearly a million rows.

Bad solution: The method I'm using right now is using PHP I fetch and store one table into an associative array. I then do a mysql_fetch loop on the second table and run this code to populate an array that is used to build the multi-insert SQL.

$title = preg_replace ($names, $keys, $title);
if (preg_match_all ('/(\d+)/', $title, $matches))
                   foreach ($matches[1] as $m)
                      $inserts[$row['id'].'-'.$m] = 1;

This works, but I'm looking for possibly a less cpu/memory intensive method. My remote server can't handle it, and we're talking hours and hours on a local server. It seems the bottleneck is with the preg_replace. I've also tried str_replace, which is only slightly faster. So, a method where I wouldn't have to pass around such large arrays, or an entirely different approach is what I'm looking for. Any ideas?