Tag: mysql

Sorry, you are not allowed to access this page. – wordpress

i am getting this error message “Sorry, you are not allowed to access this page”. when i go to my page http://localhost/wordpressstuff/wp-admin/options-general.php?page=editstuff?id=4 that is when i get the error but when i remove ?id=4 it removes the error i am trying to do a edit mysql table row…

How to fetch mysql data in descending order?

mysql php

So my application gets mysql data in json format and displays it in id1 to id* I have to update my database table every day and I want to show the recent data first, I don’t want to change the …

Propel adds CROSS JOIN to query when using an alias to JOIN tables

mysql php propel propel2 sql

Trying to do a fairly simple query in Propel 2. I have a Person table and a Possession table – persons can have many possessions but only one of each possession type. So a person can have 1 book, 1 car, etc. I’m trying to write a query in Propel that will return all persons along with their car na…

“Cannot convert value to string” when retrieving data (belongsToMany relationship)

cakephp cakephp-3.3 cakephp-3.x mysql php

I’m using CakePHP 3.3.6 and MySQL 5.7.13. I have these three tables in my database (amongst others) : collections, tags and the join table collections_tags. collections Table tags Table collections_tags Table in my TableCollectionsTable.php: in my TableTagsTable.php: I can get all the Collections or all…

determine actions over period of time PHP MySQL

mysql mysql-variables php

I don’t have any code or database to display, because I am in the planning stage, and I can’t figure out the correct way to do this. I want to determine if a user has performed a specific action each day over the course of a week. If they have I want to perform an action. Each time there is

CodeIgniter : how to write where_in OR where_in query?

activerecord codeigniter mysql php where-in

I’m using codeigniter to query a database, and I need to conditionally compare arrays in the where clause. So basically I want to do: where_in OR where_in depending on what array has data in it. So I will have either an array of user_id OR an array of area_id’s. I’m not sure how to combine t…

Why css and bootstrap is not loading in Laravel 5.3?

laravel laravel-5.3 mysql php twitter-bootstrap

This is my route file… Route::group([‘middleware’ => [‘auth’]], function(){ Route::get(‘/profile/{username}’, ‘ProfileControllers@getProfile’); }); The “ProfileControllers” is this… namespace AppHttpControllers; use DB; use AppUser; us…

connect Symfony 3 application to an external SQL database in (asterisk server)

asterisk mysql php sql-server symfony

I am developing a VoIP administration platform based on asterisk and I am not be able to connect to my asterisk server from a web app developed with Symfony 3. I want to connect to my SQL database existing on asterisk server which is running on virtual machine from my web application and execute some queries …

CodeIgniter count too slow – pagination

codeigniter mysql pagination php

I’m trying to make a search using CodeIgniter faster. I use the pagination library and I have to count the records returned from the query on a table which contains more than 1.2 million records. The num_rows() function is very slow ( takes approximately 3 seconds ) Any solutions? Answer As the comments…

Decrease product quantity in database after order is placed with Laravel

cart laravel-4 mysql php

I have cart on the site and so far everything work perfectly. Now I’m trying to make quantity for each product which admin can add in backend ( already done ) and when customer order product(s) to …