PHP - Help Checking If Numbers Are In A Database

Ok guys, I am working on my code as I am checking the row in a database that if i have got a same row that I insert the functions in the URL then throw the error that says "you can't store". When I am checking as the rows have already exist, i keep getting "you can now store".

Do you know how i can check in a database to see if the rows is exist?

here's the code:

Code: [Select]
<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbuser');
    define('DB_PASSWORD', 'mydbpass');
    define('DB_DATABASE', 'mydbname');
       
    $errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {

die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
    $image = clean($_GET['image']);
    $strings = clean($_GET['strings']);
    $username = clean($_GET['user']);
    $password = clean($_GET['pass']);


if (isset($_GET['user']) && (isset($_GET['pass']))) {
    if($username == '' || $password == '') {
  $errmsg_arr[] = 'username or password are missing';
  $errflag = true;
    }
}
if (isset($_GET['image']) || (isset($_GET['strings'])) || (isset($_GET['user']))) {
    if($image == '' || $strings == '' || $username == '') {
  $errmsg_arr[] = 'image, strings or username are missing';
  $errflag = true;
    }
}
    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {

 
$insert = array();
if(isset($_GET['image'])) {
    $insert[] = 'image = \'' . clean($_GET['image']) . '\'';
}
if(isset($_GET['user'])) {
    $insert[] = 'user = \'' . clean($_GET['user']) .'\'';
}
if(isset($_GET['pass'])) {
    $insert[] = 'pass = \'' . clean($_GET['pass']) . '\'';


if (count($insert)>0) {
  $names = implode(',',$insert);


 if($image && $strings && $from && $username) {
   $qry="SELECT * FROM members WHERE username='$username'";
   $result=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());
   $row=mysql_fetch_assoc($result);

   if ($row >= 1) {
      echo 'you cant store.';
   } else {
      echo 'you can now store';
 }
} elseif($username && $pass) {
  echo "working 2";
  }
 }
}
?>

Hello,

I am trying to get this backlink checker that checks to make sure another website has my link on their website, so far I can check to make sure the "href" link is there and is correct, but I cant get the textContent to prove valid or not it seems to always be proving true even when the textConent is not in the mysql database.

The other persons website will have this:
<a href="http://businessinvestingsorce.com">Business Investing Source</a>

I need to make sure Business Investing Source (the textContent) matches the anchor in the database.

Here is my code:

Code: [Select]
<?php

function CheckForAnchorMatch($anchortext) {    

$query = mysql_query("SELECT * FROM allowed_anchor WHERE anchor='$anchortext'");
if(mysql_num_rows($query) != 0) {
return true;
}

return false;

} 

function CheckForTargetUrl($links, $target) {    
    foreach ($links as $link) {
        if (strpos($link, $target) !== false) {
            return true;
        }
    }

    return false;
} 
                          
function ExtractHrefLinks($html) {
    $dom = new DOMDocument;
    $linkUrls = array();
     

    @$dom->loadHTML($html);
    $links = $dom->getElementsByTagName('a');
     
    foreach ($links as $link){
        $linkUrls[] = $link->getAttribute('href');
    }
    
    return $linkUrls;
}

function ExtractAnchorText($html) {
    $dom = new DOMDocument;
    $AnchorTexts = array();
     

    @$dom->loadHTML($html);
    $links = $dom->getElementsByTagName('a');
     
    foreach ($links as $link){
        $AnchorTexts[] = $link->textContent;
    }
    return $AnchorTexts;
}

function backlink_check($contenturl){

$url = 'businessinvestingsource.com';
$source = $contenturl;

$falseFound = false;

    $html = file_get_contents ( $source );
    $links = ExtractHrefLinks($html);
 
    if (CheckForTargetUrl($links, $url) === false) {
        $falseFound = "true";
        $reportArray[$source] = 0;
    } else {
        $falseFound = "false";
    }


    $html = file_get_contents ( $source );
    $anchortext = ExtractAnchorText($html);
    
    if (CheckForAnchorMatch($anchortext) === false) {
        $falseFound = true;
    } else {
        $falseFound = false;
    }

return $falseFound;
}
?>
Help greatly appreciated

Is there an alert method for the MySQL database or something similar?   What is the proper way to check if the MySQL database connection is working?   I mean other than "creating" and "retrieving" with "insert" and "select".

Is there a recommended BEST PRACTICE for storing (and retrieving) telephone numbers from a database table?

Is it best to store (in the USA) the area code separate from the rest of the number?  Remove parenthesis and/or dashes? 

Or is there no reason to concern myself with performance or hacking issues regarding the storage of phone numbers as 323-555-1212 or (323)555-1212 inside my table?

Hi all,

for some reason I cant see this blantantly obvious query.

I have 3 rows in my database, all with an id of 1, their is a column called price which contains three different float values, how the hell do I write a query in php for this?!
Code: [Select]
$q = mysql_query("SELECT price FROM mytable WHERE id=1")
????Thanks!

Hi,

What I'm trying to do is create a script that generates a random list of cars whenever it is run. I have a list of available cars in a MySQL database. I'm just not sure how to get php to generate a list of, say, 20 cars, that are randomly picked from the cars in the database. I may also want to add other statistics like MPG (also already in the database). Can anyone show me how to do this? And is it possible to format the returned data in a table or div format?

Thanks in advance
Unk

Hi,
I need to sort variables in groups of up to 15 and put it in an array. For example:
$exstract['center_tabOpBody_0'] =5
$exstract['center_tabOpBody_1'] =6
$exstract['center_tabOpBody_2'] =8
$exstract['center_tabOpBody_3'] =1


Should yield:
ARRAY(
          = center_tabOpBody_1,center_tabOpBody_2,center_tabOpBody_3 // <-----15 [1] = center_tabOpBody_0 //<----5
)

Is there some simple function do do the "efficiency" sort?

Thanks,
Vadim

Hello!

Does anyone know an effective way to track inactive idlers in daily basis?
So that it will count the amount of days no data has been posted to the table. 

E.g.

User posts latest data and inserts timestamp 1282228120 which reads Thursday, August 19th 2010, 14:28:40 (GMT)
The days for inactivity should output as 8 days because no data has been posted from 20th August to today - 28th August.

Anyway I can achieve this?
Any information is appreciated, thanks.

$characterIDs = explode(',', $_POST['characterIDList']);

After the explode I want to take all those values and do a select statement in a database table for any of the values that match any of the values inside that variable variable. Not sure how to do this since there is no limit to how may there could be.

I need to query a database for a starting time for a meeting, and if the start time is at 7pm, I need to allow access to a page from 6pm til 11pm.  Not a problem.

The problem lies when the ending time (4 hours after the start time) crosses over to a new day.

Here's what I have:

Code: [Select]
<?php
elseif ($row['meeting'] == "7:00pm") { $starthour = 18; $endhour = 23; }
elseif ($row['meeting'] == "8:00pm") { $starthour = 19; $endhour = 0; }

if ($thishour <= $endhour && $thishour >= $starthour)
{  include "meeting_ok.php"; }
else { echo "Meeting room is unavailable at this time...."; }
?>


The "0" for endhour is throwing things off.  How should I best account for a new day?

Thanks!

Hey

In my spare time, I am working on my PHP framework.
Now, to help with development and quickly discover where I miss a type cast, I have adopted to check all parameters that are passed to a method using a function.

For instance:

            public function __construct(&$target = null, $depth = 1){
            $this->validateArguments(
                array(1 => 'int'),
                array(1 => $depth)
            );



And the code that triggers the exception:
        public function testPhpFreakType(){
            $obj = 1;
            $p = new Xcms_DataStructures_Pointer($obj, "1");
        }


Code: [Select]
0: |--------------------------------------------------|
 1: |--Exception: 4cfe2e86ca5970.22624423 - Full Trace |
 2: |  Tue, 07 Dec 2010 13:54:30 +0100
 3: |-Class:
 4: |  Xcms_Exceptions_InvalidArgument
 5: |-Message:
 6: |  Argument #1 of Xcms_DataStructures_Pointer:__construct() is no _null:int
 7: |  Stack offset: 3
 8: |
 9: |-Trace
10: |  #0 D:\www\xcms_rev\core\exceptions\invalid.argument.helper.class.php(133): Xcms_Exceptions_InvalidArgumentHelper::factory(1, '_null:int', NULL, 2)
11: |  #1 D:\www\xcms_rev\core\basic.class.php(80): Xcms_Exceptions_InvalidArgumentHelper::validateArguments(Array, Array, Array, 1)
12: |  #2 D:\www\xcms_rev\core\data.structures\pointer.class.php(49): Xcms_Basic->validateArguments(Array, Array)
13: |  #3 D:\www\xcms_rev\core\data.structures\pointer.test.php(73): Xcms_DataStructures_Pointer->__construct(1, '1')
14: |  #4 [internal function]: Xcms_DataStructures_PointerTest->testPhpFreakType()
15: |  #5 C:\xampp\php\PEAR\PHPUnit\Framework\TestCase.php(737): ReflectionMethod->invokeArgs(Object(Xcms_DataStructures_PointerTest), Array)
16: |  #6 C:\xampp\php\PEAR\PHPUnit\Framework\TestCase.php(627): PHPUnit_Framework_TestCase->runTest()
17: |  #7 C:\xampp\php\PEAR\PHPUnit\Framework\TestResult.php(629): PHPUnit_Framework_TestCase->runBare()
18: |  #8 C:\xampp\php\PEAR\PHPUnit\Framework\TestCase.php(575): PHPUnit_Framework_TestResult->run(Object(Xcms_DataStructures_PointerTest))
19: |  #9 C:\xampp\php\PEAR\PHPUnit\Framework\TestSuite.php(766): PHPUnit_Framework_TestCase->run(Object(PHPUnit_Framework_TestResult))
20: |  #10 C:\xampp\php\PEAR\PHPUnit\Framework\TestSuite.php(742): PHPUnit_Framework_TestSuite->runTest(Object(Xcms_DataStructures_PointerTest), Object(PHPUnit_Framework_TestResult))
21: |  #11 D:\www\xcms_rev\core\testing\manager.class.php(83): PHPUnit_Framework_TestSuite->run()
22: |  #12 D:\www\xcms_rev\core\testing\manager.class.php(56): Xcms_Testing_Manager->testClass(Object(ReflectionClass))
23: |  #13 D:\www\xcms_rev\cache\pkg\scripting\script_1.php(3): Xcms_Testing_Manager->run(Object(Xcms_Url_DefaultRequest))
24: |  #14 D:\www\xcms_rev\core\util.lib.php(340): include('D:\www\xcms_rev...')
25: |  #15 D:\www\xcms_rev\core\packages\scripting\controllers\scripting.controller.php(66): Xcms_Util::sandboxedInclude('cache/pkg/scrip...', Array)
26: |  #16 D:\www\xcms_rev\core\mvc\controllers\default.controller.php(210): Xcms_Packages_Scripting_Controllers_ScriptingController->execute(Object(Xcms_Packages_Scripting_Models_ScriptModel), Object(Xcms_Templating_Context))
27: |  #17 D:\www\xcms_rev\core\mvc\controllers\default.controller.php(170): Xcms_Mvc_Controllers_DefaultController->runScript(1, 0, Object(Xcms_Templating_Context))
28: |  #18 D:\www\xcms_rev\core\mvc\controllers\default.controller.php(132): Xcms_Mvc_Controllers_DefaultController->runScripts(0, 0, Array, Array, 1, 0)
29: |  #19 D:\www\xcms_rev\index.php(15): Xcms_Mvc_Controllers_DefaultController->run()
30: |  #20 {main}
31: |--------------------------------------------------|


I think this speeds up my development quite a bit, because I can catch errors very early in the development process.
I can give multipe possibilities of what is allowed for each parameter, not just a single possibility. Also, it is possible to register custom type/validity-checks on both global and local scope.

One thing I do worry about, however, is the the performance. Of course, I could just make the funciton do nothing in production code, if it takes too much time, or I could write a script to remove all calls to that function.

When I started learning python a while back, the concept to just code to interfaces instead of types seemed very intuitive and made my code much more flexible. Of course that is what I do with PHP as well, but I it's not entirely the same. So now, coming back at my PHP code and having introduced features of static languages such as type checking, I worry about whether that is the right approach.

What are your thoughts on the matter?

So basically I have a site, and on that site, I have a page that submits a form and updates a database. I have it set up so that someone can enter in Multiple values into a textarea, one on each line, and it will submit each of those values as a new row in the database, but for the life of me, I cannot figure out how to check those values against the actual users.

It is basically a point system, where the staff can award points users of the site. But at the moment, a Staff member could enter in Jibberish, and it would insert that into the database, but I want it to check my users table to make sure the user exists before it inserts it into the database.

here is my code:
<?php
include 'global.php';

echo $headersidebar;


if ($_COOKIE['access'] == $accessstaff)
{





if(count($_POST))
{



$array = preg_split('/(\r?\n)+/', $_POST['studentname']);
foreach($array as $students)
   {
   
   $statusmsg = '<center><span style="background: #A6FF9E;">You have successfully submitted points to the database.</span></center>';
   
   mysql_query("INSERT INTO points (giver, receiver, points, category, reason, date, status) VALUES ('{$_COOKIE['username']}', '{$students}', '{$_POST['pointamt']}', '{$_POST['pointcat']}', '{$_POST['pointreason']}', '{$date}', 'Validating')");
   }
}


$addpointspage = $statusmsg . '

<form action="submit_points.php" method="post">

<table class="table" >

<tr>

<td colspan="10">

<h1><strong><center>Submit Points</center></strong></h1>

</td>

</tr>

<tr>

<td colspan="10" rowspan="100">

<center>Please remember to follow the house point limits when submitting house points.</center>

</td>

</tr>

</table>

<table class="table">

<tr>

<td style="width: 15%;" valign="top">

Student Name:<br> <span style="font-size: 60%;">(List as many as you want; One per Line)</span>

</td>

<td colspan="10">

<center><textarea name="studentname" cols="60" rows="10"></textarea></center>

</td>

</tr>

<tr>

<td style="width: 15%;" valign="top">

Amount of Points:

</td>

<td>

<input style="position: relative; left: 16px;" type="text" size="15" name="pointamt" />

</td>

<td>

Do not put anything that is not a number into this box.

</td>

</tr>

<tr>

<td style="width: 15%;" valign="top">

Point Category:

</td>

<td colspan="10">

<select name="pointcat" style="position: relative; left: 16px;">

<option SELECTED value="">-------</option>

<option>Class Work</option>

<option>Class Exam</option>

<option>Extra Work</option>

<option>Contests</option>

<option>Teacher\'s Assistant</option>

<option>Negative Points</option>

</select>

</td>

</tr>

<tr>

<td style="width: 15%;" valign="top">

Reason:

</td>

<td colspan="10">

<input style="position: relative; left: 16px;" name="pointreason" type="text" size="80" />

</td>

</tr>

<tr>

<td>

</td>

<td colspan="10">

<input style="position: relative; left: 16px;" type="submit" value="Submit Points" />

</td>

</tr>

</table

</form>



';

}

elseif (1==1)
{
$addpointspage = $accessdenied;
}



echo

'

<!-- start content -->

<div id="content">

<div class="post">

<div class="entry">

<p><strong>' . $addpointspage . '</p>

<p class="links">' . $addpointslink . '</p>

</div>

</div>

</div>

<!-- end content -->

<div style="clear: both;">&nbsp;</div>

</div>

<!-- end page -->
</div>';








echo $footer;





?>


I am fairly new to PHP, so I would appreciate any help someone could give me; I am not too good with arrays and such, so this one has got me stumped.

I coded small funny script
I tested it in three hosting

ww.rufaa.net
dallawat.com/new
ibuj.org

but I don't know why in the first link, my script seem slow
not like the other second and third links

I have written the code for email check, but how and where can I put the code to check if a username has been used twice? Thanks in advance.
Code: [Select]
<?php

$servername = "localhost";
$username = "";
$password = "";

//validate fields
if(!$_POST["username"] || !$_POST["email"] || !$_POST["password1"] || !$_POST["password2"]){
echo "<p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><br />Please fill the required fields, <p>&nbsp;</p><p>&nbsp;</p><a href='register.php'>Go to register page</a>";

//validate password
}else if($_POST["password1"] != $_POST["password2"]){
echo "<p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><br />Please go back, PASSWORDS do not match! <p>&nbsp;</p><p>&nbsp;</p><a href='register.php'>Go to register page</a>";

//validate email
}else if(!(eregi("^.+@.+\\..+$", $_POST['email']))){
echo "<p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><br />Please enter a valid EMAIL! <a href='register.php'><p>&nbsp;</p><p>&nbsp;</p>Go to register page</a>";

//validate captcha
}else if(($_SESSION['security_code'] != $_POST['security_code']) || (empty($_SESSION['security_code'])) ){
echo "<p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><br />CAPTCHA CODE does not match! <p>&nbsp;</p><p>&nbsp;</p><a href='register.php'>Go to register page</a>";

}else{
$conn=  mysql_connect($servername,$username,$password)or die(mysql_error());
mysql_select_db("genesis_members",$conn);

// check if already registered
$sql_check = "SELECT * FROM users WHERE email = '".$_POST[email]."'";
$result_check = mysql_query($sql_check,$conn) or die(mysql_error());
$row = mysql_fetch_assoc($result_check);
if($row['id']){
echo "<p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><br />EMAIL already registered! <p>&nbsp;</p><p>&nbsp;</p><a href='register.php'>Go to register page</a>";
}else{

// insert in db
$sql = "INSERT INTO users (username, email, password, company, phone, services) VALUES ('".$_POST[username]."', '".$_POST[email]."', '".$_POST[password1]."', '".$_POST[company]."', '".$_POST[phone]."', '".$_POST[services]."')";
$result = mysql_query($sql,$conn) or die(mysql_error());

echo "<p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><br /><h1>You Have Successfully Registered</h1>";
echo "<p>&nbsp;</p><p>&nbsp;</p><br /><a href='main_login.php'>go to login page</a>";
}
}

?>

so here's the thing, ive downloaded mysql front and easy php , the HTML code ive written till now is

<html>
<head>
</head>
<body>
<h1>Registration Page</h1>
<form name="form" method="post" action="final-SignUp1.php">
<p>UserName <input type="text" name="username" /></p>
<p>Password <input type="password" name="password" /></p>
<p>Confirm Password<input type="password" name="confirm_password" /></p>
<p>Firstname <input type="text" name="firstname" /></p>
<p>Middlename <input type="text" name="middlename" /></p>
<p>Lastname <input type="text" name="lastname" /></p>
<p>address <input type="text" name="address" /></p>
<p>city <input type="text" name="city" /></p>
<p>Zipcode <input type="text" name="zip_code" /></p>
<p>Phone number <input type="text" name="telephone_number" /></p>
<p>Email address <input type="text" name="email" /></p>
<p>Confirm Email <input type="text" name="confirm_email" /></p>
<input type="submit" value="Register">
<input type="reset" value="Clear" /></p>
</form>
</body>
</html>



which i would like to link to this php code


<?php
$usr=$_POST["username"];
$pass=$_POST["password"];
$confirm=$_POST["confirm_password"];
$firstname=$_POST["firstname"];
$middlename=$_POST["middlename"];
$lastname=$_POST["lastname"];
$address=$_POST["address"];
$city=$_POST["city"];
$zipcode=$_POST["zip_code"];
$phonenumber=$_POST["`telephone_number`"];
$emailaddress=$_POST["email"];
$confirmemailaddress=$_POST["confirm_email"];
$db=mysql_connect("localhost","root","");
mysql_select_db("final-signup1",$db);
$q="INSERT INTO final-signup1 VALUES
('$usr','$pass','$confirm','$firstname','$middlename','$lastname','$address','$city','$zipcode',
'$phonenumber','$emailaddress','$cofirmemailaddress')";
mysql_query($q);
mysql_close();
?>

now on mysql-front  the database ive set till now is as follows




i know something is wrong with my code, because the data i enter in the register page isnt going to the database.

any help is greatly appreciated

thank you