I used to get today's record from MySQL database. I used this code: $whr_follow = "(DATE(R.reg_time) = Date(NOW()) )" ; $this->db->where($whr_follow); Today is march 1st, but I get yesterdays. In local server it works fine. I tried select now() query…
I am building software where a Choir Leader can run multiple Choirs. I am trying to return all members associated with a specific Choir Group. So when the Choir leader selects a specific Choir Location, they see all members asssociated…
The image name is getting saved in the database but the image is not getting saved in the file manager, is there any permission problem in the file manager of cpanel or coding issue? Controller function addprofilepicture() { $userID =…
I am Involve a CodeIgniter Project.In this project another developer insert cat_id in the database include # separated like #1#. when insert two cat_id the value store in database like #1##2#. Now I want to retrieve the cat_id and join…
I am rewriting sub-folders of my website to sub-domain via bellow code in Apache vhost file: RewriteEngine On RewriteCond %{HTTP_HOST} !^www. example.com RewriteCond %{HTTP_HOST} ^(www.)?(([^.]+).){1}example.com$ RewriteCond /var/www/example.com/web/crm/build/%3 -d RewriteRule ^/(.*) /crm/build/%3/$1 so https://example.com/web/crm/folder = https://folder.example.com Also i am using .htaccess…
I have a codeigniter project. Recently I deployed it with SSL. And I forced my site to use Https from http by modifying in .htaccess and changed baseurl too. The problem is I have a registration and login form .…
Nested query in Sql. SELECT *, (SELECT `supplier_sign_up_id`, ( SELECT email_address FROM supplier_sign_up WHERE supplier_sign_up_id = 42 LIMIT 1 ) FROM `suppliers_acc` WHERE singup_login_id = 138 LIMIT 1 ) FROM `singup_login` WHERE 1; It's give error- Operand should contain 1…
Error Number: 1452 Cannot add or update a child row: a foreign key constraint fails (smp.student, CONSTRAINT FK_ParentStudent FOREIGN KEY (p_id) REFERENCES parent (p_id) ON DELETE CASCADE ON UPDATE CASCADE) INSERT INTO student (s_id, student_code, f_name, l_name, dob, gender, address,…
I have to work in multiple subdomains. Suddenly I can't access my all subdomains. Because when the page redirects session data was lost. This issue happens my all subdomains But I didn't change anything from my server. Anyone, please help…
I want to save only year in my database as date_created with type currenttimestamp I'm getting the value of the year from a select html. After getting the value, i will transfer it to the controller Here's my code $registered_year…