My problem per my instructions You will need to add an additional field to the members table to specify who is an administrator. This will be manually populated by the database administrator (you) In the login.php file, you already assigned…
can someone help me to convert this query for Mysqli? /* Load website settings */ $config = array(); $configs = $db->QueryFetchArrayAll("SELECT config_name,config_value FROM `site_config`"); foreach ($configs as $con) { $config[$con['config_name']] = $con['config_value']; } unset($configs); This code is placed in the…
Actually I try to get users data and fetch to Auth database table data from the database. This whole thing happened RDBMS. In this case I got some errors. When I write this code I got some errors but I…
Here is my array for JSON I am trying to creating a JSON array with this code and then inserting the data in my sql but it is not working with inverted comma like "The text is with inverted comma's"…
I try to upload a file from html-form in my mariadb database booksummerytable. I get an db entry in the table, in columns student_id and a book_id, but the file-entry just do not want pass in the LONGBLOB column for…
I'm working on a project that uses a sort of roomCode host/join system to function. It's written in js/html/css with a php server. I've had success so far with using PHP and MySQL on this project to insert stuff into…
I have a form which lists a number of stars (stellar objects) upon there is a <select> control and two <inputs> I am needing advice on populating the two inputs from the DB upon the change of the <select> I…
Since upgrading from php 5 to 8, I've started getting a lot of "Warning: Trying to access array offset on value of type null" when using mysqli_fetch_array to run queries which may or may not return any results (it's fine…
I have a table of two columns id and parent_id |-id-|-parent_id-| | 1 | 0 | | 2 | 1 | | 3 | 16 | | 4 | 19 | | 5 | 19 | | 6 | 2…
What is the difference between using execute_query()[1] or using the prepare() then execute() [2] and when do we use the bind parameter and why? Like in example [2] we already gave the variables within the execute so when is the…