I have a web page written in PHP (version 7.3.12), where an user can write any SQL statement and then execute it (I am using MariaDB version 10.4.10, included in XAMPP). When user writes DDL statements, most of them are unfortunately autocommited, hence there is no space for rollbacking a transaction. I don’t want them to e.g. create 200 tables
Tag: database
Is this a secure way of connecting to an SQL server?
Suppose I have a .php script on my server which interacts with a MySQL server. Part of it is: This script is solely server-side, and something like DevTools or view-source://web.address will not show the source code. However, it is really important that nobody is able to see this source code because it bears my username and password for one of
PHP MySQL Selecting Multiple Tables Based on Column/Row Value
I am just doing some testing with a few tables that I’m trying to relate together, based on the values of my ‘students’ table. Here are the total tables that I have: students TABLE id, name, course_num, msg_num biology TABLE id, details, msg_num chemistry TABLE id, details, msg_num physics TABLE id, details, msg_num So I’m trying to select the ‘students’
PHP login and registration – data not inserting into database (PostgreSQL)
Just trying to make a simple app where you can register and then login, going to find out how to do the logout, welcome pages later. Literally just want to post data to database by having someone type in a username and a password. I am new and have been trying to figure this out for days now. I don’t
Upload txt file using PHP into database and then return Excel file
What I need to do is upload txt file into databe using PHP, do some calculations based on that table, and then return result in Excel file. This code works well, but I’m not getting all data from the .txt file, since it looks like it stops when it finds a comma. Here is the code: And here is the
How can I set an api token in php?
I am currently working on my website, so at the moment I have a website which I made with Bubble.io (no-code), and what I want to do is develop a CRM website with php , what I want to do is connect my database from my Bubble.io website to be able to use the data on my CRM website, Bubble.io
How to append connection dynamically in database.php file in laravel
I need to append dynamically connection in the database.php file using PHP code, is it possible or not? Answer It is working for me When I create a new customer then
cakephp 4.x query to get results from database
I came across a problem recently that I have to make a find(all) query in cakephp. Problem is I was unable to call model function to cakephp controller & add a command in function that would allow me to make a find(all) function in cakephp and retrieve all rows in a database that I was looking for. I would like
get post meta for all id [closed]
I want to get all brands from DB. It should work like get_post_meta( get_the_id(), ‘make’, true); but without id. It should contain an array with all brands. Which command I should use?
Optimizing mysql query for better performance to get low execution time
Currently I have this mysql query in my php code. I want to optimize it better because this query is currently inside a while loop and this query alone takes 25 seconds. so the bigger the loop the time it takes to execute this query over and over starts to become insane in only a short time. So I would