Search Webmaster Help and Solution

emailing users on click

Hi,
I am creating an admin page that allows me to view requests for sheet music that is not currently on my website.
(View image to get an idea of what were talking about).

On this page are 6 columns.
ID (autoincremented) This is the # the request is
Userid - the users id
artist - the name of the artist the user requested
title - the name of the title the user requested
added - after I have manually added the sheet music to my site, i click added which will set the "added" column in my sql table to "yes". Also, once added is clicked, an email will be sent to the user that originally requested the sheet.
delete - This deletes the row in the sql database, and removes it from view on my page.
At the bottom of the page, there is also a button called "Added All", which goes through and sets the "added" status to "yes" for all rows on the page.

So, the problem Im having right now, is emailing the user after I have selected Added. After I figure this out, I need to implement it into the "Added All" button, which will email all the corresponding users. Here is what I have come up with. Any input appreciated.
Im not getting any errors at this point. I tested my variables and all are echoing out correctly.

The area that I have specified to email the user is in this if statement:
PHP Code: if ($confirm==true && isset($_GET[id]))
Heres my code. Thanks

PHP Code: <?php
session_start();

include_once(../inc/connect.php);
include_once(../inc/admin.php);
if (isset($_SESSION[username])){
$loginstatus = logout;

if(!isset($_SESSION[sort_counter]))
{$_SESSION[sort_counter] = 1;}

if(($_SESSION[sort_counter]%2) == 0){ //test even value
  $sortcount = DESC;
}else{ //odd value
  $sortcount = ;
}

$result = mysql_query(SELECT * FROM requests WHERE added=no ORDER BY id);

$requestedquery = mysql_query(SELECT added FROM requests WHERE added=no);
$requestedcount = mysql_num_rows($requestedquery);

$addedquery = mysql_query(SELECT added FROM requests WHERE added=yes);
$addedcount = mysql_num_rows($addedquery);

$getuserinfo = mysql_query(SELECT * FROM users);
$row2 = mysql_fetch_assoc($getuserinfo);

$sort = $_GET[sort];
$delete = $_GET[delete];
$confirm = $_GET[confirm];

/////////////////////////////////

if ($sort==id){

    // $result = mysql_query(SELECT * FROM users ORDER BY id);  
$result = mysql_query(SELECT * FROM requests WHERE added=no ORDER BY id $sortcount);
$_SESSION[sort_counter] = $_SESSION[sort_counter] + 1; //increment after every run

}
if ($sort==userid){

    // $result = mysql_query(SELECT * FROM users ORDER BY username);
$result = mysql_query(SELECT * FROM requests WHERE added=no ORDER BY userid $sortcount);
$_SESSION[sort_counter] = $_SESSION[sort_counter] + 1; //increment after every run
}
if ($sort==artist){

    // $result = mysql_query(SELECT * FROM users ORDER BY email);
$result = mysql_query(SELECT * FROM requests WHERE added=no ORDER BY artist $sortcount);
$_SESSION[sort_counter] = $_SESSION[sort_counter] + 1; //increment after every run
}
if ($sort==title){

    // $result = mysql_query(SELECT * FROM users ORDER BY email);
$result = mysql_query(SELECT * FROM requests WHERE added=no ORDER BY title $sortcount);
$_SESSION[sort_counter] = $_SESSION[sort_counter] + 1; //increment after every run
}
if ($sort==file){

    // $result = mysql_query(SELECT * FROM users ORDER BY email);
$result = mysql_query(SELECT * FROM requests WHERE added=no ORDER BY file $sortcount);
$_SESSION[sort_counter] = $_SESSION[sort_counter] + 1; //increment after every run
}

/// FIX THIS AREA
if ($confirm==true && isset($_GET[id]))
{
    mysql_query(UPDATE `requests` SET `added`=yes WHERE id = . (int)$_GET[id]);
    $useremailquery = mysql_query(SELECT email FROM users WHERE id=.$row2[id].);
    $emailrow = mysql_fetch_assoc($useremailquery);
    
    $useremail = $emailrow[email];
    
    $to = $useremail;
    $subject = Sheet requested ready for download!;
    $Email = This e-mail address is being protected from spambots. You need JavaScript enabled to view it ;
    
    mail($to, $subject,
    Hello, <br />The sheet that you requested on Sheet Music site is now ready for download.<br />
    Thank you<br /><strong>Sheet Music site</strong>, $Email);
    
    echo <SCRIPT language=JavaScript><!--
  window.location=requestedsheets.php;//-->
</SCRIPT>;
}  
if ($delete==true && isset($_GET[id]))
{
    mysql_query(DELETE FROM `requests` WHERE id = . (int)$_GET[id]);    
    echo <SCRIPT language=JavaScript><!--
  window.location=requestedsheets.php;//-->
</SCRIPT>;
}  
if ($delete==false && isset($_GET[id]))
{
    echo <SCRIPT language=JavaScript><!--
  window.location=requestedsheets.php;//-->
</SCRIPT>;
}  
?>
<!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/html4/loose.dtd>
<html lang=en-US xml:lang=en-US xmlns=http://www.w3.org/1999/xhtml>
<head>
<link rel=stylesheet type=text/css href=../styles/style.css />
<link rel=stylesheet type=text/css href=../styles/requestedsheets.css />

</head>
<body bgcolor=#343331>

<!-- Header -->
<div id=header>
    <div id=headerleft></div>
    <div id=headermiddle><a href=../index.php><img src=../img/logo.png></a></div>
    <div id=headerright>
    

            <?php echo <form name=login action=../inc/$loginstatus.php method=POST>;?>
            <div class=loginboxdiv id=username>
            <input type=text class=loginbox name=username value=Username onFocus=make_blank(); onBlur=undoBlank();>
            </div>
            <div class=loginboxdiv id=password>
            <input class=loginbox type=text name=password type=text value=Password onFocus=make_blank1(); onBlur=undoBlankpass();>
            </div>
            <div id=login>
            <?php echo <input type=image src=../img/$loginstatus.png alt=.ucfirst($loginstatus).>;?>
            </div>
            </form>
            <div id=register>
            <a href=../register.php><img src=../img/register.png></a>
            </div>
            <div id=forgotpassword>
            <a href=../resetpassword.php class=forgot>Forgot Password?</a>
            </div>
    </div>
    
</div>

<!-- Content Top -->
<div id=contenttop>
    <div id=links>
    
    <table cols=7>
    <tr>

    </tr>
    </table>
<!-- 92x30 -->
    </div>
</div>

<!-- Content Middle -->
<div id=contentmiddle>
<div id=content>

<?php
include(inc/navadmin.php);
echo <br /><div style=font-size: 28px; text-align: center;>Requested Sheets</div>
<div id=headcont>
<div id=requested>Requested Sheets: .$requestedcount.</div>
<div id=added>Added Sheets: .$addedcount.</div>
</div><br />
<table border=1 align=center>
<tr>
<th bgcolor=#cccccc><a href=requestedsheets.php?sort=id>ID</a></th>
<th bgcolor=#cccccc><a href=requestedsheets.php?sort=userid>UserID</a></th>
<th bgcolor=#cccccc><a href=requestedsheets.php?sort=artist>Artist</a></th>
<th bgcolor=#cccccc><a href=requestedsheets.php?sort=title>Title</a></th>
<th bgcolor=#cccccc><a href=requestedsheets.php>Added</a></th>
<th bgcolor=#cccccc><a href=requestedsheets.php>Delete</a></th>
</tr>;
echo <script type=text/javascript>
function show_delete()
{
var r=confirm(Delete?);
if (r==true)
{
// Delete
return true;
}
else
{
// Dont Delete
return false;
}
}
;

echo
function show_undelete()
{
var r=confirm(Undelete?);
if (r==true)
{
// Undelete
return true;
}
else
{
// Dont Undelete
return false;
}
}
</script>;

$usersids = ;
$i = 0;

while($row = mysql_fetch_array($result))
  {
  
  //
  $active = $row[active];
  $color = #ffffff;
  $deleted = Delete;
  if ($active==no){
  $color = #f43636;
  $deleted = Undelete;
  $active = false;
  $alert = show_undelete;
  }
  else{
  $active = true;
  $alert = show_delete;
  }
  //
  
  echo <tr>;
  echo <td align=center width=40 bgcolor=$color> .$row[id]. </td>;
  echo <td align=center width=40> .$row[userid]. </td>;
  echo <td align=center width=230>.ucwords($row[artist]).</td>;
  echo <td align=center width=230>.ucwords($row[title]).</td>;
  echo <td align=center width=10><a href=requestedsheets.php?confirm=true&id= .$row[id] . >Added</a></td>;
  echo <td align=center width=10><a href=requestedsheets.php?delete=$active&id= .$row[id]. onclick=return $alert()>$deleted</a></td>;
  echo </tr>;
  $usersids[$i] = $row[id];
  $i++;
  }

  echo
  <tr>
    <td align=center width=10 colspan=6><a href=requestedsheets.php?confirm=all>Added All</a></td>
  </tr>;
  
  if ($confirm==all)
{
    $i = 0;
    mysql_data_seek($result,0);
    while($row = mysql_fetch_array($result))
  {
    mysql_query(UPDATE `requests` SET `added`=yes WHERE id = . $usersids[$i]);
    $i++;
  }
    echo <SCRIPT language=JavaScript><!--
  window.location=requestedsheets.php;//-->
</SCRIPT>;
}  
  
echo </table>;
}
else{
$loginstatus = login;
}
?>

