i want to search and filter the data in my table but i dont know how to do it im currently studying php. this is my php script to search data <?php require('./conn.php'); if (isset($_POST['search'])) { $valueToSearch = $_POST['query']; //…
I am new in laravel and working on E-Commerce Project. Plz Help me! I am trying to get data from the database but I can't. My function public function add_product_attributes($id) { $attributes = Product::where(['id' => $id])->with('attributes')->first(); $attributes_data = $attributes->toArray(); dd($attributes_data);…
I have limited access to the MySQL database, I just can see a view called customer contains customer_id, name, and their location id_customer name location 1 Andy Detro.it 2 Ben CALiforNIA 3 Mark uk 4 Niels London123 5 Pierre Paris…
I have a table in my database that stores a student's progress in a course. Schema::create('course_student', function (Blueprint $table) { $table->primary(['course_id', 'user_id']); $table->char('user_id'); $table->char('course_id'); $table->timestamp('lesson_timestamp')->nullable(); $table->text('course_progress')->nullable(); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade'); $table->foreign('course_id')->references('id')->on('courses')->onDelete('cascade'); $table->timestamps(); }); Course progress is stored as a JSON object and consists…
ConnectionRefusedError [SequelizeConnectionRefusedError]: connect ECONNREFUSED 127.0.0.1:5432 at Client._connectionCallback (/home/gene/capital_greek_project/api/node_modules/sequelize/lib/dialects/postgres/connection-manager.js:131:24) at Client._handleErrorWhileConnecting (/home/gene/capital_greek_project/api/node_modules/pg/lib/client.js:305:19) at Client._handleErrorEvent (/home/gene/capital_greek_project/api/node_modules/pg/lib/client.js:315:19) at Connection.emit (node:events:527:28) at Socket.reportStreamError (/home/gene/capital_greek_project/api/node_modules/pg/lib/connection.js:52:12) at Socket.emit (node:events:527:28) at emitErrorNT (node:internal/streams/destroy:157:8) at emitErrorCloseNT (node:internal/streams/destroy:122:3) at processTicksAndRejections (node:internal/process/task_queues:83:21) { parent: Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect…
I come from MySQL to PostgreSQL then, I created test table with BOOLEAN state column in PostgreSQL as shown below: CREATE TABLE test ( state BOOLEAN -- Here ); But, I couldn't insert TRUE with 1 and FALSE with 0…
I have the following SQL table called 'content': language contentId text en 1 Hello de 1 Hallo en 2 World My goal is to query all rows which match language='de'. But if a row with language='en' exists which has no…
Before anything, thanks you, english isn't my native language and i'm sorry for any mitsake i would make. If my question is stupid, i'm sorry too. I'm making an application, that allow to export some tables in different format csv:…
QuerySnapshot querySnapshot = await FirebaseFirestore.instance .collection('stations') .where('norequest', isGreaterThan: 9) .get(); Here i want get if 'norequest' is a whole number like 10 , 20 , 30 , 40 something like this and greater than 5 ? How can i get…
HeuteDb heute = new HeuteDb(); string filePath = @"C:UsersEliasDesktopASPlearningDATAData.csv"; using (StreamReader reader = new StreamReader(filePath)) { string line; while ((line = reader.ReadLine()) != null) { List<string> items = line.Split(';').ToList(); heute.Uhrzeit = items[0]; heute.Energie = items[1]; _context.HeutesDb.Add(heute); _context.SaveChanges(); } } I…