Solved

true false statement mysql php

Posted on 2008-10-31
2
883 Views
Last Modified: 2013-12-13
Looking for a quick  example on how make a php to mysql (true / false) compare.

This would be using a sign up form:

So all the basic stuff I have down (login/sql/query/etc..)



I am guessing....example code ;)
 

// old or new user example //
 

function oldOrNew (signupID)
 

{

    login into db;

    login into myTable ;

	//compare the id against the table//
 

	if(userid on myTable == signupID & oldPassword on myTable == newPassword)

	{

		echo "you already have signed up...but you have uninstalled the application"
 

		echo "please fill out form about what we could have done to make it a better app, and thanks for coming back!"
 

	}   
 

	else

	{

		echo "thanks for signing up"

		doSomeFunction();

    }
 
 
 
 

}
 

// 11223 would be the example var ID to pass to the function //
 

oldOrNew(11223);

Open in new window

0
Comment
Question by:cntmedia
2 Comments
 
LVL 82

Accepted Solution

by:
hielo earned 250 total points
Comment Utility

<?php

//returns true if user already signed up

//false otherwise

function oldOrNew ($signupID,$newPassword) 

{

	mysql_connect("localhost","username","password") or die(mysql_error());

	mysql_select_db("dbname") or die(mysql_error());

	$rs = mysql_query("SELECT 1 signedUp FROM tableName WHERE tableName.id=$signupID and tableName.password = '$newPassword'") or die(mysql_error());

	if( mysql_num_rows($rs) > 0 )

	{

		echo "you already have signed up...but you have uninstalled the application"

		echo "please fill out form about what we could have done to make it a better app, and thanks for coming back!"

	} 

	else

	{

		echo "thanks for signing up"

		doSomeFunction();

    }

return (mysql_num_rows($rs) > 0);

}

 ?>

Open in new window

0
 
LVL 108

Expert Comment

by:Ray Paseur
Comment Utility
I think the easiest way to find out if a user had already signed up would be to select the user's id out of the data table.  If there are no rows, you have not got a user with that id.

HTH, ~Ray
if (!$r = mysql_query("SELECT uid FROM users WHERE ukey = 11223 LIMIT 1")) { die(mysql_error()); }
 

// IF MYSQL NUM ROWS IS ZERO, IT IS THE SAME AS FALSE; IF ONE IT IS TRUE

if (mysql_num_rows($r)) {

   echo "Already signed up";

} else {

   echo "Not signed up yet";

}

Open in new window

0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now