PHP - Can Php Check Constantly If Database Updated?

Hi guys,

I need your help. I am checking on a database as I want to see if I have the same value in the url and in the database.


Code: [Select]
<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbuser');
    define('DB_PASSWORD', 'mydbpass');
    define('DB_DATABASE', 'mydbtable');
       
    $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));
    }
  
    $username = clean($_GET['user']);
    $password = clean($_GET['pass']);
    $test = clean($_GET['test']);
    $public = clean($_GET['public']);
   
   
   if (isset($_GET['user']) && (isset($_GET['pass']))) {
    if($username == '' || $password == '') {
  $errmsg_arr[] = 'username or password are missing';
  $errflag = true;
    }
} elseif (isset($_GET['user']) || (isset($_GET['test'])) || (isset($_GET['public']))) {
    if($username == '' || $test == '' || $public == '') {
  $errmsg_arr[] = 'user or others are missing';
  $errflag = true;
    }
  }

    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
  $qry="SELECT * FROM members WHERE username='$username' AND passwd='$password'";
  $result=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());


if ($username && $password) {
  if(mysql_num_rows($result) > 0) {
     $qrytable1="SELECT images, id, test, links, Public FROM user_list WHERE username='$username'";
    $result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());

    while ($row = mysql_fetch_array($result1)) {
        echo "<p id='test'>";
        echo $row['test'] . "</p>";
        echo '<p id="images"> <a href="images.php?test=test&id='.$row['id'].'">Images</a></td> | <a href="http://' .  $row["links"] . '">Link</a> </td> | <a href="delete.php?test=test&id='.$row['id'].'">Delete</a> </td> | <span id="test">'.$row['Public'].'</td>';
     }
   } else {
    echo "user not found";
  }
} elseif($username && $test && $public) {
    $qry="SELECT * FROM members WHERE username='$username'";
    $result1=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());
    
    if(mysql_num_rows($result1) > 0) {     
      $qrytable1="SELECT Public FROM user_list WHERE username='$username' && test='$test'";
      $result2=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());
      
      if(mysql_num_rows($result2) > 0) {
        $row = mysql_fetch_row($result2);
        mysql_query("UPDATE user_list SET Public=('$_GET[public]') WHERE username='$username' AND test='$test'");
        echo "update!";
      } else {
        echo "already updated!";
      }
    } else {
      echo "user not found";
    }
  }
} 
?>
This is the function I use to check the value in the database:

Code: [Select]
if (mysql_affected_rows($result2) > 0) {
         mysql_query("UPDATE user_list SET Public=('$_GET[public]') WHERE username='$username' AND test='$test'");
         echo "you have update it!";
       } else if (mysql_affected_rows($result2) < 0) {
         echo "it is not on the database";
       } else {
         echo "you have already updated!";
       }

When i input the different value in a url bar while the records are not the same as the value in the url and in the database, i can't get passed and I am keep getting "you have already updated!!" when the value in a database are different than I have input in a url.

Do you know how i can get pass it when I have input the different value in the url while it is not the same in the database?

Any advice would be much appreicated.

Thanks,
Mark

Hey All, first off Merry X-Mas

ok so I'm trying to insert something into the batabse in one of three areas' let me explain

there are three fields in the users database bounceone, bouncetwo and bouncethree now what I want to do is when the user clicks add to bounce list insert a value into the databse in one of these three hole, if bounceone is empty put it there, if not check bouncetwo if it's empty put it there, if not check the final one and if it's empty put it there else echo sorry please either remove a bounce

any ideas on how this can be done.

Sorry going to be a big post, but trying to query a sql database for a value

Original code

<?php if($this->item->params->get('catItemExtraFields') && count($this->item->extra_fields)): ?>
     <!-- Item extra fields -->
     <div class="catItemExtraFields">
        <h4><?php echo JText::_('K2_ADDITIONAL_INFO'); ?></h4>
        <ul>
         <?php foreach ($this->item->extra_fields as $key=>$extraField): ?>
         <?php if($extraField->value): ?>
         <li class="<?php echo ($key%2) ? "odd" : "even"; ?> type<?php echo ucfirst($extraField->type); ?> group<?php echo $extraField->group; ?>">
            <span class="catItemExtraFieldsLabel"><?php echo $extraField->name; ?></span>
            <span class="catItemExtraFieldsValue"><?php echo $extraField->value; ?></span>
         </li>
         <?php endif; ?>
         <?php endforeach; ?>
         </ul>
       <div class="clr"></div>
     </div>
     <?php endif; ?>


