How can I check if a user already exists with MySQL and PHP? What do I need to do first?

Asked by Last Modified  

1 Answer

Learn PHP

Follow 1
Answer

Please enter your answer

$qry = mysql_query("SELECT * FROM table_name WHERE id = 1 and name='test' ");if(mysql_num_rows($qry) > 0) { echo "Value already Present"} else { echo "Value not found"}
Comments

Related Questions

What is the best way to learn PHP without taking any coaching classes?
If you have prior knowledge on any server side programming definitely you can learn it on your own without attending classes. There are so many online tutorials to learn . Wish you all the best.
Profile Photo
Kavidassan
0 0
View Comments6
Please Tell Me About PHP ?
PHP (recursive acronym for PHP: Hypertext Preprocessor) is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML. It allows...
Profile Photo
Indal
What is the fee for php classess?
Basic + Advanced + WD + MVC, full php developer profile Rs. 12000/- 4 month with practice.
Profile Photo
Manjunath
How can we complete PHP language in 30 days?
First at all as a php trainer i would ask if you know html,csss,javascript nicely or not. As per me you should be at mediator level in those things to start php. Ok hopping you know that. Then go for some...
Profile Photo
Veerendra
0 0
View Comments6

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

What is the difference between PHP and PYTHON
Let's start with PHP: - Ideal for standard web development- Easy integration with MySQL- $_GET and $_POST built into the language- C-Esque syntax Primarily used on an Apache server (Routinely, you...
Profile Photo

PHP
It is the base for many of the ecommerce websites. Many of the CMS develpoped in PHP platform.If programming cant done inititally try to think for logics and develop writing algorithms. Any doubts divyaravindiran@gmail.com.
Profile Photo

Hiding .php extension Using HTACESS File
If you wish to hide.php extension from your website, then create a .htaccess file in your project root and paste the following code : RewriteEngine On RewriteCond %{THE_REQUEST} ^{3,}\s/(.+)\.php*...
Profile Photo

Basics about the PHP
Basics: Father of PHP Rasmus Lerdorf. Developed in 1994. Existing in 1999 PHP stands for: PHP: Hypertext Preprocessor. PHP is an Open Source Software (OSS) free to download and Use. PHP is...
Profile Photo

SQL Tips (4 to 6)
SQL tips 4:Avoid INDEX, unless you need to retrieve information quickly. Index will slower insert and update data query.The another way is using sub querySelect MAX(salary)FROM employeeWHERE salary IN(Select...
Profile Photo

Recommended Articles

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Looking for PHP Classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you