Posted By: Anonymous I have done searching for encrypted and non-encrypted columns but for ordering non-encrypted fields are ordering successfully but encrypted fields are not sorting. Encrypted columns: firstname, lastname, email Encrypt Function // Encrypt Data function encrypted_data($decrypted){ if($decrypted != NULL){ $method = ‘aes-256-cbc’; // Must be exact 32 chars (256 bit) $salt = ‘XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX’; …
Posted By: Anonymous I am deploying an API made using Go and MySQl for the database to Heroku. I am following this guide on it and set up everything but now I am trying to execute a MySQL script to set up the tables with some dummy data. But I am constantly getting errors saying …
Posted By: Anonymous I have 2 tables tbl_Participants id group_name firstname lastname tbl_Groups id group_name But I have difficulties joining the tables to show the below layout. Group Name | Member 1 | Member 2 | Member 3 First and last names will be showed under member col Max of 3 participants per group This …
Posted By: Anonymous The following method works perfectly, it correctly generates the following HTML structure, you can see it in the following link: https://jsfiddle.net/L6wo42ar/ $id_course = 1; $stmt = $con->prepare("SELECT id_chapter, chapter FROM tbl_chapters WHERE id_course=? "); $stmt->bind_param("i", $id_course); $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows>0) { $stmt->bind_result($id_chapter, $chapter); while ($stmt->fetch()) { $stmtA = $con->prepare("SELECT preview, title_video, description_video, …
Posted By: Anonymous I am beginner for Django and i am working on my final year project but i am stuck at one thing. here is my model.py class MatchList(models.Model): user = models.OneToOneField(settings.AUTH_USER_MODEL, on_delete=models.CASCADE, related_name="user") matches = models.ManyToManyField(settings.AUTH_USER_MODEL, blank=True, related_name="matches") class Meta: app_label = "matchsystem" Also my here is my migration file as well. class …
Posted By: Anonymous How to display sum of number by this week I have SQL base table name oam nas Mor Cas Tat Data 8 9 0 1 2021-05-26 7 8 9 0 2021-05-27 6 7 8 9 2021-05-28 5 6 7 8 2021-05-29 4 5 6 7 2021-05-30 3 4 5 6 2021-05-31 2 …
Posted By: Anonymous I need to save company infos somewhere and I decided to make a table called entreprise_info that have only 1 company. I want to know what is the best practice in this situation. The table that I created: class CreateEnterpriseInfosTable extends Migration { /** * Run the migrations. * * @return void …
Posted By: Anonymous The MySqlCommand is resulting in an error "id can’t be null" MySqlCommand cmd = new MySqlCommand($"insert into dataBase.testingTable (id, value1, value2, value3) values (null,’test’,’2021-1-1′, 9)", connection); connection.Open(); cmd.ExecuteReader(); connection.Close(); The below statements also yielded Id related errors: insert into dataBase.testingTable (value1, value2, value3) values (‘test’,’2021-1-1′, 9) //id column is missing insert into …
Posted By: Anonymous I am fetching data from an external API and I want to insert or update those data to two tables with many to many relationship using Laravel and MySQL. Table Structure Orders Table |id (Auto Increment /Not related to API) | order_id (from API) | some other columns | Products Table |id …
Posted By: Anonymous I have a table with 3 columns: user_id, start_date, cancellation_date I would like to get 4 columns of: Date, Number of Active Users, Number of Users Who Canceled, Cancellation Rate Any ideas on how to write a query of this? Thanks in advance! Solution Here’s a way to measure new users, cancelled …
Posted By: Anonymous I’m building a project with Laravel 8. I need to merge multiple objects but with conditions. Here is my final object. { "status": "success", "code": 200, "data": { "invoices": [ { "invoice_id": 6366, "issue_date": "2020-07-22", "invoice_status": "Fully Paid", "installment_count": 4, "services_total_price": 0, "services": [ { "invoice_service_name": "Bathroom Pack", "invoice_service_price": 0 } ], …
Posted By: Anonymous how can I get $sum 0 values instead of negative values? I’ve seen that people use < then .. else 0 but when I try, it display the wrong value 🙁 stock_movement_details.db:- stock_movement.db raw_material.db As you can see, I have type (subtract/add). Let say, ID 10 for raw_material_id, quantity is 10.00, ID …
Posted By: Anonymous firstly I want to apologize to Stack overflow, I Know that, I should not ask this question on Stack I have MySQL data like this test.com dstnat: in:ether1 out:(unknown 0), src-mac 5c:5e:ab:7b:21:a3, proto TCP (SYN), 121.131.311.11->22.22.222.22, len 52 test.com dstnat: in:ether1 out:(unknown 0), src-mac 5c:5e:ab:7b:21:a3, proto TCP (SYN), 11.11.111.11->22.22.222.22, len 52 i …
Posted By: Anonymous I have the web.php file <?php use IlluminateSupportFacadesRoute; use IlluminateHttpRequest; Route::get(‘/’, function () { return view(‘welcome’); }); Route::post(‘/upload’, function (Request $request) { $name=$request->file("thing")->getClientOriginalName(); Storage::disk("google")->putFileAs("",$request->file("thing"),$name); })->name("upload"); ?> and HTML code like <!DOCTYPE html> <html lang="{{ str_replace(‘_’, ‘-‘, app()->getLocale()) }}"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Google drive integration in laravel</title> <!– CSS …
Posted By: Anonymous Below is my query, query is very slow and I tried to set some index but indexes are not working. Table has almost 150000 rows. Please help me out. SELECT COUNT(*) AS COUNT FROM attachment LEFT JOIN candidate ON attachment.data_item_id = candidate.candidate_id AND attachment.data_item_type = 100 AND attachment.site_id = candidate.site_id LEFT JOIN …
Posted By: Anonymous I try to create db for application chat . I am having trouble getting the latest information from customers in chat responses such as One customer is talking to me. Then the second client wanted to talk to me. I want my customer ID on top so I can verify who has …
Posted By: Anonymous table1 has 3 columns in my database: id, timestamp, cluster and it has about 1M rows. I want to query the newest 24 rows with unique cluster value (no row must have repeated cluster value in the returned 24 rows). the usual solution would be: SELECT * FROM table1 GROUP BY cluster …
Posted By: Anonymous i need help with mysql avg query! Table f ticker | avgvol | mc Table l ticker | vo2 following select query gives me a list with 20 values SELECT f.avgvol / l.vo2 ds from f join l on f.ticker = l.ticker order by mc desc LIMIT 20 now i want to …
Posted By: Anonymous Hello Guys I am learning new things from a book and today as I wanted to test the code that I wrote. I received that error: MySql.Data.MySqlClient.MySqlException: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near …
Posted By: Anonymous For example, I lock some rows: select * from t1 where c2 = 1 for update; c2 is not indexed. It means MySQL has to search entire table and if it read uncommitted or read committed isolation levels it places locks on every scanned row and if it doesn’t satisfy the WHERE …
Posted By: Anonymous Is it possible to use an array of some sort in the below type of mysql query using PHP? $query = "INSERT INTO $table_name ($table_columns) VALUES($my_array)"; The situation: I’m creating a library/package that will allow users to upload csv file data into a mysql database table in laravel. The library/package will allow …
Posted By: Anonymous I have 2 tables Person (Person_id, name) and Address(Address_id, Person_idAd, addressName) with relation of one-to-many. With the following query I get String query = "SELECT Person_id, addressName from Person, Address where Person_id = Person_idAd" PreparedStatement pstmt = (PreparedStatement) con.prepareStatement(query); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { } Person_id addressName 1001 Address-1 1001 …
Posted By: Anonymous How should you setup a Spring entity that uses an Enum? I have set up a spring-boot project and provided the code below so hopefully, someone can tell me the correct way this should be done. I have a Spring entity setup @Entity public class Resource { @Id private String id; private …
Posted By: Anonymous I am new to Perl and I’m having trouble understanding this code. What does the if condition check here? my $ret = 0; my @r = (); if(@r = $sth->fetchrow_array()){ $ret = $r[0]; } Solution The condition is a list assignment. if enforces boolean, i.e. scalar context; arrays in scalar context return …
Posted By: Anonymous I have only two columns, one with user ID and another with the times he logged in. What I need is to compare wether each user did login in the last month and again in the current month. UserId LoginDatetime 207 1/25/2021 21:04 207 2/8/2021 14:59 207 2/8/2021 14:59 207 2/16/2021 19:54 …
Posted By: Anonymous I’m selecting values from 3 different tables to get an overview of some product orders. Without MAX, no issues. Here’s the data I’m working with: — limited to first rows for the sake of the exemple +——+———————+——————————-+——-+ | ID | post_date | order_item_name | price | +——+———————+——————————-+——-+ | 2348 | 2019-01-23 18:47:34 …
Posted By: Anonymous Result Right Now , want to ignore dulicate id_category name id_manufacturer name 6 CLOTH of House 12 Sabb 6 CLOTH of House 12 Sabb 6 CLOTH of House 14 CTES 8 Sabih Nopoe 12 Sabb I want this Result remove duplicate and heading changes id_category Man-name id_manufacturer Cat-name 6 CLOTH of House …
Posted By: user10604874 So, I have a form, in which the user will select inputs. Firstly, I want to create a text input and in this when the user writes for example A, it will suggest every data from the MYSQL database that starts with A etc. The page of the form is /air_tickets and …
Posted By: Anonymous I have members on my team who are tossing around the idea to make every column in the database a string including numeric columns. I know that sorting becomes an issue. What are the other downsides of making a numeric column a string? Solution The major issue is that users can put …
Posted By: Anonymous I created two classes: a class called index.php for a user to input data such as: name, email, phone number and address. And the other class called model.php, which must send the information that the user typed into the MySQL database. However, when a user enters the information in the graphical interface, …
