We're running a custom ad server solution and, in some cases, we store and increment/decrement counts and aggregated values in MySQL, for optimization. I understand keeping counts in MySQL is not ideal, although I'm not 100% sure why. My guess…
This function, seems pretty standard, I am not really getting an active button that uploads to the list in my database? if(isset($_POST['submit'])){ //THis is how you upload a picture to a website $file = $_FILES['file']; print_r($file); $fileName = $_FILES['file']['name']; $fileTmpName…
System Info: OS: Ubuntu 19.10 Laravel Version: 7.0 PHP Version: 7.3.11-0ubuntu0.19.10.4 MySQL Version: mysql Ver 8.0.19-0ubuntu0.19.10.3 for Linux on x86_64 ((Ubuntu)) I am building a small Laravel application and am having an issue with MySQL and relationships. When I try…
I need help I have added filters to my code, they all are working fine but only month & year filter is creating confliction, although when I print the SQL in PHPMyAdmin I'm getting the desired results but not in…
I have an array of category , and this categories have many books (belongToMany) how i can get all book sorry about my English category model class category_b extends Model { protected $table = 'categoryb'; protected $attributes = array( 'lang'=>…
Looking for advice on whether I can improve my database statements or if I should start caching query results to increase performance. The schema is set up as a Many-To-Many Polymorphic relationship. I have a Videos table that contains video…
We are working on a small follow up email script and now need to determine if an email appears more than once in the query results. If the email appears only once then use email content A, if it appears…
I creeate an app on android ,database registers user correctly but no email is send out and app displays my error message "cant register user at the moment" don't know what i am doing wrong This is part of the…
Essentially, I'm trying to repair a broken WooCommerce database for a client. I have a table wp_woocommerce_order_itemmeta and all of the _product_id values are erased. I am able to get the correct ID using this select statement. It will return…
I think the problem is in the format. I have this code in the class: public DataTable CheckDate(DateTime day) { MySqlCommand command = new MySqlCommand("SELECT * FROM `appuntamenti` WHERE `date`='@date'", conn.getConnection()); command.Parameters.Add("@date", MySqlDbType.Date).Value = date; MySqlDataAdapter adapter = new MySqlDataAdapter();…