| Welcome, Guest |
You have to register before you can post on our site.
|
|
|
| Strange problem when connecting to external host using PDO |
|
Posted by: Danielcik - 11-14-2019, 09:27 AM - Forum: CodeIgniter 3.x
- No Replies
|
 |
Hi!
I have a big problem with my website. When I try to connect it to an external host, it gives me a strange error:
PHP Code: Severity: error --> Exception: Call to a member function errorInfo() on bool /home/qtbflcqc/panel.unitchamp.ro/system/database/drivers/pdo/pdo_driver.php 295
Unable to connect to the database
When I try to connect to the database from my localhost, it works fine, without any problem.
So, when I try to place the website on my PC, and connect it to the external host, it works perfect , no problem, no errors, but when I try to connect to it from the website (which is hosted), it gives me that error.
I set the Remote Acces from the external host, so there should be no problems.
Here is my database.php
PHP Code: $active_group = 'default';
$query_builder = TRUE;
$db['default'] = array(
'dsn' => 'mysql:host=188.x.x.x; dbname=name; charset=utf8;',
'hostname' => '188.x.x.x',
'username' => 'nameuser',
'password' => 'pass',
'database' => 'name',
'dbdriver' => 'pdo',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => FALSE,
'cache_on' => FALSE,
'cachedir' => 'application/cache/',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE
);
Thans a lot!
|
|
|
|
| Help needed Multi city flight search logic |
|
Posted by: msjagan - 11-14-2019, 04:05 AM - Forum: Lounge
- Replies (4)
|
 |
I would like to create flight booking system in CI4. I know the search logic for single and return way, but I couldn't figure out the logic for Multi city flight search like multi city search in expedia.com.
Guys,
I really appreciate, if anybody could help me to achieve multi city logic in PHP.
|
|
|
|
| Automatic Database Migrations - Proposal |
|
Posted by: loopzzz - 11-14-2019, 02:04 AM - Forum: CodeIgniter 4 Discussion
- Replies (3)
|
|
Hello community,
i had a few projects in Python/DJANGO and have seen some really useful stuff but one especially helpful
Database migrations generated automatically from the Models
i love CI and want to have all the good stuff in here as well to speed up development times
Benefits:
- table field definitions are in a single place (single source of truth) in the Model
- migration files are temporary
- you can delete all dev incremental migrations and recreate a final migration
i understand that this is a braking change for the CI updates but that's why i ask your opinions on this.
Implementation:
we already have the $allowedFields property defining the field names
i propose new property called $fields or similar describing the fields like in the migrations currently, this also needs clarification.
What are your thoughts ?
|
|
|
|
| Need help about IP Addresses |
|
Posted by: SaraBailey - 11-14-2019, 01:07 AM - Forum: General Help
- Replies (2)
|
 |
Hi!
I want to know the real IP address of the client accessing my app. Why?
So I can compare it with my IP address.
I'm working on a web based desk top app and I do not want an employees logging in from anywhere other than physically in my office; unless an admin.
None of these below returns anything useful from behind LOCALHOST, it returns my own IP address as ::1
Will I get a better result on a public host? Is there a PHP.ini setting that I need to make?
Perhaps you have a better approach....
PHP Code: if(!empty($_SERVER['HTTP_CLIENT_IP'])){
//ip from share internet
$ip = $_SERVER['HTTP_CLIENT_IP'];
}
elseif(!empty($_SERVER['HTTP_X_FORWARDED_FOR'])){
//ip pass from proxy
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
}
else{
$ip = $_SERVER['REMOTE_ADDR'];
}
Thank for help
|
|
|
|
| CI4 RC3 - How to access css file in vendor directory |
|
Posted by: elyday - 11-13-2019, 03:14 PM - Forum: Model-View-Controller
- Replies (3)
|
|
Hello,
I started building views for my CI4 project today. This directly encounters my first problem:
I installed Bootstrap via Composer and wanted to access its css file in my view, which didn't work (which makes sense in itself).
Is it possible to access the vendor folder and its CSS files from the view or do I always have to copy the CSS files into public/ folders?
Best regards
elyday
|
|
|
|
| How to catch database operation errors |
|
Posted by: _Alain_ - 11-13-2019, 01:39 PM - Forum: Model-View-Controller
- Replies (7)
|
|
Hi
I try to catch an error if something with the database operations goes wrong.
I tried many variants of the following code but $data always returns true (it doesn't matter if the database operation produces an error or not).
What do I have to do to catch an error if database operation went wrong?
Model
PHP Code: <?php
class Users_model extends CI_Model {
public function deleteUser($userID)
{
$this->db->where('id', $userID);
$result = $this->db->delete('users');
return $result;
}
Controller
PHP Code: <?php
class Users extends CI_Controller {
function __construct()
{
parent::__construct();
$this->load->model('users_model');
}
public function deleteUser()
{
$userID = $this->input->post('user_id');
$data = $this->users_model->deleteUser($userID);
echo json_encode($data);
}
}
View (see the "<" for var user_id. This should generate an error because the user with such an id cannot be found)
PHP Code: // Delete user button
$('.btn-delete-user').on('click', function(){
var user_id = "<" + $(this).data("id");
$.ajax({
type : "POST",
url : "<?php echo site_url('users/deleteUser')?>",
dataType : "JSON",
data : {user_id:user_id},
success: function(data){
loadUsers();
},
error : function() {
alert("Some error happened");
}
});
return false;
});
Kind regards
Alain
|
|
|
|
| Seo url and multilanguage |
|
Posted by: togrul614 - 11-13-2019, 01:16 PM - Forum: Best Practices
- Replies (2)
|
|
Hello,
I have a problem with routing. I have a website in 3 languages, AZ, EN, RU. And I have dynamic pages created from admin. So I have 3 page domain/about, domain/en/about, domain/ru/about. Every slug is different depend on language. So I have another domain/jobs/etc , domain/en/jobs/etc/. and it continues like this.
How I can do this routing like WordPress?
|
|
|
|
| Move away content from public_html in a git repo on live server |
|
Posted by: muuucho - 11-13-2019, 08:39 AM - Forum: General Help
- Replies (5)
|
|
I get the security thing about moving content away from public_html/.
My workflow is that I push from my local machine to GitHub and to my live server.
Yes, I can change the structure on my live server (like moving certain content up one level), but I guess I must keep it on my local machine.
How do I push to my live server after having moved content up one level?
|
|
|
|
|
