PHP MySQL Check if row exists

debugcn Published at Dev

dinkode.dk

Im building a login for our employees and now I'm creating the validation for each input fields. If I have a table named pages and inside that table I've got a column field named title. As an example I've created a dummy title My new title.

I've created a function that let's our users create new pages, and I want to be able to check if the title already exists in our database.

For example, if the user types in My new title and submits the form, then he gets an error message with the following text: Sorry, your title already exists

I know I haven't provided much information here, but I'm from scratch on this one. I know how to check if a number is the same, or if two input field/db rows doesn't match each other. It may be an easy one, but I really can't figure it out.

I would be very grateful if you had a simple solution to this. Continue a wonderful day :)

Nishant Kumar

You can achieve this by these way:

Add unique constrain to column title
Using INSERT ... ON DUPLICATE KEY UPDATE statement
Do a query before insert on that column value if it return more than 0 result than it exist. like : SELECT * FROM pages WHERE title = 'new_title';

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-06-24

Comments

0 comments

From Dev

Related Related

Article

PHP MySQL Check if row exists

PHP MySQL Check if row exists

check if specific row exists mysql

MySQL check if row with category exists

PHP check if value exists in MySQL

PHP - Check if row exists before inserting

PHP MySql - Confirm row value exists

How to check if value exists in MySQL Database in PHP?

PHP MySQL Query to check if record exists or not

php check if mysql select exists or empty

php check if mysql select exists or empty

check username and email already exists in php mysql

How to check if a row exists in MySQL? (i.e. check if an email exists in MySQL)

Check if row exists in DataTable?

Check if row exists, Laravel

Check if row exists in database

Check if row exists in an xml

Check if row exists in database

Check row if value exists

if statement to check if mysql row exists, then selecting next query

php check if row in database exists returns always true

Check for empty row from mysql in PHP

PHP MYSQL check if row data is the same as

If exists, duplicate row in MySQL

Check if a column exists in mysql

IF row exists THEN delete row in mysql

php check if input value exists in mysql (related with performance)

PHP How to check if a string already exists in a MySQL table

check if username exists in real-time through AJAX in php with mysql

Check if session exists in php

PHP check if value exists