I need to get catalogs from database using Laravel query, so I write simply: $catalogs = Catalog::where('shop_id', $shop->id)->latest()->get(['id','title', 'created_at', 'shop_id', 'cover_bg', 'frontpage', 'pdf', 'clicks', 'finished']); In a catalog table I have more than 100 columns - 2 of them are…
I want to run a php project with database on my server for learning purpose. After setting up xampp I pasted the project file[filename: HRMS-FRESH] in htdocs/ folder, Afterwards I made a database( same name as the sql file name…
and forgive me in advance as I somewhat a newbie. Am going to do my best to explain the situation in a way it could be generally understood. Long story short, as the title suggests. I have a website with…
I was working on a project with my client. I mostly do frontend work so I don't really understand what is wrong here. We got a white label license of a prebuilt app that we worked over and redesigned completely…
My SQL query is not working. Below is my code and note that in that table query worked fine and gives output. But in PHP by using mysqli_num_rows(), mysqli_fetch_assoc() and mysqli_fetch_array() all doesn't works for me. My DB connection is…
Well, I have multiple databases in django project. One is default and second istest_dev. i have created docker container. and then everything went well till building the container. after that When I try to call my django app api which…
I have two dimensions of data, one is the purchase itself and the second is the referral reference. Orders are produced with PDO and taken from a MySQL database: <div rfrnc="joe" id="1" class="order"><div>1 Laptop $220</div><div class="time">10.25</div></div> <div rfrnc="bill" id="2" class="order"><div>1…
My database won't start after restarting the server. it throws the following error; [ERROR] InnoDB: Page [page id: space=1106, page number=4119] log sequence number 29970252505 is in the future! Current system log sequence number 29967893604. [ERROR] InnoDB: Your database may…
I want to insert given values from my docker app-service to the MariaDB-service. The connection has been established because I can execute SELECT * FROM via the MariaDB.connection.cursor. First of all I create the connection: def get_conn() -> mariadb.connection: try:…
Below is my docker-compose file and my application.yml file. I am overriding the mysql jdbc url in the docker-compose file. Why i run via the command line I am able to connect to the database running on docker instance. mysql…