Now I want to check the name field for a value and if it is Closing Date print out something different from the value in value, so I've changed the red code to

<span class="catItemExtraFieldsLabel"><?php if $extraField->name ="Closing date"; ?></span>
            {
            <span class="catItemExtraFieldsLabel"><?php echo $extraField->name; ?></span>
             <span class="catItemExtraFieldsValue"><?php echo $this->item->publish_down, JText::_('K2_DATE_FORMAT_LC2')); ?></span>
                }
                else
                {
                <span class="catItemExtraFieldsLabel"><?php echo $extraField->name; ?></span>
            <span class="catItemExtraFieldsValue"><?php echo $extraField->value; ?></span>
                }
            <?php endif; ?>

Doesn't work though, tried a heap of variations but can't figure it out.

Thanks

Marc

Hello
i have a text box and a button on my webpage and want to get the text box to find the username i type into it from the database and when it does it will then go to number and delete any text that is under usernames number field as you can see i have no idea how.

Code: [Select]
$result = mysql_query("DELETE FROM mytable WHERE username='$username1' AND number='$number1'" );
Code: [Select]
<form name="form1" method="post" action="p.php">
<p><input type="submit" value="Enter" /></p>
<input name="username" type="text" id="username" size="15" maxlength="35" value="<?php echo $username1; ?>" />
</form>

How do you check if a MySQL or MySQLi server is available through php.
I'm trying to make a short script that makes sure the users server can run the application. Like all the popular ones do

I'm trying to get a nickname system working for a little project, but I've run into a problem.

This code that I wrote here gets the users nickname from their username:

Code: (php) [Select]
$user = $_GET['user'];
@mysql_select_db("db") or die( "Unable to select database");

$query = mysql_query("SELECT `nickname` FROM `info` WHERE `username`='$user'");

       WHILE($rows = mysql_fetch_array($query)):
           $nickname = $rows['nickname'];
           echo $nickname;
        endwhile;
?>

But the problem is, if the user doesn't have a nickname then it just turns up blank. How can I check if the output of $nickname is blank and if it is then just return their normal name ($user)

Thanks

Oh, and how to you format php code to look like php code on these forums?

Hello. I want to check if an e-mail address is stored into a database. I've found this type of code:

Code: [Select]
function verifmail($email)
{
    db_connect();
    if (mysql_num_rows(mysql_query("SELECT email FROM users WHERE email='$email';")))
    {
        return 1;
    }
    else
    {
        return 0;
    }
}
Is it correct ? Is there any other way?

I have a set of 26 checkboxes that are stored in an array. The below code dumps the comma separated array values into a single record column.


Code: [Select]
// dumping the type of job checkboxes

$type = $_POST['type'];
  var_dump($type);
 
    // Setting up a blank variable to be used in the coming loop.
  $allStyles = "";
 
  // For every checkbox value sent to the form.
  foreach ($type as $style) {
    // Append the string with the current array element, and then add a comma and a space at the end.
    $allTypes .= $style . ", ";
  }
 
    // Delete the last two characters from the string.
  $allTypes = substr($allTypes, 0, -2);


// end dumping the type of job checkboxes


This works great! But my needs go past this. The record can be edited. So I need to get the values back out of the database and populate the correct check boxes for editing.

The checkboxes are generated by this code.


Code: [Select]
<div class="text">Job Type&nbsp;(<a class="editlist" href="javascript:editlist('listedit.php?edit=typelist',700,400);">edit list</a>):</div>
<div class="field">

<?PHP

