Category : mysqli

At first I was able to save values into the table called "tbl_spareparts" but when i added a foreign key it doesnt save anymore. tbl_spareparts(unit_id) is referenced to tbl_unitdescription(id). code is for dynamic fields where you can add more input boxes or remove them. here is my insert code: <?php $connect = mysqli_connect("localhost", "root", "", ..

Read more

I’m trying to update user details and to leave the password blank if the user doesn’t want to update the password. The details get updated in the database but instead of the alert-success Profile Edited message, the warning error still pops up in that div. Solutions here on stackoverflow indicated that mysqli_fetch_array()‘s parameter must be ..

Read more

Question in title. The query for creating and using database is as follows //create connection $servername = "localhost"; $username = "root"; $password = ""; $conn = mysqli_connect($servername, $username, $password); //create Database $createDB = "CREATE DATABASE DBBarang"; //use Database $useDB = "USE DBBarang"; Then I use a function to select data //function for select from Master ..

Read more