Can’t get a list of streets to create a card [closed]

public function create() { $streets = street::get(); return view(‘dashboard.house.created’); } public function store(Request $request) { $this->validate($request, [ …

Add the results from a PHP array into a SQL Select for each Result to be procesed

I am a newbie so I want to know if what I am asking is possible. I have a SQl Select query that returns a While loop and I convert the results (peoples names)to a php Array. In a another SQL Query …

insert query mysql throws PDO::exec() expects exactly 1 parameter, 2 given

I’ve pieced together some code I’ve gleaned from the internet: I’m trying to scan a directory to insert file names and index into MariaDB table. My last hurdle it seems is this PDO error: PDO::exec() …

Top level EXISTS query using Doctrine ORM

I have a query such as this in plain SQL (of course the original is more complex, but still simple enough that I’m quite sure that that part is correct at least): SELECT EXISTS (SELECT 1 FROM mytable …

How to create JSON root object with php

My current output of my PHP script looks like this: [ { “id”: “1087”, “name”: “Abhishek Saini”, “email”: “info@gmail.com&…

how to upload image on flutter to MySQL

I am a newbie in a flutter. Can someone show me how to upload an image to my MySQL? I can’t find any solution in the past weeks. My Code: import ‘dart:io’; import ‘package:flutter/cupertino.dart’; …

I want to update the purchases table quantity value from order_item if the order is canceled in php

Please check the below code and please help me the correct syntax to used. $changeStatusSql = ” UPDATE purchases SET quantity = (select purchases.quantity+order_item.quantity as q …

i created a php form and connects in to mysql my all data is added in database only gender is not showing in the database

i have created a php form and connected it to mysql successfully, i created a table in mysql and added the data, all data is added except gender is not showing in database instead of gender 0 is …

Using ORDER BY and FIELD function to get single value to each custom list

I have a table named orders having 2 columns orderNumber & status as follow : orderNumber | status —————————- 10100 | Shipped | 10101 | Resolved | 10102 …

Why I can’t connect to a MySQL 5.3.36 shared server using mysqli_connect and PHP 7.4, but it will work using php 7.1?

I have this shared account on Hostgator. Using PHP 7.1 and mysqli_connect, I have no issue connecting to the MySQL 5.3.36 database. The PHP script should be fine. The hosting company sent me an email …