Blancer.com Tutorials and projects
Freelance Projects, Design and Programming Tutorials
Category Added in a WPeMatico Campaign
I am using the following code in my code to send a password reset token to a user.
$token = md5($user_id . time());
Why this is considered as a bad approach being cited as it has a weak entropy? The above code would generate a scary-looking 32 bit token that an attacker cannot decipher at all.
Suppose md5 reverse engineering is not possible (Although it is).
My question is why this is a bad approach? How do I say it has a weak entropy? Is there a way I can calculate its entropy?
I have 2 tables products and api_products i want to merge these 2 tables with pagination. I am getting issues with pagination when merging .
$internalProduct = $this->Product_model->listprodcts($limit, $offset);
$apiProduct = $this->Product_model->get_api_products_from_db($car_make_url, $car_model_url, $car_year_url);
Hi I’m using this code in my page to move to the same page but with account access, I’m learning how to use various languages so I didn’t want to use Javascript.
<label for="toggleBanner" class="open-btn">Log In</label>
<!-- Overlay del banner -->
<div class="overlay">
<div class="overlay-content">
<!-- Etichetta per chiudere il banner -->
<label for="toggleBanner" class="close">×</label>
<h2>Inserisci credenziali</h2>
<form method="post" action="LogIn.php?CODICE=<?php echo htmlspecialchars($codice, ENT_QUOTES, 'UTF-8'); ?>">
<label for="name">Nome:</label>
<input type="text" id="name" name="name" required><br><br>
<label for="password">Password:</label>
<input type="password" id="password" name="password" required><br><br>
<input type="submit" value="Invia">
</form>
</div>
</div>
The problem that occurs is that the $codice that passes from one page to another is not received and is always interpreted 0.
Thanks in advance for any advice, and also for tips on other things
Despite having checked several times that before pressing send the page knows which code it refers to.
I am working on a model to generate responses for the selected AImodels and send them to views at the end simultaneously as you can see in my process method below.
<?php
namespace AppControllers;
use AppModelsExamModel;
use AppModelsVendorModel;
use AppModelsExamTopicModel;
use AppModelsCertificationModel;
use AppModelsAIResponseModel;
use ReactPromisePromise;
class OptionController extends BaseController
{
public function index()
{
// Display the form view
return view('options_form');
}
public function process()
{
$db = ConfigDatabase::connect();
$examModel = new ExamModel();
$examTopicModel = new ExamTopicModel();
$certificationModel = new CertificationModel();
$vendorModel = new VendorModel();
$responseModel = new AIResponseModel();
// Get form inputs
$exam_codes_raw = $this->request->getPost('examCodes'); // The raw input string of exam codes
$aiModels = $this->request->getPost('aiModel'); // Array of selected AI models
$prompt_template = $this->request->getPost('prompt'); // User-provided prompt
$project_name = $this->request->getPost('projectName'); // User-provided project name
// Ensure $exam_codes_raw is treated as a string
if (is_array($exam_codes_raw)) {
$exam_codes_raw = implode("n", $exam_codes_raw); // Convert array to string
}
// Split the raw exam codes string into an array
$exam_codes = preg_split('/[rn,]+/', trim($exam_codes_raw));
$responses = [];
$insertedId = null; // Initialize variable to avoid "undefined variable" errors
// Determine if headings should be applied based on keywords in the prompt template
$keywords = ['information', 'info', 'article', 'articles', 'post', 'something', 'tell', 'tell me', 'artical', 'arrticle', 'poost', 'say', 'illuminate', 'shed'];
$applyHeadings = false;
foreach ($keywords as $keyword) {
if (stripos($prompt_template, $keyword) !== false) {
$applyHeadings = true;
break;
}
}
// Loop through each exam code
foreach ($exam_codes as $exam_code) {
// Trim any extra whitespace for each exam code
$exam_code = trim($exam_code);
// Fetch exam details from the database
$exam = $examModel->where('exam_code', $exam_code)->first();
if ($exam === null) {
$responses[$exam_code] = [
'error' => 'Could not find data for exam code ' . $exam_code,
'model' => []
];
continue;
}
$certification = $certificationModel->find($exam['certification_ids']);
if ($certification === null) {
$responses[$exam_code] = [
'error' => 'Could not find certification data for exam code ' . $exam_code,
'model' => []
];
continue;
}
$vendor = $vendorModel->find($exam['vendor_id']);
if ($vendor === null) {
$responses[$exam_code] = [
'error' => 'Could not find vendor data for exam code ' . $exam_code,
'model' => []
];
continue;
}
$topics = $examTopicModel->where('exam_code', $exam_code)->findAll();
$topicsSections = array_map(function($topic) {
return $topic['description'];
}, $topics);
// Process the prompt
$parsed_prompt = $this->processPrompt(
$exam_code,
$prompt_template,
$exam['name'],
$exam['exam_shortname'],
$certification['detail_name'],
$certification['cert_shortname'],
$vendor['name'],
$topicsSections // Pass the array of topics
);
// Check if there was an error in processing the prompt
if (strpos($parsed_prompt, 'Error:') !== false) {
// Handle the error by skipping the AI generation for this exam code
$responses[$exam_code] = [
'error' => $parsed_prompt,
'model' => []
];
}
// Call the respective AI models for the parsed prompt
foreach ($aiModels as $aiModel) {
$response = '';
$modelName = ucfirst($aiModel); // Example: 'openai' becomes 'OpenAI'
try {
switch ($aiModel) {
// Handle AI model requests as needed
case 'openai-gpt-3.5-Turbo':
$apiKey = '';
$response = $this->generateTextOpenAI($parsed_prompt, $apiKey);
break;
case 'cohere':
$apiKey = '';
$response = $this->generateTextCohere($parsed_prompt, $apiKey, $exam_code);
break;
case 'claude-3-Opus':
$apiKey = '';
$response = $this->generateTextClaudeOpus($parsed_prompt, $apiKey);
break;
case 'openai-gpt-4o-mini':
$apiKey = '';
$response = $this->generateTextOpenAIGPT4omini($parsed_prompt, $apiKey);
break;
case 'claude-3-Haiku':
$apiKey = '';
$response = $this->(generateTextClaudeHaiku$parsed_prompt, $apiKey);
break;
case 'claude-3.5-Sonnet':
$apiKey = '';
$response = $this->generateTextClaudeSonnet($parsed_prompt, $apiKey);
break;
case 'openai-gpt-4-turbo':
$apiKey = '';
$response = $this->generateTextOpenAIGPT4turbo($parsed_prompt, $apiKey);
break;
}
$responses[$exam_code]['model'][$aiModel] = $response;
// Store the AI model name and its response
$responseDatetime = date('Y-m-d H:i:s'); // Current date and time
// Insert data into the table
$builder = $db->table('responses');
// Prepare the data to insert
$data = [
'ai_model' => $modelName,
'created_at' => $responseDatetime,
'prompt' => $parsed_prompt, // Store the actual parsed prompt
'response' => $response, // Store the AI generated response
'project_name' => $project_name, // Store the project name
];
$builder->insert($data);
$insertedId = $db->insertID();
} catch (Exception $e) {
// Display error message if something goes wrong
$responses[$exam_code]['model'][$modelName] = "Error: " . $e->getMessage();
}
}
}
return view('response_view', [
'insertedId' => $insertedId,
'responses' => $responses
]);
}
The response is being sent to the views as whole. I have to wait for all my responses to be completed then appear on the views all at once.
**
The problem is I want the dynamic responses on my views. The moment an
AiModel that was selected is done with generation it should appear on
the views instead of waiting for all of them.
**
Below is my views code:
<body>
<div class="container">
<div class="wrapper">
<!-- Sidebar -->
<nav id="sidebar">
<div class="sidebar-header">
<h3>AI Prompt Model</h3>
</div>
<ul class="list-unstyled components">
<li class="active">
<ul class="collapse list-unstyled" id="homeSubmenu">
<li>
<a onclick="window.location.href='<?= base_url('dashboard'); ?>'">Go to Dashboard</a>
</li>
<li>
<a onclick="window.location.href='<?= base_url('homepage'); ?>'">Go to Home Page</a>
</li>
</ul>
</li>
</ul>
</nav>
<div class="main-content">
<h1>AI Model Responses</h1>
<div class="exam-section">
<button id="compareButton">Compare Selected</button>
<table>
<thead>
<tr>
<th>Select</th>
<th>Exam Code</th>
<th>AI Model</th>
<th>Response</th>
<th>Action</th> <!-- Add this column -->
</tr>
</thead>
<tbody>
<?php
$exam_responses = [];
foreach ($responses as $exam_code => $data):
if (isset($data['model']) && !empty($data['model'])):
foreach ($data['model'] as $model => $response):
$normalized_model = strtolower($model);
if (!isset($exam_responses[$exam_code])) {
$exam_responses[$exam_code] = [];
}
// Ensure the response is a string
if (is_array($response)) {
// If response is an array, assume it's the first item in the array
$response = isset($response['response']) ? $response['response'] : '';
}
$response = preg_replace('/**(.+?)**/', '<strong>$1</strong>', $response);
$response = preg_replace('/^#### (.+)$/m', '<h4>$1</h4>', $response);
$response = preg_replace('/^### (.+)$/m', '<h3>$1</h3>', $response);
$response = preg_replace('/^## (.+)$/m', '<h2>$1</h2>', $response);
if (!isset($exam_responses[$exam_code][$normalized_model])) {
$exam_responses[$exam_code][$normalized_model] = $response;
}
endforeach;
endif;
endforeach;
?>
<?php foreach ($exam_responses as $exam_code => $models):
foreach ($models as $model => $response):
$decoded_response = is_string($response) ? htmlspecialchars_decode($response) : '';
?>
<tr>
<td>
<input type="checkbox" class="response-checkbox"
data-exam-code="<?= htmlspecialchars($exam_code) ?>"
data-response="<?= htmlspecialchars($decoded_response) ?>"
data-model="<?= htmlspecialchars(ucwords($model)) ?>">
</td>
<td><?= htmlspecialchars($exam_code) ?></td>
<td><?= htmlspecialchars(ucwords($model)) ?></td>
<td>
<button class="response-btn" onclick="toggleResponse(this)">View Response</button>
<div class="response-box"><?= htmlspecialchars_decode($decoded_response) ?></div>
</td>
<td>
<button class="delete-btn" data-id="<?= htmlspecialchars($insertedId) ?>"
onclick="deleteRow(this)">Delete
</button>
</td>
</tr>
<?php
endforeach;
endforeach;
?>
</tbody>
</table>
</div>
<a href="<?= base_url('optioncontroller'); ?>">Go back</a>
</div>
</div>
<!-- Copy Notification -->
<div class="copy-notification" id="copyNotification">Response copied to clipboard</div>
<!-- Compare Modal -->
<div id="compareModal" class="modal">
<div class="modal-content">
<h2>Compare Responses</h2>
<div id="compareResults"></div>
</div>
</div>
Any help would be appreciated!
OK, so i have a weired issue with a simple update query.
We believe this happpened when we switched servers and thus a new MariaDB version.
We currently use MariaDB 10.11, php 8.3 and PDO to execute a query. On an AlmaLinux 9 server
Before we were on CentOs 7 with MariaDB 10.6, and same php 8.3
The query in question is quite simple and updates 2 datetime columns
First, last run date to the value of the scheduled next run date, and then next run date to when this job finished.
$query = $this->db->prepare("UPDATE `{$this->Config->sql_prefix}_jobs` SET `last_at` = `next_at`, `next_at` = :next_at WHERE `id` = :id");
Now, mysql should work of the columns in sequence as they are defined. But this not always works.
like 8 out of 10 days, first the next_at gets updated and then last_at, so the wrong order.
Making both columns the same value.
I can ( and i do ) work around this issue by simply passing a calculated value as named parameter for last_at column, but i have other queries where this also happens and its not possible there due sheer amount of data, which i first would need to query and process in php.
EDIT: I should also mention, that when i execute this query directly within mysql / phpmyadmin, the issue does not appear.
So i have a feeling this might be a php/pdo issue.
Does anyone have some kind of clue?
I have a laravel project which is supposed to use a package from /packages directory. I keep getting error when I run composer update or composer install (I even tried clearing composer’s cache):
Your requirements could not be resolved to an installable set of
packages.Problem 1
– Root composer.json requires gata/gata-webhooks, it could not be found in any version, there may be a typo in the package name.Potential causes:
- A typo in the package name
- The package is not available in a stable-enough version according to your minimum-stability setting see
https://getcomposer.org/doc/04-schema.md#minimum-stability for more
details.- It’s a private package and you forgot to add a custom repository to find it
Following is the directory structure of my main project and the sub package. The main project is on the “main” git branch.
I added the following code in my main project’s composer file:
"require": {
"php": "^8.2",
"laravel/framework": "^11.9",
"laravel/sanctum": "^4.0",
"laravel/tinker": "^2.9",
"gata/gata-webhooks": "*"
},
...
"autoload": {
"psr-4": {
"App\": "app/",
"Database\Factories\": "database/factories/",
"Database\Seeders\": "database/seeders/",
"Gata\GataWebhooks\": "packages/gata-webhooks/src/"
}
}
...
"extra": {
"laravel": {
"dont-discover": [],
"providers": [
"Gata\GataWebhooks\GataWebhooksServiceProvider"
]
},
"repositories": [
{
"type": "path",
"url": "./packages/*",
"options": {
"symlink": true
}
}
]
},
...
},
"minimum-stability": "dev",
"prefer-stable": true
And my package has the following in it’s composer.json
{
"name": "gata/gata-webhooks",
"description": "Webhooks to receive payloads from e-commerce systems",
"version": "1.0.0",
"type": "library",
"license": "MIT",
"autoload": {
"psr-4": {
"Gata\GataWebhooks\": "src/"
}
},
"require": {
},
"minimum-stability": "dev",
"prefer-stable": true
}
Can someone please tell me what I am doing wrong?
i have a problem with this cronjob function its related to a chatbot The problem is when user start broadcast campaigns other users have to wait until next one can start
public function subscriber_broadcaster($api_key="") // braodcast_message
{
// $this->api_key_check($api_key);
$broadcaster_number_of_message_to_be_sent_in_try=$this->config->item("broadcaster_number_of_message_to_be_sent_in_try");
if($broadcaster_number_of_message_to_be_sent_in_try==0) $broadcaster_number_of_message_to_be_sent_in_try="";
$broadcaster_update_report_after_time=$this->config->item("broadcaster_update_report_after_time");
if($broadcaster_update_report_after_time=="" || $broadcaster_update_report_after_time==0) $broadcaster_update_report_after_time=10;
$number_of_campaign_to_be_processed = 1; // max number of campaign that can be processed by this cron job
// $number_of_message_tob_be_sent = 50000; // max number of message that can be sent in an hour
$subscriber_broadcaster_hold_after_number_of_errors=$this->config->item("subscriber_broadcaster_hold_after_number_of_errors");
if($subscriber_broadcaster_hold_after_number_of_errors=="" || $subscriber_broadcaster_hold_after_number_of_errors==0)
$subscriber_broadcaster_hold_after_number_of_errors=30; // default 10
/****** Get all campaign from database where status=0 means pending ******/
$where_str = " (posting_status='0' OR is_try_again='1') AND posting_status!='3'";
$this->db->where($where_str);
$join = array('users'=>'messenger_bot_broadcast_serial.user_id=users.id,left');
$campaign_info= $this->basic->get_data("messenger_bot_broadcast_serial",$where='',$select=array("messenger_bot_broadcast_serial.*","users.deleted as user_deleted","users.status as user_status","users.user_type as user_type"),$join,$limit=50, $start=0, $order_by='schedule_time ASC');
$page_ids_names=array();
$access_token_database_database=array();
$facebook_rx_fb_user_info_id_database=array();
$campaign_id_array=array(); // all selected campaign id array
$campaign_info_fildered = array(); // valid for process, campign info array
$valid_campaign_count = 1;
foreach($campaign_info as $info)
{
if($this->is_demo=='1' && $info['user_type']=="Admin")
{
$this->db->where("id",$info['id']);
$this->db->update("messenger_bot_broadcast_serial",array("posting_status"=>"1","is_try_again"=>"0"));
continue;
}
if($info['user_deleted'] == '1' || $info['user_status']=="0")
{
$this->db->where("id",$info['id']);
$this->db->update("messenger_bot_broadcast_serial",array("posting_status"=>"1","is_try_again"=>"0"));
continue;
}
$campaign_id= $info['id'];
$time_zone= $info['timezone'];
$schedule_time= $info['schedule_time'];
$total_thread = $info["total_thread"];
$page_id =$info["page_id"]; // auto ids
$fb_page_id =$info["fb_page_id"];
$user_id = $info["user_id"];
if($time_zone) date_default_timezone_set($time_zone);
$now_time = date("Y-m-d H:i:s");
if((strtotime($now_time) < strtotime($schedule_time)) && $time_zone!="") continue;
if($valid_campaign_count > $number_of_campaign_to_be_processed) break;
// get access token and fb user id
$token_info = $this->basic->get_data('facebook_rx_fb_page_info',array("where"=>array('id'=>$page_id,'user_id'=>$user_id)));
foreach ($token_info as $key => $value)
{
$access_token_database_database[$campaign_id][$value["id"]] = $value['page_access_token'];
$facebook_rx_fb_user_info_id = $value["facebook_rx_fb_user_info_id"];
$facebook_rx_fb_user_info_id_database[$campaign_id] = $facebook_rx_fb_user_info_id;
$page_ids_names[$value["id"]] = $value["page_name"];
}
// valid campaign info and campig ids
$campaign_info_fildered[] = $info;
$campaign_id_array[] = $info['id'];
$valid_campaign_count++;
}
if(count($campaign_id_array)==0) exit();
$this->db->where_in("id",$campaign_id_array);
$this->db->update("messenger_bot_broadcast_serial",array("posting_status"=>"1","is_try_again"=>"0"));
// get config id
$getdata= $this->basic->get_data("facebook_rx_fb_user_info",array("where_in"=>array("id"=>$facebook_rx_fb_user_info_id_database)),array("id","facebook_rx_config_id"));
foreach ($getdata as $key => $value)
{
$facebook_rx_config_id_database[$value["id"]] = $value["facebook_rx_config_id"];
}
$this->load->library("fb_rx_login");
// send message
foreach($campaign_info_fildered as $info)
{
$campaign_id= $info['id'];
$user_id = $info["user_id"];
$catch_error_count=$info["last_try_error_count"];
$successfully_sent=$info["successfully_sent"];
$successfully_delivered=$info["successfully_delivered"];
$fb_rx_fb_user_info_id = $facebook_rx_fb_user_info_id_database[$campaign_id]; // find gb user id for this campaign
$this->fb_rx_login->app_initialize($facebook_rx_config_id_database[$fb_rx_fb_user_info_id]);
$i=0;
$campaign_lead=$this->basic->get_data("messenger_bot_broadcast_serial_send",array("where"=>array("campaign_id"=>$campaign_id,"processed"=>"0")),'','',$broadcaster_number_of_message_to_be_sent_in_try);
foreach($campaign_lead as $key => $value)
{
if($catch_error_count>$subscriber_broadcaster_hold_after_number_of_errors) // if 30 catch block error then stop sending, mark as complete
{
$this->basic->update_data("messenger_bot_broadcast_serial",array("id"=>$campaign_id),array("posting_status"=>'4','successfully_sent'=>$successfully_sent,'completed_at'=>date("Y-m-d H:i:s"),"error_message"=>$error_msg,"is_try_again"=>"0","last_try_error_count"=>$catch_error_count));
break;
}
$campaign_message_send=$info["message"];
$page_id_send = $value["page_id"];
$send_table_id = $value['id'];
$subscribe_id = $value['subscribe_id'];
$subscribeauto_id = $value['subscriber_auto_id'];
$client_first_name = $value['subscriber_name'];
$client_last_name = $value['subscriber_lastname'];
$client_otn_token=$value['otn_token']; // if OTN Campaign
$error_msg="";
$message_error_code = "";
$message_sent_id = "";
if(!isset($access_token_database_database[$campaign_id][$page_id_send])) continue;
$page_access_token_send = $access_token_database_database[$campaign_id][$page_id_send]; // get access toke from our access token database
// generating message
$campaign_message_send = str_replace('{{first_name}}',$client_first_name,$campaign_message_send);
$campaign_message_send = str_replace('{{last_name}}',$client_last_name,$campaign_message_send);
$replace_search=array('PUT_SUBSCRIBER_ID','#SUBSCRIBER_ID_REPLACE#');
$campaign_message_send=str_replace($replace_search, $subscribe_id, $campaign_message_send);
if($client_otn_token!="")
$campaign_message_send = str_replace('PUT_OTN_TOKEN',$client_otn_token,$campaign_message_send);
// print_r($campaign_message_send); continue;
$message_sent_id="";
$now_sent_time=date("Y-m-d H:i:s");
$deliveryTime='';
$isDelivered='0';
$successfully_sent++;
try
{
// $campaign_message_send = spintax_process($campaign_message_send);
$response = $this->fb_rx_login->send_non_promotional_message_subscription($campaign_message_send,$page_access_token_send);
if(isset($response['message_id']))
{
$message_sent_id = $response['message_id'];
$successfully_delivered++;
$deliveryTime=date("Y-m-d H:i:s");
$isDelivered="1";
}
else
{
if(isset($response["error"]["message"])) $message_sent_id = $response["error"]["message"];
if(isset($response["error"]["code"])) $message_error_code = $response["error"]["code"];
if($message_error_code=="551") // unvalilable user
{
$this->basic->update_data("messenger_bot_subscriber",array("id"=>$subscribeauto_id),array("unavailable"=>"1","last_error_message"=>$message_sent_id));
}
else
{
$error_msg = $message_sent_id;
$catch_error_count++;
}
}
}
catch(Exception $e)
{
$error_msg = $e->getMessage();
$catch_error_count++;
}
// generating new report with send message info
$i++;
// after 10 send update report in database
if($i%$broadcaster_update_report_after_time==0)
{
$this->basic->update_data("messenger_bot_broadcast_serial",array("id"=>$campaign_id),array('successfully_sent'=>$successfully_sent,"successfully_delivered"=>$successfully_delivered,"error_message"=>$error_msg,"last_try_error_count"=>$catch_error_count));
}
// updating a lead, marked as processed
$this->basic->update_data("messenger_bot_broadcast_serial_send",array("id"=>$send_table_id),array('processed'=>'1',"sent_time"=>$now_sent_time,"delivered"=>$isDelivered,"delivery_time"=>$deliveryTime,"message_sent_id"=>$message_sent_id));
}
// one campaign completed, now update database finally
if((count($campaign_lead)<$broadcaster_number_of_message_to_be_sent_in_try) || $broadcaster_number_of_message_to_be_sent_in_try=="" || $catch_error_count>$subscriber_broadcaster_hold_after_number_of_errors)
{
$new_posting_status = ($catch_error_count>$subscriber_broadcaster_hold_after_number_of_errors) ? '4' : '2';
$complete_update=array("posting_status"=>$new_posting_status,'successfully_sent'=>$successfully_sent,"successfully_delivered"=>$successfully_delivered,'completed_at'=>date("Y-m-d H:i:s"),"is_try_again"=>"0","last_try_error_count"=>$catch_error_count);
if(isset($error_msg))
$complete_update["error_message"]=$error_msg;
$this->basic->update_data("messenger_bot_broadcast_serial",array("id"=>$campaign_id),$complete_update);
}
else // suppose broadcaster_update_report_after_time=20 but there are 19 message to sent, need to update report in that case
{
$this->basic->update_data("messenger_bot_broadcast_serial",array("id"=>$campaign_id),array('successfully_sent'=>$successfully_sent,"successfully_delivered"=>$successfully_delivered,"is_try_again"=>"1"));
}
$this->basic->update_data('otn_postback',['id'=>$info['otn_postback_id']],['rcn_last_sent_time'=>date("Y-m-d H:i:s")]);
}
}
i want to run all campaigns once without waiting to running campaign to finish.
i tried this modification but not working for me to running it into multitask
public function subscriber_broadcaster($api_key = "") // broadcast_message
{
// $this->api_key_check($api_key);
$broadcaster_number_of_message_to_be_sent_in_try = $this->config->item("broadcaster_number_of_message_to_be_sent_in_try");
if ($broadcaster_number_of_message_to_be_sent_in_try == 0) $broadcaster_number_of_message_to_be_sent_in_try = "";
$broadcaster_update_report_after_time = $this->config->item("broadcaster_update_report_after_time");
if ($broadcaster_update_report_after_time == "" || $broadcaster_update_report_after_time == 0) $broadcaster_update_report_after_time = 10;
$number_of_campaign_to_be_processed = 20; // max number of campaign that can be processed by this cron job
$subscriber_broadcaster_hold_after_number_of_errors = $this->config->item("subscriber_broadcaster_hold_after_number_of_errors");
if ($subscriber_broadcaster_hold_after_number_of_errors == "" || $subscriber_broadcaster_hold_after_number_of_errors == 0)
$subscriber_broadcaster_hold_after_number_of_errors = 30; // default 10
/****** Get all campaign from database where status=0 means pending ******/
$where_str = " (posting_status='0' OR is_try_again='1') AND posting_status!='3'";
$this->db->where($where_str);
$join = array('users' => 'messenger_bot_broadcast_serial.user_id = users.id, left');
$campaign_info = $this->basic->get_data("messenger_bot_broadcast_serial", '', array(
"messenger_bot_broadcast_serial.*",
"users.deleted as user_deleted",
"users.status as user_status",
"users.user_type as user_type"
), $join, $limit = $number_of_campaign_to_be_processed, $start = 0, $order_by = 'schedule_time ASC');
if (count($campaign_info) == 0) exit();
// Initialize arrays for handling multi-cURL
$multiHandle = curl_multi_init();
$curlHandles = [];
$campaignHandlesMap = []; // Map to track which curl handle corresponds to which campaign
foreach ($campaign_info as $info) {
// Skip invalid campaigns
if ($info['user_deleted'] == '1' || $info['user_status'] == "0") {
$this->db->where("id", $info['id']);
$this->db->update("messenger_bot_broadcast_serial", array("posting_status" => "4", "is_try_again" => "0"));
continue;
}
// Prepare data for each campaign
$campaign_id = $info['id'];
$time_zone = $info['timezone'];
$schedule_time = $info['schedule_time'];
$user_id = $info['user_id'];
if ($time_zone) date_default_timezone_set($time_zone);
$now_time = date("Y-m-d H:i:s");
// Skip campaigns scheduled for the future
if ((strtotime($now_time) < strtotime($schedule_time)) && $time_zone != "") continue;
// Get access tokens and prepare messages
$token_info = $this->basic->get_data('facebook_rx_fb_page_info', array("where" => array('id' => $info["page_id"], 'user_id' => $user_id)));
foreach ($token_info as $key => $value) {
$access_token_database[$campaign_id][$value["id"]] = $value['page_access_token'];
}
// Fetch leads to process for the current campaign
$campaign_lead = $this->basic->get_data("messenger_bot_broadcast_serial_send", array("where" => array("campaign_id" => $campaign_id, "processed" => "0")), '', '', $broadcaster_number_of_message_to_be_sent_in_try);
foreach ($campaign_lead as $key => $value) {
$campaign_message_send = $info["message"];
$page_id_send = $value["page_id"];
$client_first_name = $value['subscriber_name'];
$client_last_name = $value['subscriber_lastname'];
$campaign_message_send = str_replace('{{first_name}}', $client_first_name, $campaign_message_send);
$campaign_message_send = str_replace('{{last_name}}', $client_last_name, $campaign_message_send);
if (!isset($access_token_database[$campaign_id][$page_id_send])) continue;
$page_access_token_send = $access_token_database[$campaign_id][$page_id_send];
// Prepare CURL request for each lead
$url = "https://graph.facebook.com/v4.0/me/messages?access_token={$page_access_token_send}";
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, $url);
curl_setopt($curl, CURLOPT_POST, 1);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($curl, CURLOPT_POSTFIELDS, json_encode($campaign_message_send));
curl_setopt($curl, CURLOPT_HTTPHEADER, array("Content-Type: application/json"));
// Add handle to multi-cURL
curl_multi_add_handle($multiHandle, $curl);
// Track the handles and campaign info
$curlHandles[] = $curl;
$campaignHandlesMap[(string)$curl] = [
'campaign_id' => $campaign_id,
'send_table_id' => $value['id']
];
}
// Set the campaign to "in progress"
$this->db->where("id", $campaign_id);
$this->db->update("messenger_bot_broadcast_serial", array("posting_status" => "1", "is_try_again" => "0"));
}
// Execute multi-cURL to process all requests concurrently
$running = null;
do {
curl_multi_exec($multiHandle, $running);
curl_multi_select($multiHandle);
} while ($running > 0);
// Process each result
foreach ($curlHandles as $curl) {
$response_data = curl_multi_getcontent($curl);
$response_data = json_decode($response_data, true);
$campaign_data = $campaignHandlesMap[(string)$curl];
$campaign_id = $campaign_data['campaign_id'];
$send_table_id = $campaign_data['send_table_id'];
// Handle response for each request
if (isset($response_data['message_id'])) {
// Message sent successfully
$this->basic->update_data("messenger_bot_broadcast_serial_send", array("id" => $send_table_id), array('processed' => '1'));
} else {
// Handle error
$error_msg = isset($response_data["error"]["message"]) ? $response_data["error"]["message"] : "Unknown error";
$this->basic->update_data("messenger_bot_broadcast_serial_send", array("id" => $send_table_id), array('processed' => '0', "error_message" => $error_msg));
}
// Remove handle
curl_multi_remove_handle($multiHandle, $curl);
curl_close($curl);
}
// Close the multi-handle
curl_multi_close($multiHandle);
// Finalize each campaign's status based on success/failure
foreach ($campaign_info as $info) {
$campaign_id = $info['id'];
$catch_error_count = $info["last_try_error_count"];
$successfully_sent = $info["successfully_sent"];
$successfully_delivered = $info["successfully_delivered"];
$error_msg = null;
// Check if all leads are processed for this campaign, if so, mark it as completed
$remaining_leads = $this->basic->get_data("messenger_bot_broadcast_serial_send", array("where" => array("campaign_id" => $campaign_id, "processed" => "0")));
if (count($remaining_leads) == 0 || $catch_error_count > $subscriber_broadcaster_hold_after_number_of_errors) {
$new_posting_status = ($catch_error_count > $subscriber_broadcaster_hold_after_number_of_errors) ? '4' : '2';
$complete_update = array(
"posting_status" => $new_posting_status,
'successfully_sent' => $successfully_sent,
"successfully_delivered" => $successfully_delivered,
'completed_at' => date("Y-m-d H:i:s"),
"is_try_again" => "0",
"last_try_error_count" => $catch_error_count
);
if (isset($error_msg)) {
$complete_update["error_message"] = $error_msg;
}
$this->basic->update_data("messenger_bot_broadcast_serial", array("id" => $campaign_id), $complete_update);
} else {
$this->basic->update_data("messenger_bot_broadcast_serial", array("id" => $campaign_id), array(
'successfully_sent' => $successfully_sent,
"successfully_delivered" => $successfully_delivered,
"is_try_again" => "1"
));
}
$this->basic->update_data('otn_postback', ['id' => $info['otn_postback_id']], ['rcn_last_sent_time' => date("Y-m-d H:i:s")]);
}
}
I am new to this PHP and .tpl thing, And I found a template on this website. When openup the XAMPP Apache server, when I go to localhost/terminal, I get this error :
Fatal error: Uncaught Error: Class “Smarty” not found in C:xampphtdocsterminalindex.php:5 Stack trace: #0 {main} thrown in C:xampphtdocsterminalindex.php on line 5
Thanks in advance.
I have tried reinstall XAMPP, even downloaded Smarty in my project folder via composer, But still this error pops up. A homepage was expected.
This is my folder structure :
enter image description here
Code in index.php :
<?php
require_once 'vendor/autoload.php'; // Include Composer's autoload file
// Initialize Smarty
$smarty = new Smarty();
// Example usage
$smarty->setTemplateDir('templates/');
$smarty->assign('name', 'World');
$smarty->display('index.tpl'); // Make sure 'index.tpl' exists in 'templates/'
// Optional: Output a simple message
echo "Smarty is set up and running!";
?>
Apology for anything mistakes because this is my first time asking a question.
My editor shows an error even the field is not a protected, now I wondering if model is valid column name or it just a bug in PHP debugging tools/extensions.
I am using VScode and I have this php related extensions:
I disabled PHP by DEVSENSE and the errors gone so its likely a bug in an extension?
Error message: Member has protected visibility and is not accessible from the current context.PHP(PHP1416)
I tried to use it and I successfully display the data
ProductController.php
<?php
namespace AppHttpControllers;
use IlluminateHttpRequest;
use AppModelsProduct;
class ProductController extends Controller
{
/**
* Display a listing of the resource.
*/
public function index()
{
$products = Product::all();
$products = $products->map(function ($product) {
return [
'id' => $product->id,
'name' => $product->name,
'brand' => $product->brand,
'model' => $product->model,
'description' => $product->description,
'image_url' => $product->image_url,
'price' => $product->price,
'category_name' => $product->category->name ?? 'N/A',
'supplier_name' => $product->supplier->name ?? 'N/A',
];
});
return response()->json($products);
}
}
Product.php in Models
<?php
namespace AppModels;
use IlluminateDatabaseEloquentFactoriesHasFactory;
use IlluminateDatabaseEloquentModel;
class Product extends Model
{
use HasFactory;
public function category()
{
return $this->belongsTo(Category::class);
}
public function supplier()
{
return $this->belongsTo(Supplier::class);
}
}
Here is how I create the table in migration
public function up(): void
{
Schema::create('products', function (Blueprint $table) {
$table->id();
$table->foreignId('category_id')->constrained('categories')->onDelete('restrict');
$table->foreignId('supplier_id')->constrained('suppliers')->onDelete('restrict');
$table->string('name');
$table->string('brand');
$table->string('model');
$table->string('description');
$table->string('image_url');
$table->decimal('price');
$table->timestamps();
});
DB::statement('ALTER TABLE products AUTO_INCREMENT = 100000;');
}
I don’t use blade.php because the file is uploaded by the admin and goes into storage. And in the html file there is a form that can be filled in, and it always gets 419.
I have tried using @csrf but the tag can only be used if using the .blade.php file, then I also tried to use native php in the same folder as the html file, but it still doesn’t work
I’m working on a Symfony project using Doctrine and I want to separate the database mapping from the domain model, following hexagonal architecture and DDD principles. I want my domain entities to be independent of data storage technologies like Doctrine.
What are the best practices for:
Separating Domain Entities from Doctrine Entities: What are recommended ways to map domain entities to Doctrine entities and keep business logic separate from data storage technology?
Implementing Repositories: How should I implement repositories in Symfony to adhere to DDD principles while using Doctrine for CRUD operations?
Here is the project structure I want to use:
Code examples or best practices would be very helpful.
Thanks!
I am using solr as my search engine
Saving data in this format
"id":1,
"status_id":1,
"availability":[
"{children=1, form_date=1726790400, adults=3}",
"{children=1, form_date=1726099200, adults=9}"
],
Trying to fetch details based in from_date > timestamp and adult >= 9
i am new to SOLR
query which i tried is
availability:[from_date:1726790400]
this gives error as
in solr data saved as
and the field type is text_general
I am still strugling in writing the docs using php attributes in symfony project. Symfony 7, php 8. I am looking for better tutorials with practical examples for various cases which happens in real development.
For example current problem I am strugling is that it shows documenation from parent PHP class and not from the extended one while I need to overwrite documenation for one property from parent class. Not going into details, it will probably be better to create separate question for that specific problem.
Tried
https://symfony.com/bundles/NelmioApiDocBundle/current/index.html
https://swagger.io/docs/specification/
https://github.com/zircote/swagger-php/tree/master/Examples
https://swagger.io/specification/
https://symfony.com/doc/current/controller.html#automatic-mapping-of-the-request
So this question is not about php itself. No need tutorials about php without OpenApi example. Need combination PHP8 + OpenApi, with attributes.
I recently installed Laravel 11, but I’m encountering some issues. I noticed that some files such as Kernel.php, Middleware.php, and api.php are missing. Thinking there was a problem with my initial installation, I reinstalled Laravel 11, but the same files are still missing. Can anyone help me understand what might be going wrong?
I previously worked with Laravel 10 and recently upgraded to Laravel 11. Just installed Laravel 11 twice and encountered the same issue.
I am making a feature that allows the user to telecahrge table data directly into excel. But I have a problem when saving the file. I write my file with php spreadsheet, then I try to save it, before downloading the created file.
But I can’t save it. Do you know why?
My button to dl:
<td style='border:1px solid grey; border-top:0; border-bottom:0; border-left:0; border-right:0;' align='center' colspan='1'>
<?php
$linkXlsx = './inc/fin/test/'.$_POST['soct'].date('Y-m-d').'.xlsx';
?>
<a href='<?php echo $linkXlsx; ?>' download>
<img src='./img/excel.png' height='30' alt='Télécharger' />
</a>
</td>
My function:
function download () {
$Ecritures = get_ListeEcrituresCegid ( $_POST['soct'] , $_POST['datd'] , $_POST['datf'] );
$NomFichier = $_POST['soct'].date('Y-m-d').'.xlsx';
$Classeur = new Spreadsheet();
$Classeur->getDefaultStyle()->getFont()->setName('Arial Nova');
$Classeur->getDefaultStyle()->getFont()->setSize(9);
$Feuille = $Classeur->getActiveSheet();
$Feuille->setCellValue('A1', 'EXERCICE' );
$Feuille->setCellValue('B1', 'JOURNAL' );
$Feuille->setCellValue('C1', 'PIECE' );
$Feuille->setCellValue('D1', 'COMPTE CLIENT' );
$Writer = new Xlsx($Classeur);
$Writer->save('./inc/fin/test/'.$NomFichier);
$cellColors = [
'A1' => 'd4e6f1', 'B1' => 'd4e6f1', 'C1' => 'd4e6f1',
'D1' => 'd4e6f1',
];
foreach ($cellColors as $cell => $color) {
$Feuille->getStyle($cell)->getFill()->setFillType(Fill::FILL_SOLID);
$Feuille->getStyle($cell)->getFill()->getStartColor()->setRGB($color);
}
$rowIndex = 2;
foreach ( $Ecritures as $e ) {
echo $Ecritures;
$Feuille->setCellValue('A'.$rowIndex, $e['E_EXERCICE']);
$Feuille->setCellValue('B'.$rowIndex, $e['E_JOURNAL']);
$Feuille->setCellValue('C'.$rowIndex, $e['E_DEBIT']);
$Feuille->setCellValue('D'.$rowIndex, $e['E_COMPTECLI']);
$rowIndex++;
}
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment; filename="' . $NomFichier . '"');
header('Cache-Control: max-age=0');
$Writer = new Xlsx($Classeur);
$Writer->save('./inc/fin/test/'.$NomFichier);
return $Writer;
}