</div>

</div>

<!-- Content Bottom -->
<div id=contentbottom>

</div>

</body>
</html> Hi,
I am creating an admin page that allows me to view requests for sheet music that is not currently on my website.
(View image to get an idea of what were talking about).

On this page are 6 columns.
ID (autoincremented) This is the # the request is
Userid - the users id
artist - the name of the artist the user requested
title - the name of the title the user requested
added - after I have manually added the sheet music to my site, i click added which will set the "added" column in my sql table to "yes". Also, once added is clicked, an email will be sent to the user that originally requested the sheet.
delete - This deletes the row in the sql database, and removes it from view on my page.
At the bottom of the page, there is also a button called "Added All", which goes through and sets the "added" status to "yes" for all rows on the page.

So, the problem Im having right now, is emailing the user after I have selected Added. After I figure this out, I need to implement it into the "Added All" button, which will email all the corresponding users. Here is what I have come up with. Any input appreciated.
Im not getting any errors at this point. I tested my variables and all are echoing out correctly.

The area that I have specified to email the user is in this if statement:
PHP Code: if ($confirm==true && isset($_GET[id]))
Heres my code. Thanks

PHP Code: <?php
session_start();

include_once(../inc/connect.php);
include_once(../inc/admin.php);
if (isset($_SESSION[username])){
$loginstatus = logout;

if(!isset($_SESSION[sort_counter]))
{$_SESSION[sort_counter] = 1;}

if(($_SESSION[sort_counter]%2) == 0){ //test even value
  $sortcount = DESC;
}else{ //odd value
  $sortcount = ;
}

$result = mysql_query(SELECT * FROM requests WHERE added=no ORDER BY id);

$requestedquery = mysql_query(SELECT added FROM requests WHERE added=no);
$requestedcount = mysql_num_rows($requestedquery);

$addedquery = mysql_query(SELECT added FROM requests WHERE added=yes);
$addedcount = mysql_num_rows($addedquery);

$getuserinfo = mysql_query(SELECT * FROM users);
$row2 = mysql_fetch_assoc($getuserinfo);

$sort = $_GET[sort];
$delete = $_GET[delete];
$confirm = $_GET[confirm];

/////////////////////////////////

if ($sort==id){

    // $result = mysql_query(SELECT * FROM users ORDER BY id);  
$result = mysql_query(SELECT * FROM requests WHERE added=no ORDER BY id $sortcount);
$_SESSION[sort_counter] = $_SESSION[sort_counter] + 1; //increment after every run

}
if ($sort==userid){

    // $result = mysql_query(SELECT * FROM users ORDER BY username);
$result = mysql_query(SELECT * FROM requests WHERE added=no ORDER BY userid $sortcount);
$_SESSION[sort_counter] = $_SESSION[sort_counter] + 1; //increment after every run
}
if ($sort==artist){

    // $result = mysql_query(SELECT * FROM users ORDER BY email);
$result = mysql_query(SELECT * FROM requests WHERE added=no ORDER BY artist $sortcount);
$_SESSION[sort_counter] = $_SESSION[sort_counter] + 1; //increment after every run
}
if ($sort==title){

    // $result = mysql_query(SELECT * FROM users ORDER BY email);
$result = mysql_query(SELECT * FROM requests WHERE added=no ORDER BY title $sortcount);
$_SESSION[sort_counter] = $_SESSION[sort_counter] + 1; //increment after every run
}
if ($sort==file){

    // $result = mysql_query(SELECT * FROM users ORDER BY email);
$result = mysql_query(SELECT * FROM requests WHERE added=no ORDER BY file $sortcount);
$_SESSION[sort_counter] = $_SESSION[sort_counter] + 1; //increment after every run
}

/// FIX THIS AREA
if ($confirm==true && isset($_GET[id]))
{
    mysql_query(UPDATE `requests` SET `added`=yes WHERE id = . (int)$_GET[id]);
    $useremailquery = mysql_query(SELECT email FROM users WHERE id=.$row2[id].);
    $emailrow = mysql_fetch_assoc($useremailquery);
    
    $useremail = $emailrow[email];
    
    $to = $useremail;
    $subject = Sheet requested ready for download!;
    $Email = This e-mail address is being protected from spambots. You need JavaScript enabled to view it ;
    
    mail($to, $subject,
    Hello, <br />The sheet that you requested on Sheet Music site is now ready for download.<br />
    Thank you<br /><strong>Sheet Music site</strong>, $Email);
    
    echo <SCRIPT language=JavaScript><!--
  window.location=requestedsheets.php;//-->
</SCRIPT>;
}  
if ($delete==true && isset($_GET[id]))
{
    mysql_query(DELETE FROM `requests` WHERE id = . (int)$_GET[id]);    
    echo <SCRIPT language=JavaScript><!--
  window.location=requestedsheets.php;//-->
</SCRIPT>;
}  
if ($delete==false && isset($_GET[id]))
{
    echo <SCRIPT language=JavaScript><!--
  window.location=requestedsheets.php;//-->
</SCRIPT>;
}  
?>
<!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/html4/loose.dtd>
<html lang=en-US xml:lang=en-US xmlns=http://www.w3.org/1999/xhtml>
<head>
<link rel=stylesheet type=text/css href=../styles/style.css />
<link rel=stylesheet type=text/css href=../styles/requestedsheets.css />

</head>
<body bgcolor=#343331>

<!-- Header -->
<div id=header>
    <div id=headerleft></div>
    <div id=headermiddle><a href=../index.php><img src=../img/logo.png></a></div>
    <div id=headerright>
    

            <?php echo <form name=login action=../inc/$loginstatus.php method=POST>;?>
            <div class=loginboxdiv id=username>
            <input type=text class=loginbox name=username value=Username onFocus=make_blank(); onBlur=undoBlank();>
            </div>
            <div class=loginboxdiv id=password>
            <input class=loginbox type=text name=password type=text value=Password onFocus=make_blank1(); onBlur=undoBlankpass();>
            </div>
            <div id=login>
            <?php echo <input type=image src=../img/$loginstatus.png alt=.ucfirst($loginstatus).>;?>
            </div>
            </form>
            <div id=register>
            <a href=../register.php><img src=../img/register.png></a>
            </div>
            <div id=forgotpassword>
            <a href=../resetpassword.php class=forgot>Forgot Password?</a>
            </div>
    </div>
    
</div>

<!-- Content Top -->
<div id=contenttop>
    <div id=links>
    
    <table cols=7>
    <tr>

    </tr>
    </table>
<!-- 92x30 -->
    </div>
</div>

<!-- Content Middle -->
<div id=contentmiddle>
<div id=content>

<?php
include(inc/navadmin.php);
echo <br /><div style=font-size: 28px; text-align: center;>Requested Sheets</div>
<div id=headcont>
<div id=requested>Requested Sheets: .$requestedcount.</div>
<div id=added>Added Sheets: .$addedcount.</div>
</div><br />
<table border=1 align=center>
<tr>
<th bgcolor=#cccccc><a href=requestedsheets.php?sort=id>ID</a></th>
<th bgcolor=#cccccc><a href=requestedsheets.php?sort=userid>UserID</a></th>
<th bgcolor=#cccccc><a href=requestedsheets.php?sort=artist>Artist</a></th>
<th bgcolor=#cccccc><a href=requestedsheets.php?sort=title>Title</a></th>
<th bgcolor=#cccccc><a href=requestedsheets.php>Added</a></th>
<th bgcolor=#cccccc><a href=requestedsheets.php>Delete</a></th>
</tr>;
echo <script type=text/javascript>
function show_delete()
{
var r=confirm(Delete?);
if (r==true)
{
// Delete
return true;
}
else
{
// Dont Delete
return false;
}
}
;

echo
function show_undelete()
{
var r=confirm(Undelete?);
if (r==true)
{
// Undelete
return true;
}
else
{
// Dont Undelete
return false;
}
}
</script>;

$usersids = ;
$i = 0;

while($row = mysql_fetch_array($result))
  {
  
  //
  $active = $row[active];
  $color = #ffffff;
  $deleted = Delete;
  if ($active==no){
  $color = #f43636;
  $deleted = Undelete;
  $active = false;
  $alert = show_undelete;
  }
  else{
  $active = true;
  $alert = show_delete;
  }
  //
  
  echo <tr>;
  echo <td align=center width=40 bgcolor=$color> .$row[id]. </td>;
  echo <td align=center width=40> .$row[userid]. </td>;
  echo <td align=center width=230>.ucwords($row[artist]).</td>;
  echo <td align=center width=230>.ucwords($row[title]).</td>;
  echo <td align=center width=10><a href=requestedsheets.php?confirm=true&id= .$row[id] . >Added</a></td>;
  echo <td align=center width=10><a href=requestedsheets.php?delete=$active&id= .$row[id]. onclick=return $alert()>$deleted</a></td>;
  echo </tr>;
  $usersids[$i] = $row[id];
  $i++;
  }

  echo
  <tr>
    <td align=center width=10 colspan=6><a href=requestedsheets.php?confirm=all>Added All</a></td>
  </tr>;
  
  if ($confirm==all)
{
    $i = 0;
    mysql_data_seek($result,0);
    while($row = mysql_fetch_array($result))
  {
    mysql_query(UPDATE `requests` SET `added`=yes WHERE id = . $usersids[$i]);
    $i++;
  }
    echo <SCRIPT language=JavaScript><!--
  window.location=requestedsheets.php;//-->
</SCRIPT>;
}  
  
echo </table>;
}
else{
$loginstatus = login;
}
?>

</div>

</div>

<!-- Content Bottom -->
<div id=contentbottom>

</div>

</body>
</html>

View Complete Thread with Replies

Related Items

Query failed: connection to localhost:3354 failed (errno=111, msg=Connection refused).