Скачать или смотреть How to Ensure Your PHP Script Only Displays Non-Empty Rows in a MySQL Database

Learn how to fix PHP code to avoid displaying empty rows from your MySQL database. Follow this step-by-step guide to create effective checks for non-empty input.
---
This video is based on the question https://stackoverflow.com/q/64713193/ asked by the user 'D A R K VerbalCentaurPL' ( https://stackoverflow.com/u/14589779/ ) and on the answer https://stackoverflow.com/a/64713526/ provided by the user 'Marwane Ezzaze' ( https://stackoverflow.com/u/10794716/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: When row is empty in PHP it should not display anything. When there is something in it, it should display input

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Ensure Your PHP Script Only Displays Non-Empty Rows in a MySQL Database

When developing web applications using PHP and MySQL, it's common to encounter scenarios where you need to display content based on the data retrieved from your database. A typical problem arises when empty rows in your database can lead to undesirable outcomes, such as displaying blank input fields on your web page. In this article, we’ll explore a solution to this problem: displaying images only when the corresponding database entry is non-empty.

Understanding the Issue

Consider a situation where you have a database table named colors with a column red that stores links to image files. You want your PHP script to create an input field with this image only if the link is not empty. However, your existing code might generate blank inputs when the row is empty or display irrelevant information when it should show nothing at all.

Breakdown of the Original Code

Here’s a look at the original code segment that you may be working with:

[[See Video to Reveal this Text or Code Snippet]]

Key Problems in the Original Code

Result Count: The use of mysqli_num_rows() returns a count of rows but not the data itself. As a result, checking if this count equals an empty string will not work.

Output Controls: The logic controlling what to display may not effectively filter out empty rows.

Resource Management: Closing the database connection is better done outside of conditional checks at the end.

The Solution

To successfully display the images only when they are available, we will revise the code. Below are the changes we'll implement:

Revised Code

[[See Video to Reveal this Text or Code Snippet]]

Explanation of Changes

Count of Rows: We introduced mysqli_num_rows($result) to check how many rows were returned instead of checking for empty strings.

Conditional Check: We added a check for the variable red to ensure it is set and not empty before echoing the input element.

Efficient Resource Handling: We placed mysqli_close($con); outside of the if-else statement to ensure it runs regardless of the conditional outcomes.

Conclusion

By making these adjustments, you can significantly enhance your PHP script’s efficiency in handling database rows. Properly filtering the data ensures no unwanted input fields are displayed when the red column is empty. This not only cleans up your user interface but also improves the overall user experience.

Feel free to implement this solution in your own projects, and watch how it streamlines your code management while working with MySQL databases in PHP.