$connection=mysql_connect ("localhost", "name", "pass") or die ("I cannot connect to the database.");
$db=mysql_select_db ("database", $connection) or die (mysql_error());
$query = "SELECT type FROM typelist ORDER BY type ASC";
$sql_result = mysql_query($query, $connection) or die (mysql_error());
$i=1;
echo '<table valign="top"><tr><td>';
while ($row = mysql_fetch_array($sql_result)) {
$type = $row["type"];
    if ($i > 1 && $i % 26 == 0)
      echo '</td><td>';
  else if ($i)
  echo '';
  ++$i;
  echo "<input style='font-size:10px;' name='type[]' type='checkbox' value='$type'><span style='color:#000;'>$type</span></input><br/>";
}
  echo '</td></tr></table>';

?>
 
</div>


I am having a problem getting these checkboxes repopulated. I think that a way to do this is to:

Get the values out of the database in a array
Compare the values the list of all possible values.
Check the boxes of the values confirmed to be there.

I didn't build the application so I need help to work through this problem.

I am building a system where people are able to choose a food menu, they can modify each dish if needed and then say how many of each item they need for the order.

So when they pick the breakfast menu, it selects all starters, mains and desserts.  Should something need to be edited (sausages changed to vegitarian sausages) the user should be able to overtype what has been populated from the select statement)

When the form is submitted, the order needs to be linked to the current job which is in a field ssm_job.job_id but the changes to the menu items need to be stored somewhere for the current order only.  This obviously needs to be accessile later so further changes can be made if needed.  I am not sure of the best way to go about this as i am trying not to save every item in another database (just trying to be tidy)

Any advise on this would be greatly appreciated.

I have had help on this project in relation to an sql and the background can be found below, the help has been amazing but as this is a very different question i thought i would start a new thread.

 

Kind Regards

I embed YouTube videos on my site.   The problem is, the videos often get deleted by the user, which means that the videos obviously become unavailable on my site.   This happens often, which means that I regularly have to look through my site, find unavailable videos and delete them.   I am looking for an automated way of doing this.   Here's what I've got so far:

<?php
    $con = mysql_connect("", "", "");
    mysql_select_db("");
    $qry = "SELECT video_id FROM `table`";
    $run = mysql_query($qry, $con);    
    while($row = mysql_fetch_assoc($run)) {    
        $headers = get_headers("http://gdata.youtube.com/feeds/api/videos/{$row['video_id']}");
        if(!strpos($headers[0], '200')) {
            echo "Unavailable: {$row['video_id']}<br />";
            return false;
        }
        else {
            echo "Available: {$row['video_id']}<br />";
        }
    }
?>

The code's very slow and doesn't work. It produces a list of available videos and then stops when it finds one that is unavailable. The problem is, the video that it says is unavailable is usually available, which means that it's getting it wrong.   Is there a faster, more accurate way of doing it?   Basically, I want a fast and accurate way of checking the availability of the thousands of videos in my database and I want to produce a list of the ones that are unavailable.

Hi all,

I've got a website for an event, each team have their details on a page which are recalled from a SQl database.

But I'm wanting to create a password input box for each team, so when they enter the correct password they are taken to a page containing forms where they can edit the team details.

Here is the page with the users details on where they anter the password: http://www.wharncliffenetwork.co.uk/wrc/entered/team.php?id=8

I'm not sure how to code it, Can an IF statement be used? Anyone got any pointers? I'f been unsuccessful in finding a tutorial or something similar.

Hope that makes sense :S Cheers.

Hi there everyone,

I have the below code (needs to be sanitized for SQL injection - i know   ).  Submitting to a MYSQL database.  I wish to check on form submit if the users email address already exists, and if so display a simple error message (even just a windows error message) stating "the email address you have entered already exists".

I don't really know where to start with this, or what the code should look like, so any help and direction would be massively appreciated.  All i do know, is the email column is set to unique, and when i attempt to submit using an email i know exists the code appears to run successfully without spitting out any errors (i.e. the web url changes to the below php code) but the table doesn't update (which is correct).  I just don't know how to then return the user to the form (preferably with all their info still entered) when this happens along with a nice error message...

Kind regards,

Tom.

Code: [Select]
<?
$localhost="00.000.000.00";
$username="###";
$password="###";
$database="mfirst";

$firstname=$_POST['firstname'];
$surname=$_POST['surname'];
$dob="{$_POST['dobyear']}-{$_POST['dobmonth']}-{$_POST['dobday']}";

