PHP - My Database Dont Get Updated

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>
';

}

Hi. I am trying to figure out the best approach to pull THE most recent record for display, and ONLY the most recent one. I am really not sure how to go about doing this. Ive just started into stored procedure programming and php, but havent found anything yet on this one. Thanks.

I have a script to update certain rows that contain certain data in them.

Here is the code:




  if ($_POST['newstype'] == "1") {
      $query = mysql_query("SELECT * from `news` WHERE type='1'");
      if (mysql_num_rows($query) == 1) {
          mysql_query("UPDATE `news` SET type = '2' WHERE type = '1' ORDER BY `news`.`dtime` ASC LIMIT 1") or die(mysql_error());
      } else {
          echo "did not edit main news";
      }
  }
  elseif ($_POST['newstype'] == "2") {
        $query = mysql_query("SELECT * from `news` WHERE type='2'");
      if (mysql_num_rows($query) == 3) {
          mysql_query("UPDATE `news` SET type = '3' WHERE type= '2' ORDER BY `news`.`dtime` ASC LIMIT 1") or die(mysql_error());
      } else {
          echo "did not edit recent news";
      }
  }
  elseif ($_POST['newstype'] == "3") {
        $query = mysql_query("SELECT * from `news` WHERE type='3'");
      if (mysql_num_rows($query) == 3) {
          mysql_query("UPDATE `news` SET type = '4' WHERE type= '3' ORDER BY `news`.`dtime` ASC LIMIT 1") or die(mysql_error());
      } else {
          echo "did not edit old news";
      }
  }
  else
  {
  echo "didnt update anything!";
  }    


Here is my database structure.


Why is it not updating it and always saying Did not edit main/recent/old news.

I have been using an inventory application built on PHP/MySQL. Since this morning I could submit the data and they were perfectly reflected on the MySQL Table. However, for a few hours I cannot save the submitted data to the table and it doesn't show any error message. Please note no change have been made since it was successfully running. The developer of this application is not available right now.   PLEASR HELP I AM A NOVICE IN PHP/MYSQL.

I think I've gotten as far as I can with my troubleshooting so hopefully someone can help me here.
I have a constructor for a controller class that receives the $_SESSION array from index.php by reference. An instance variable is then created when references this references so that any changes made to this instance variable update the real $_SESSION variable. This was working until it mysteriously stopped after not touching it for a few hours.
The local $this->session variable is working because it completes some tasks using it. I've also hardcoded values into the session from the index.php file and when they are hard coded the session works as you would expect so it seems to just not be connecting this local variable to the $_SESSION array anymore for some reason.

index.php snippet:
Code: [Select]
session_start();
$action = 'login';
$controller = new UserController($_POST,$_SESSION);

call_user_func(array($controller,$action));

constructor and login action from UserController (constructor is actually from a base controller but that shouldn't matter).
Also the activeSession() function that checks if a session is valid and kicks the user if its not (which is what happens when anything is tried after logging in):
Code: [Select]
    function __construct($post,&$session){
        $this->post = $post;
        $this->session = &$session;
        $this->view = 'views/login.php';
        $this->title = '';
        $this->error = '';
    }

    function login(){
        try{
            $user = $this->validateString($this->post['username'],'Username');
            $pass = $this->validateString($this->post['password'],'Password');
            $dao = new UserData();
            $this->session['userid'] = $dao->login($user, $pass);
            $this->session['username']=$user;
            $dao = new PostData();
            $this->posts = $dao->getFeedPosts($this->session['userid']);
            $this->view = 'views/posts.php';
            $this->title = 'Post Feed';
        }
        catch(Exception $e){
            $this->handleException($e);
        }
    }

    function activeSession(){
        if(!empty($this->session['userid']))
            return true;
        else return false;
    }


Any help would be amazing. I really don't know how this stopped working.
Thanks in advance.

Hi guys,

I need your help. I am checking on a database as I want to see if the records have been updated or not.

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_channel_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_channel_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";
    }
  }
} 
?>

When I run debug the code on my php, if i input the data in a url bar while the records are the same as the data that I enter in the url, i should get the print out on my php "already updated", but I keep getting "update!".

Do you know how i can check on mysql database to see if the records have been updated or not??

Hi all, i want delete old updated images with considering its index in array.

