So I have a php page that looks like this enter image description here <?php echo "<table border=’1′ width= 300px > <tr> <th>Friend Names</th> <th>Remove Friends</th> </tr>"; while($row = mysqli_fetch_assoc($result2)) { $friend_id_got = $row[‘friend_id2’]; $query3 = "SELECT profile_name from friends where friend_id = ‘$friend_id_got’ "; $result3 = $conn->query($query3); $final3 = mysqli_fetch_assoc($result3); echo "<tr>"; echo "<td>" ..
Category : sql
I currently have an issue where when I attempt to insert data from a CSV file into a MySQL database using PHP I get an error that is caused by empty fields within the CSV file. In each row of data that has at least one empty field, it produces an error and doesn’t insert ..
How can i select enum data from one table with multiple rows, and use it as condition in view class, i’ve tried to use this in my model public function get_absen($id_user, $bulan, $tahun) { $this->db->select("DATE_FORMAT(tanggal, ‘%d-%m-%Y’) AS tanggal, waktu AS jam_masuk, (SELECT waktu FROM attendance al WHERE al.tanggal = tanggal AND al.user_id = user_id OR ..
i’m a new web developper and I’m learning Php. For my certificate I need to do a PHP blog using OOP MVC architecture. So I try with someone’s MVC framework and I can’t join the Articles and Comments table, Either all the comments appear under all the articles, or none appear. and article_id stays at ..
1.Create a public static method called all. This method’s purpose is to retrieve all categories from the database and create category objects with all their properties populated. Within the all method, create a new variable called $sql. This will contain an SQL statement to retrieve all categories from the ‘categories’ table. Recall, the syntax for ..
I have stored values in mysql table with datatype string as following format 10-15-2020 but when I tried to change datatype date I got the following error incorrect datetime value:10-15-2020 How i can fix this issue using sql query in phpmyadmin Sourc..
Take this working code. It firstly searches the users table for a keyword and then it will use the whereHas() method to search the pivot table category_user for any users assigned to a given category based on a search. This works nicely, all entries are retrieved. I am using Laravel collections sortByDesc() to order the ..
I have this field <input class="red-heart-checkbox " name="photo[]" type="checkbox" value="<?php echo $id; ?>" id="<?php echo $id; ?>" data-img="<?php echo $imageURL; ?>"/> And I would like to make a list of image with url image from the data-img checked but I only have values with this code : <script> $(function() { var masterCheck = $("#masterCheck"); var ..
I have 2 tables: subscribers-> id, updated_at payments-> id, subscriber_id, updated_at $query->leftJoin( $this->paymentsTable, "$this->paymentsTable.subscriber_id", "=", "$this->subscribersTable.id" ); I want to select new column "last_update", which are MAX(updated_at) from 2 joined tables eg. subscriber 1, 2021-01-01 subscriber 2, 2020-02-02 payment 1, 1, 2020-03-03 payment 2, 2, 2021-02-02 payment 3, 1, 2022-02-02 last_update for subscriber1 = 2022-02-02 ..
Como debería realizar la siguiente consulta en SQL php myAdmin debo obtener los datos de 2 tablas: A y B, en la tabla A tengo registros con su id, y en la tabla B tengo registros con la clave foranea que hacen referencia a los registros de la tabal A, y pueden ser muchos registros ..
Web Development Company
Free Hosting company
