I have created a CMS. When installing the CMS, I must install its database. I use PHP multi_query() to istall the database without opening phpMyAdmin. When the SQL file is as small as 624KB, the database is installed successfully. However,…
I want to update a table value to either 1 of 2 values. The selected value has 2 possible choices I ride a bike or I fly an airplane. If the entered value is I ride a bike then the…
Im working on a school project and i want to pass more then one value thru the url. The page show more then one user from the Database. This is what im trying to do so far, and i get…
I have this code: if(isset($_POST['submit'])) { $name = $_POST['name']; $query = mysqli_query($conn, "select name from accounts where name = '{$name}'"); if($query) { echo "success"; } else { echo "error"; } } ?> <form action="" method="post"> Name: <input type="text" name="name"><br><br> <input…
I work on making a common function in PHP to update table because I have a lot of forms update MySQL tables. It is working fine and it update my table: below is my code with some comments: <?php include('../config.php');…
I have a MySQL table with floats in it. In PHPMyAdmin, they're listed as e.g. "55.123" I used to pull them out using $sql = "SELECT latitude,longitude FROM table WHERE id=" . $id; $conn->query($sql); When I print my floats, I…
here i need update more than 100s of data at time. this query works for me but its too slow at least it take 15 to 20 seconds to execute. i have tried few things but failed any help appreciated.…
<?php $host_name = '***'; $database = '***'; $user_name = '***'; $password = '***'; $link = mysqli_connect($host_name, $user_name, $password, $database); $con = $_POST['User_ID']; echo "Se ha ascendido al usuario $con"; $meta= 'a:1:{s:13:"administrator";b:1;}'; $consulta = 'UPDATE ***usermeta SET meta_value = $meta WHERE…
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…
I'm trying to remove content with jQuery/ajax which is dynamically added with a simple PHP loop, but it does not work. I'm using dynamically created <select> option to select the item and remove it by pressing the button. This is…