<?php
global $oldimg;
$oldimg = array();
//action: edit news
if (isset($_GET['id'])) {

$NewsID = (int)$_GET['id'];

if ($NewsID == 0) {

$rdir = '<META HTTP-EQUIV="Refresh" CONTENT="1.4;URL=panel-news.php">';

die($rdir);}

//get user from the database and put data into $_POST variables.

//Include database connection details

require_once('../config.php');

//Connect to mysql server

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

if(!$link) {

 die('Failed to connect to server: ' . mysql_error());

}

//Select database

 $db = mysql_select_db(DB_DATABASE);

 if(!$db) {

die("Unable to select database");

  

  }

$rs = mysql_query("SELECT  newsimg1, newsimg2, ".
    " newsimg3 FROM news WHERE id = $NewsID");
if (mysql_num_rows($rs) == 0) die('no such a  newsID!');

$row = mysql_fetch_assoc($rs);

$oldimg[0] = $row['newsimg1'];

$oldimg[1] = $row['newsimg2'];

$oldimg[2] = $row['newsimg3'];
}
?>
<form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>"
             enctype="multipart/form-data">
                <input type=file name="file[]" size=20 
                accept="image/jpg,image/jpeg,image/png">
                <input type=file name="file[]" size=20 
                accept="image/jpg,image/jpeg,image/png">
                <input type=file name="file[]" size=20 
                accept="image/jpg,image/jpeg,image/png">
                <input type="hidden" name="MAX_FILE_SIZE" value="2097152" />
                <input type="hidden" name="NewsID" 
                value='<?php echo (isset($NewsID))?$NewsID:"0";?>'>

<input type="submit" value="edit" id="save"  name="save"/>

</form>
            <?php