if (isset ($_POST['permissionnewsletter']) || (!empty ($_POST['permissionnewsletter'])))
{ $permissionnewsletter = "Yes"; }
else
{ $permissionnewsletter = "No"; }

$email=$_POST['email'];
$userpassword=$_POST['userpassword'];
$telephone=$_POST['telephone'];

mysql_connect($localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$insertintocustomerdetail = "INSERT INTO customerdetail VALUES (NULL,'$firstname','$surname','$dob','$permissionnewsletter','$email','$userpassword','$telephone',now())";
mysql_query($insertintocustomerdetail);

$addressline1=$_POST['addressline1'];
$addressline2=$_POST['addressline2'];
$cityortown=$_POST['cityortown'];
$county=$_POST['county'];
$postcode=$_POST['postcode']=strtoupper(@$_REQUEST['postcode']);

$insertintoaddresstable = "INSERT INTO addresstable VALUES (NULL,LAST_INSERT_ID(),'$addressline1','$addressline2','$cityortown','$county','$postcode',now())";
mysql_query($insertintoaddresstable);

mysql_close();
?>

Hello,

I am trying to get this backlink checker to work i have it working so it checks that the link itself matches and is there but this is the harder part that I don't understand.

I want to have it also check the nodeValue to make sure that it matches one of the nodeValue's from a mysql table

this is the code I have to make it check the href link

Code: [Select]
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 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";
    }

return $falseFound;
}
Now this all works fine, I just need it to check the actual nodeValue (anchor text as well) meaning check this:

<a href="http://google.com">Google</a>

There is a mysql table called "allowed_anchors" with 2 rows "id" and "anchor"

I need it to check if the nodeValue matches 1 of the allowed_anchors from the table.

If anyone knows how I can do this that would be very great i have been trying to figure it out for hours with no luck.

Thanks very much for any help to come.

Hi im new to php and I need help making webpage that queries a mysql database based on a 3 check boxes and displays results on the same page or on another page. The table being queried has 4 columns, name, gps, wifi, bluetooth. So for example a row in the table would be like, samsung galaxy s2, yes, yes, yes. The idea is for it to be a website that will display phones according to their features.

So the idea is depending on if the boxes were ticked the samsung galaxy would be displayed as a result. So i need some help understanding how to make this.

Some1 gave me the code below in attempt to help me (im not sure it works or not) but im not sure how fully use it, ie what pages i need to make and how i create the connection to the mysql database, and how to use the query that they wrote to display the results

thanks

code:
Code: [Select]
<form action="?do=filter" method="post">
<table cellspacing="0" cellpadding="3" border="1">
<tr>
<td>GPS<input type="checkbox" name="gps" value="checked"></td>
<td>Wifi<input type="checkbox" name="wifi" value="checked"></td>
<td>Bluetooth<input type="checkbox" name="bluetooth" value="checked"></td>
</tr>
<tr><td><input type='submit' name='filter' value='Filter'></td></tr>
</table>
</form>
</html>
<?php
function filterMe($filter){
if(isset($_POST[$filter])){
return "Yes";
}else{
return "No";
}
}

if(isset($_POST['filter'])){
echo "Gps - " . filterMe('gps');
echo "
Wifi - " . filterMe('wifi');
echo "
Bluetooth - " . filterMe('bluetooth');
}
?>


All you need to do is use a query something like
SELECT name,gps,wifi,bluetooth FROM `product` WHERE `gps`='".filterMe('gps')."' AND `wifi`='".filterMe('wifi')."' AND `bluetooth`='".filterMe('bluetooth')."'

Is there something wrong with this query?


elseif($_POST["titlee"] && $_POST["contente"])
{

$titlee = $_POST['titlee'];
$contente = $_POST['contente'];
$to = $_POST['edit'];

mysql_query("UPDATE custom_pages SET title='$titlee' AND content='$contente' WHERE id='$to'");
echo  '<div class="post">
<div class="postheader"><h1>Updated</h1></div>
<div class="postcontent">
<p>Your custom page has been updated.</p>
</div>
<div class="postfooter"></div>
</div>
';

}