Search code examples
phpmysqlinsertvisible

Insert into mysql but choose when to show ...?

What I want to do is next:

person makes a new post, let say it is a post for latest news. After form is populated, he/or she have a radio button or check-box to choose to display the latest news right away, or to wait for approval. I tried making a column 'visible' with the type of tinyint ... but no luck, because post is shown no matter if the tinyint value is '0', or '1'. Am i doing this wrong? '0' = false, '1' = true, right?

Example:

$headline = $_POST['headline'];
$news = $_POST['news_text'];
$visible = $_POST['visible'];

$query = "INSERT INTO news ( headline, news_text, visible) VALUES ($headline,      $news_text, $visible");

<input type="radio" name="visible" value="0> No
<input type="radio" name="visible" value="1> Yes

Seem's a bit dull ... Help is appreciated ...

Solution

  • Make sure your visible field is an INT field type (or TINYINT), and only make sure you use 0 or 1 for the value of that field.

    So your table should look like this:

    +----------+-----------+---------+
| headline | text      | visible |
+----------+-----------+---------+
| Test 1   | Text One  | 0       |
| Test 2   | Text Two  | 1       |
+----------+-----------+---------+

    Then, when you go to display the articles (only if visibility is 1):

    SELECT headline, text 
FROM tableName 
WHERE visible = 1