if (isset($_POST['save']) && isset($_POST['NewsID'])){

$NewsID = (int)$_POST['NewsID'];

  //Include database connection details

  require_once('../config.php');

  //Connect to mysql server

  $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

  if(!$link) {

   die('Failed to connect to server: ' . mysql_error());

  }

  //Select database

  $db = mysql_select_db(DB_DATABASE);

  if(!$db) {

  die("Unable to select database");

}

  //max fle size value

  $max_file_size = 2097152;

  //Global newsimg

  global $newsimg;global $ctr;

  $ctr = 0;

  //timestamp to make files unique names

  $timestamp = time();

  //destination folder path

  $destpath = "../Dir/Newsimg/";

  //looping each file or image from the form

  while(list($key,$value) = @each($_FILES["file"]["name"])) {

  //check if any empty or errors

  if(!empty($value)){

  if ($_FILES["file"]["error"][$key] > 0) {

  $edir ='<div id="fail" class="info_div">';

  $edir .='<span class="ico_cancel"><strong>';

  $edir .="err : ".  $_FILES["file"]["error"][$key]  .'</strong></span></div>';

  echo($edir);

  } else {

  //add the timestamp to filename

  $file_name = $timestamp.$_FILES['file']['name'];

  //temp name from upload form,  key of each is set

  $source = $_FILES["file"]["tmp_name"][$key] ;

  //getting the file type

  $file_type = $_FILES["file"]["type"][$key];

  //placing each file name into a variable

  $filename1 = $_FILES["file"]["name"][$key];

  //lowering the file names

  $filename = strtolower($filename1);

  //adding timestamp to front of file name

  $filename = "$timestamp$filename";

  ++$timestamp;

  if ($file_type != "image/jpeg" && $file_type != "image/png" && $file_type != "image/jpg") {

die("

<div id='fail' class='info_div'>

<span class='ico_cancel'><strong>

Invalid Format!</strong></span><br />

<a href=\"javascript: history.go(-1)\">Retry</a>

</div>"); }

 //moving the file to be saved from the temp location to the destination path

  move_uploaded_file($source, $destpath . $filename);

  //the actual final location with timestamped name

  $final_file_location = "$destpath$filename";

  if (file_exists($final_file_location)) {

  if (isset($oldimg[$ctr])) {

  chdir('../Dir/Newsimg/');

  echo $oldimg[$ctr];

  unlink($oldimg[$ctr]);}

  $newsimg[$ctr] = $filename;

  $ctr++;

  
?>TNX.

I am creating a stream page that updates automatically without the page reloading by reloading a div on the page using a timer. However, I only want it to run the update and fade in/fade out when there is a new status in the table. I tried doing it through PHP getting the number of rows in the table on the page itself and then checking the number of rows on an action page, however, the number of rows didnt update when the div was reloaded. I then tried doing it using jquery/javscript but had the same problem.

How can I acheive this?   Thanks in advance

I am trying to set the hidden input in the javascript but it doesn't set it in the php. 

This is the form with the hidden input. It corresponds to a field in the database table with the name of draggables.

<form method="post" accept-charset="utf-8" id="myForm2" action="/mealplans/add">

<input type="hidden" name="draggables" id="drag12"/>

<button id="myId" type="submit">Submit Form</button>

</form>

This is where I change the value in the javascript:

if(data == "draggable3"){
alert("data " + data);
var x = document.getElementById("drag12").value;
x =  "draggable3";
alert(x);
} //end if

                
The alert pops up with draggable3 as it should but the value of null is what gets saved in the database. The javascript doesn't change the PHP value; it only changes the client side value.         

I've also tried getElementsByName but that didn't work either.

var y = document.getElementsByName("draggables").value;    //only changes it on the client

This is actually a cakephp site but this problem is with the PHP so I am publishing it here.

ok say I have a file that has something like

123456 abcde
654321 edcba

in a file.. how would I go about having the script pull "123456" and make it a variable in the script.. and "abcde" a variable?

and then "654321" a variable but is set in an array so that 123456 and 654321 are both the same variable but like $variable[0] and abcde and edcba would be $variable[1]
 

what do I have to do?

maybe some wiz kid out their can help me figure out whats going on here. What suppose to happen is a random site suppose to load into a iframe
When the frameset code below is inside the <body> tags only the menubar shows up and not the iframe with a random site.
Now when i take the code and put it oustide the <body> tag the menubar goes away and only the iframe with a random site is shown .
The goal of course is to get the menubar to be visible and to have a  iframe with a random site loaded into it.
For some reason i can only get one of the two the happen. I do hope i explained this well enough

  Code: [Select]
<frameset rows="80,*" BORDERCOLOR="#222222" BORDER="3">
          <frame src="explore.php" name="surfbar" marginwidth="O" marginheight="0" NORESIZE SCROLLING="no" />
          <frame src="<?php while ($row = mysql_fetch_array($result)){ print $row["url"];}?> " name="random" marginwidth="O" marginheight="0" noresize scrolling="auto" />
</frameset>--------------------------------------------------------------------------------------------------
Code: [Select]
<?php

/**
 * @author Brent Moeller
 * @copyright 2011
 */

include ('functions.php');
db_connect();

$result = mysql_query("SELECT * FROM slinks where approval='1' ORDER BY RAND() LIMIT 1") or
    die(mysql_error());

?>
<html>
<head>
<title>DizzyUrl Discovery Engine</title>
<link rel="stylesheet" type="text/css" href="mouseovertabs.css" />

<script src="mouseovertabs.js" type="text/javascript">

/***********************************************
* Mouseover Tabs Menu- (c) Dynamic Drive DHTML code library (www.dynamicdrive.com)
* This notice MUST stay intact for legal use
* Visit Dynamic Drive at http://www.dynamicdrive.com/ for this script and 100s more
***********************************************/

</script>
</head>

<body>
<frameset rows="80,*" BORDERCOLOR="#222222" BORDER="3">
          <frame src="explore.php" name="surfbar" marginwidth="O" marginheight="0" NORESIZE SCROLLING="no" />
          <frame src="<?php while ($row = mysql_fetch_array($result)){ print $row["url"];}?> " name="random" marginwidth="O" marginheight="0" noresize scrolling="auto" />
</frameset>
<div id="mytabsmenu" class="tabsmenuclass">
<ul>
<li><a href="http://www.javascriptkit.com" rel="gotsubmenu[selected]">JavaScript Kit</a></li>
<li><a href="http://www.cssdrive.com" rel="gotsubmenu">CSS Drive</a></li>
<li><a href="http://www.codingforums.com">No Sub Menu</a></li>
</ul>
</div>

<div id="mysubmenuarea" class="tabsmenucontentclass">

<!--1st link within submenu container should point to the external submenu contents file-->
<a href="submenucontents.htm" style="visibility:hidden">Sub Menu contents</a>

</div>

<script type="text/javascript">
//mouseovertabsmenu.init("tabs_container_id", "submenu_container_id", "bool_hidecontentsmouseout")
mouseovertabsmenu.init("mytabsmenu", "mysubmenuarea", true)

</script>

<noframes>
<p>This Browser does not support Frames.</p>
</noframes>

</body>


</html>

why this simple code only works on chrome??

function mostrarOcultar(obj) {
  document.getElementById('seguro').style.visibility = (obj.checked) ? 'hidden' : 'visible';
}

keep gettin error msg
Notice: Undefined index: id in C:\wamp\www\profile.php on line 42
 dun everything to define the index cud it b the verion of wamp i am using

Code: [Select]
if ($_GET['id']) {

     $id = $_GET['id'];

} else if (isset($_SESSION['id'])) {

$id = $_SESSION['id'];

} else {
print "important data to render this page is missing";
   //include_once "index.php";
   //}
   }
   //exit();
[code]

I have the echo statement set up for all files, but what i want to do is put an if statement for example if it contains .pdf or .docx dont echo out an image how would i do this? 

Code: [Select]

<?php $id = explode("/", $_GET['a']); $id = $id[2]; ?>
<?php global $allow_client_uploads; ?>
<div id="content">
<div class="wrapper content">

<h3 class="page-title"><?php echo $project['name']; ?></h3>

<div id="client-controls">
<a href="<?php echo $this->redirect('messages/add/'.$id, true); ?>" class="new-message">Post Message to Admin</a>

<?php if($allow_client_uploads): ?>
<a href="<?php echo $this->redirect('documents/add/'.$id, true); ?>" class="new-file">Upload A Document</a>
<?php endif; ?>

<a href="<?php echo $this->redirect('clients/change_password', true); ?>" class="change-password">Change Password</a>
</div>

<!--<div class="project-progress">Progress
<div class="progressbar">
        <div id="test" class="progressbar-completed"
style="width:<?php // echo $project['progress']; ?>%;">
            <div>&nbsp;</div>
        </div>
        <div><?php // echo $project['progress']; ?>%</div>
    </div>
    </div> -->
   
<ul class="project-phases">

<?php $n=0; global $document_upload_path;?>

<?php foreach($project['phases'] as $phase): ?>

<li class="clearfix">

<div class="large-bullet"><?php echo ++$n; ?> </div>

<h1 class="phase-title"><?php echo $phase ?></h1>

<?php if(@count($documents[$n])>0): ?>

<ol class="documents">

<?php foreach($documents[$n] as $doc): ?>
<li>
<a href="<?php echo $this->redirect('documents/download/'.$doc['path'], true); ?>">
<?php echo $doc['description']; ?> <br />
</a>

<?php //echo $doc['size']."K - "; ?>

<span class="date"><?php // echo date("F j, Y, g:i a", $doc['created']); ?></span>  
<?php // echo (isset($doc['uploaded_by']))? ", by ".$doc['uploaded_by']:""; ?>
                       <a href="/clientele/uploads/<?php echo $doc['path'];?>" class="lightbox"><?php echo '<img src="/clientele/uploads/'.$doc['path'].'" height="300" width="300">'; ?></a>
</li>
<?php endforeach;?>
</ol>

<?php else: ?>

<?php endif; ?>
</li>
<?php endforeach;?>
</ul>

<div class="sidebar">

<?php if(is_array($messages)): ?>
<div class="messagebar">Latest News</div><br />
<?php foreach($messages as $message): ?>

<div class="message clearfix">
           
<p class="body"><?php echo $message['message']; ?></p>
<span class="meta"> <?php // echo $message['posted_by']; ?></span>
</div>

<?php endforeach; ?>

<?php endif; ?>

</div>


<div class="clear"></div>
</div>
</div>

hi,

im getting the error

Quote

Fatal error: Call to undefined function notification() in C:\xampp\htdocs\xampp\index.php on line 21


after including the functions.php file i wrote. It does include it but the data isnt being recognised from it. If i copy/paste the notification() function into index.php it works.

Can someone tell me why so i can fix it?