Advertisements i have a php tag that is for some reason not working, when i first wrote the code it worked but after a while of me doing different things with the code it suddenly stopped working. underneath here is my code <?php // Include the database configuration file require_once ‘config.php’; // Get image data… Read More My PHP tag is not working, the code editor is not registering it
Advertisements I’m having trouble splitting the results from a SQL query into dates. I have something like that: i have something like that And I want something like that: i want this // I use bootstrap… $result = $conn->query($sql); if ($result->num_rows > 0) { echo ‘<div class="list-group">’; while($row = $result->fetch_assoc()) { $newDate = date("d.m.Y", strtotime($row["dataczas"]));… Read More Group SQL results by date
Advertisements A simple MySQL query is returning a syntax error over mysqli_connect, but the identical, copy-pasted query is successful in both the CLI and phpMyAdmin. Consider this example for MySQL 8.0: // Create connection $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $sql = "USE… Read More Inconsistency of MySQL syntax errors depending on whether query made from command line or mysqli_connect
Advertisements I think the problem is in my loop. But I’m also checking my database. <table class="table"> <thead> <tr> <th scope="col">ID</th> <th scope="col">First Name</th> <th scope="col">Last Name</th> <th scope="col">Username</th> <th scope="col">Password</th> <th scope="col">Actions</th> </tr> </thead> <tbody> <?php $sql = "SELECT * from dbtest.tbluser"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of… Read More Why is my table only showing the last row entered?
Advertisements <a href="https://123.com/’.$_SESSION["usersId"].’ " target="_blank"><img src="./images/w.jpg"></a> Hello, I’m new to coding and I was wondering how can I make a custom link with an user ID directly taken from my database. The name usersId is a column in a mySQL table and I take that usersId from a session. Can you please help me fix… Read More How to modify a link with an user ID
Advertisements So let’s say we have a table called phone. and i need another column to show the average cost of a brand phone I know i can do something like this: SELECT brand, AVG (cost) FROM Phone GROUP BY brand; and get something like this table: Can someone help me how i would get… Read More How to compute average Cost in SQL based on category?
Advertisements So sorry for my poor english first, I’m not a native, and stackoverflow says "Failed to upload image; an error occurred on the server" so I will use a hpyerlink below, hope I can describe it right, here is my problem: I want to replace a button, instead of ahref link, but I have… Read More PHP button link value not showing
Advertisements I try to display the data of two tables at the same time but that did not work for me. <?php require_once ‘cont.php’; $resultAll = mysqli_query($con, "SELECT * FROM topic UNION SELECT * FROM Image "); if ($resultAll) { while($row[] = $resultAll->fetch_assoc()) { $item = $row; $json = json_encode($item, JSON_NUMERIC_CHECK); } } else {… Read More result: "No Data Found"
Advertisements Trying to make a multidimensional array using PHP and a database on SQL and to have each value easy to call using HTML. I dont need to draw the whole table but just getting some data from a specific cells based on row/id. If i want to call row 1 and on that row… Read More PHP Multidimensional Array list a SQL database for easy handling in php
Advertisements i have 2 tables in my database one called topics and the other called sections every topics has multiple sections and they linked to main topic by id for example this is my datable topics id title content sections id title topic_id i use this code to show content <?php $show_topics = $topics->select_topics($page); while… Read More how can i show multiple data in one string in php and mysql