PHP - Display Results In Table

Hey guys so my code below is not working, it will get the app information for the user but its only display 3 results like every time a new user "installs" an new app like it stops showing the last result and starts displaying the new result. Like for example right now it should be showing 7 results but only displaying 3 is there something wrong with my query. (PS: this is just developement testing purposes so thats why my code is sorta sloppy) Thanks!

$default_apps = mysql_query("SELECT * FROM apps WHERE `default`='1'") or die(mysql_error());
$user_apps = mysql_query("SELECT * FROM user_apps WHERE `user_id`='$user_id'") or die(mysql_error());
while($row = mysql_fetch_array($default_apps))
{
$url = $row['download_url'];
$name = $row['name'];
   echo $row['name'];
   echo "<a href='$url'>$name</a><br />";
} 
while($raw = mysql_fetch_array($user_apps)){
$app_id = $raw['app_id'];
}
$select_user_apps = mysql_query("SELECT * FROM apps WHERE `app_id`='$app_id' ");
while($rop = mysql_fetch_array($select_user_apps))
{
$name = $rop['name'];
$url = $rop['download_url'];
echo $name;
echo $url;
}

I'm new to php and been trying to follow along with different tutorials to try and build my own site, i followed a tutorial on making a search feature
for the site and have it working perfectly, but i want to change the way how to search displays the results. I want to make it display them how there displayed on the index page.

here is the index page how there displayed


<div id="table">
            <table>
                <tr class="top">
                <th>Account</th>
                <th>Country</th>
                <th>Info</th>
                <th>Login</th>
                <th>Pass</th>
                <th>Price</th>
                <th>Buy</th>
            </tr>
            
              
           <?php $class = 'grey'; ?>
                <?php $items = getItems(); ?>
           <?php if(empty ($items)): ?>
                <h3>No Items Found</h3>
            <?php else: ?>
                <?php foreach($items as $item): ?>
                  <?php $class = ($class == 'grey') ? 'grey2' : 'grey'; ?>
                   <tr class="<?php echo $class; ?>">              
                    <td><?php echo $item['item_account']; ?></td>
                    <td><?php echo $item['item_country']; ?></td>
                    <td><?php echo $item['item_info']; ?></td>
                    <td><?php echo maskUser($item['item_login']); ?></td>
                    <td><?php echo maskPass($item['item_pass']); ?></td>
                    <td><?php echo $item['item_price']; ?> </td>
                    <td><form method="post" action="https://sci.libertyreserve.com/"><input type="submit" name="buy" value="Buy" class="button" /></form></td>
                    
                </tr>
               
                <?php endforeach; ?>
          <?php endif; ?>


how the search is display


if (strlen($search) <= 2)
        {
            echo 'Search keyword is too short.';
        }
        else
        {
            echo "You searched for <b>$search</b><hr size='1'>";
           
              
                $search_exploded = explode(" ", $search);
                
                foreach($search_exploded as $search_each)
                {
                   
                    $x++;
                    if ($x == 1)
                        $construct .= "item_account LIKE '%$search_each%'";
                    else
                        $construct .= " OR item_account LIKE '%$search_each%'";
                        
                    
                }
                
                $construct = "SELECT * FROM items WHERE $construct";
                
               $run = mysql_query($construct);
               
               $foundnum = mysql_num_rows($run);
               
               if ($foundnum == 0)
               {
                   echo 'No results found.';
               }
               else
               {
                   echo "$foundnum results found!</p>";
                   
                   while ($numrows = mysql_fetch_assoc($run))
                   {
                       $item_id = $numrows['item_id'];
                       $itemAccount = $numrows['item_account'];
                       $itemI = $numrows['item_info'];
                       $itemLogin = $numrows['item_login'];
                       $itemPass = $numrows['item_pass'];
                       $itemPrice = $numrows['item_price'];
                       
                       echo "
                           <b>$itemAccount</b><br />
                           $itemI <br />
                            " . maskUser($itemLogin) . '<br />' . maskPass($itemPass, 0) . '<br />'; 
                   }
                   
               }
           
            
        }

my question is im not sure how to edit the search code to display the results in the same format as the index page

thanks

Hello all,

I have made the multi level marketing downline tree, but the problem with it now, it gives only the downline of one result, as the query gives 2 results
what I want now is to make it give the downline of both results not just one, and it's always 2 results, not more

here is my code

Code: [Select]

<?php

$id = $_GET['id'];     $result = mysql_query("SELECT id FROM users WHERE id = '".$id."' ORDER BY id");    $row = mysql_fetch_assoc($result);   if ($row['id'] == 0) {        echo"
<table>
<div id=\".piccenter\"";    
echo "<tr>";
 echo "<img src=\"icon.gif\" border=0 align=\"center\">"; echo ""; } else {  echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$row['id']."'"; echo ""; echo "</div>";  }  }    $result2 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$row['id']."'");    $rows2 = mysql_fetch_assoc($result2);  foreach ($rows2 as $row2) { if ($row2['id'] == 0) {        echo" <div id=\".picleft\"> <img src=\"icon.gif\" border=0 align=\"center\">"; } else {  echo "<img src=\"images.png\" border=0 >"; echo "<br />"; echo "'".$row2['id']."'"; echo "</div>"; echo "

<td>";      echo "</td>


";  }  }   $result3 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$rows2['id']."'");    $row3 = mysql_fetch_assoc($result3);   if ($row3['id'] == 0) {        echo"<div id=\".picright\"> <img src=\"icon.gif\" border=0 align=\"center\">"; } else {  echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$row3['id']."'"; echo ""; echo "
<tr>
<td>";      echo "</td>
</tr>
";  }     $result4 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$row3['id']."'");    $rows4 = mysql_fetch_assoc($result4);   if ($rows4['id'] == 0) {        echo"<img src=\"icon.gif\" border=0 align=\"center\">"; } else {  echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$rows4['id']."'"; echo ""; echo "

<tr>
<td>";     echo "</td>
</tr>
";    }   $result5 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$rows4['id']."'");    $rows5 = mysql_fetch_assoc($result5);   if ($rows5['id'] == 0) {        echo"<img src=\"icon.gif\" border=0 align=\"center\">"; } else {  echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$rows5['id']."'"; echo ""; echo "

<tr>
<td>";      echo "</td>
</tr>
";    }   $result6 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$rows5['id']."'");    $rows6 = mysql_fetch_assoc($result6);   if ($rows6['id'] == 0) {        echo"<img src=\"icon.gif\" border=0 align=\"center\">"; } else {  echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$rows6['id']."'"; echo ""; echo "

<tr>
<td>";      echo "</td>
</tr>

";    }   $result7 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$rows6['id']."'");    $rows7 = mysql_fetch_assoc($result7);   if ($rows7['id'] == 0) {        echo"<img src=\"icon.gif\" border=0 align=\"center\">"; } else {  echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$rows7['id']."'"; echo ""; echo "

<tr>
<td>";     echo "</td>
</tr>

";    }   $result8 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$rows7['id']."'");    $rows8 = mysql_fetch_assoc($result8);   if ($rows8['id'] == 0) {        echo"<img src=\"icon.gif\" border=0 align=\"center\">"; } else {  echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$rows8['id']."'"; echo ""; echo "

<tr>
<td>";      echo "</td>
</tr>
";    }   $result9 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$rows8['id']."'");    $rows9 = mysql_fetch_assoc($result9);   if ($rows9['id'] == 0) {        echo"<img src=\"icon.gif\" border=0 align=\"center\">"; } else {  echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$rows9['id']."'"; echo ""; echo "

<tr>
<td>";     echo "</td>
</tr>
</tbody>
</table>
";  }    ?>

Folks,

 

I managed to get this piece of code working.

But I need you to check if it is buggy or in error or not.

I will add VALIDATION later. Just let me know is this how you query db with mysqli_stmt_bind_result (prepared statement using procedural style) and display results on screen ?

Don't worry about pagination. i will add that later. Just let me know if I got the basics correct or not to display results from db or not. That is all.

Note my comments in CAPITALS. They are questions to which I need answers.

conn.php

	<?php
	$db_server = 'localhost';
$db_user = 'root';
$db_password = '';
$db_database = 'test';
	$conn = mysqli_connect("$db_server","$db_user","","$db_database");
	//SHOULD I KEEP FOLLOWING 1 LINE INTACT HERE OR DUMP IT TO main file search.php ?
$conn->set_charset('utf8mb4');//Always use Charset.
//HOW TO CONVERT ABOVE LINE TPO PROCEDURAL ?
	if (!$conn)
{
    //HOW TO WRITE CODE SO FOLLOWING TECHNICAL ERROR IS WRITTEN TO ERROR FILE AND NOT SHOWN TO USER ?
    //Error Message to show user in technical/development mode to see errors.
    die("Database Error : " . mysqli_error($conn));
	    //Error Message to show User in Layman's mode to see errors.
    die("Database error.");
    exit();
}
	?>
	

Q1. Do not forget to answer my question you see in CAPITALS in above code (conn.php).

Check the search.php before replying.

 

error_reporting.php

	<?php
ini_set('error_reporting','E_ALL');
ini_set('display_errors','1');
ini_set('display_startup_errors','1');
error_reporting(E_ALL);
	//SHOULD I KEEP FOLLOWING 1 LINE INTACT HERE OR DUMP IT TO main file search.php ?
mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);
?>
	

Q2. Do not forget to answer my question you see in CAPITALS in above code (error_reporting.php).

Check the search.php before replying.

 

 

 

search.php

	<?php
//include('error_reporting.php');
error_reporting(E_ALL);
ini_set('error_reporting',E_ALL);
ini_set('display_errors','1');
ini_set('display_startup_errors','1');
?>
	<form name = "search" method = "POST" action="">
<label for="keywords">Keywords:*</label>
<input type="text" name="keywords" id="keywords" placeholder="Input Keywords" required>
<br>
<button type="submit">Submit</button><br>
<button type="submit" value="submit">Submit</button><br>
<input type="submit" value="submit"><br>
<button name=submit value=" ">Search</button><br>
<button type="submit" name="submit" value="submit">Search</button>
<br>
<input type="reset">
<br>
</form>
	<?php
	if($_SERVER['REQUEST_METHOD'] === 'POST')
{
    if(ISSET($_POST['submit']))
    {
        if(ISSET($_POST['keywords']))
        {
            $keywords = $_POST['keywords'];
        }        
        
        //SHOULD I KEEP FOLLOWING 1 LINE INTACT HERE OR DUMP IT TO error_reporting.php ?
        mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);        
        
        //SHOULD I KEEP FOLLOWING 5 LINES INTACT HERE OR DUMP IT TO conn.php ?
        $conn = mysqli_connect("localhost","root","","test");
        $conn->set_charset("utf8mb4");
        if(mysqli_connect_error())
        {
            echo "Could not connect!" . mysqli_connect_error();
        }
	        $query = "SELECT page_url,link_anchor_text,page_description,keyphrases,keywords FROM links WHERE keywords = ?";
	        $stmt = mysqli_stmt_init($conn);
	        //FIRST ATTEMPT TO DISPLAY TBL RESULTS USING mysqli_stmt_bind_result() FUNCTION. TEST RESULT: ATTEMPT A FAILURE!
        if(mysqli_stmt_prepare($stmt,$query))
        {
            mysqli_stmt_bind_param($stmt,'s',$keywords);
	            $stmt_execution = mysqli_stmt_execute($stmt);
            if($stmt_execution === FALSE)
            {
                printf("Error: %s.\n", mysqli_stmt_error($stmt));
                printf("Error: %d.\n", mysqli_stmt_errno($stmt));
                die;
            }
            
            $bind_result = mysqli_stmt_bind_result($stmt,$page_url,$link_anchor_text,$page_description,$keyphrase,$keywords);
            if($bind_result === FALSE)
            {
                printf("Error: %s.\n", mysqli_stmt_error($stmt));
                printf("Error: %d.\n", mysqli_stmt_errno($stmt));
                die;
            }
            
            $stmt_fetch = mysqli_stmt_fetch($stmt);
            if($stmt_fetch === FALSE)
            {
                printf("Error: %s.\n", mysqli_stmt_error($stmt));
                printf("Error: %d.\n", mysqli_stmt_errno($stmt));
                die;
            }
            
            while(mysqli_stmt_fetch($stmt))
            {
                echo "$page_url"; echo "<br>";
                echo "$link_anchor_text"; echo "<br>";
                echo "$page_description"; echo "<br>";
                echo "$keyphrase"; echo "<br>";
                echo "$keywords"; echo "<br>";
                echo "|";
                echo "<br>";
            }
            
            mysqli_stmt_close($stmt);
            mysqli_close($conn);
        }
        else
        {
            die("QUERY failed!)";
        }
	

 

Q3. Anything I should know ?

Edited July 17, 2020 by 2020

Good Evening,

What I am trying to do in here is to display data based on my selected option in the drop down list. I don't have submit button, I just want it to automatically display results based on my selection. Here's my code:

<link href="add_client.css" rel="stylesheet" type="text/css">

<?PHP
include("dbconnection.php"); //Include database connection to file

$query = "SELECT * FROM records";

if(isset($_POST["territory"]))

{
$query .= " WHERE territory LIKE '%".$_POST["territory"]."%' ORDER BY territory ASC LIMIT 0,15"  ;
$result = mysql_query($query, $connection) or die(mysql_error());

} 

 

?>

<!-- Start of table -->
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<td>
      <table width="760" border="0" cellpadding="0" cellspacing="0">
        
<!-- Table data containing the Asia Logo -->
            <td width="199" align="center" valign="top">
                <a href="login.html">
                 <img src="asia.gif" alt="" width="152" height="58" border="0" />
                </a>
            </td>
            <!-- Table data containing Home button -->
            <td width="176" align="right" valign="bottom">
                <a href="main.php">
                 <img src="Home.jpg" width="104" height="20" border="0"/>
                </a>
            </td>
            <!-- Table data containing View Client button -->
            <td width="130" align="right" valign="bottom">
                <img src="View.jpg" width="104" height="20" border="0"/>
            </td>
            <!-- Table data containing the Add Client button -->
            <td width="146" align="right" valign="bottom">
                <a href="add_client.php">
                 <img src="Add.jpg" width="104" height="20" border="0"/>
                </a>
            </td>
            <!-- Blank table data -->
            <td width="109" align="right" valign="bottom">&nbsp;
            
            </td>
        </table>

        <!-- Table design division and body-->
        <table width="760" border="0" cellpadding="0" cellspacing="0">
     <td width="200" height="3"  bgcolor="#1B1C78">
     <img src="images/topspacerblue.gif" alt="" width="1" height="3" /></td>
    <td width="560"  bgcolor="#0076CC">
     <img src="images/topspacerlblue.gif" alt="" width="1" height="3" /></td>
    <tr>
    <td height="500" colspan="2" align="center" valign="top"  bgcolor="#F3FAFE">
            <!-- Page contents -->
            <!-- Search Query -->
            <br>
            <form name="form" action="trustlist.php" method="post">
            <table width="293" border="0">
<tr>
                    <td width="140" align="left" valign="middle">
                        SEARCH RECORD:
                    </td>
                    <td width="143" align="center" valign="middle"><select name="territory" id="territory" style="width: 143px" width="230">
                      <option selected="selected" disabled="disabled">Select Territory</option>
                      <option>Territory 01</option>
                      <option>Territory 02</option>
                      <option>Territory 03</option>
                      <option>Territory 04</option>
                      <option>Territory 05</option>
                      <option>Territory 06</option>
                      <option>Territory 07</option>
                      <option>Territory 08</option>
                      <option>Territory 09</option>
                      <option>Territory 10</option>
                    </select></td>
                </tr>
</table>
            <br>
            <!-- End of search query-->
            <!-- Start of Search Results-->
            <table border="0" cellpadding="3" cellspacing="1" bordercolor="38619E" >
                <tr>
                    <th width="148" align="center" bgcolor="#E0E8F3">Acute Trusts</th>
                    <th width="262" align="center" bgcolor="#E0E8F3">Employer</th>
                    <th width="160" align="center" bgcolor="#E0E8F3">Name</th>
                    <th width="80" align="center" valign="middle" bgcolor="#E0E8F3">&nbsp;</th>
                </tr>
<?php
if($result)
{
for($i=0; $i<mysql_num_rows($result); $i++)
   {
$id = trim(mysql_result($result, $i, "id"));
$territory = trim(mysql_result($result, $i, "territory"));
$employer = trim(mysql_result($result, $i, "employer"));
$first_name = trim(mysql_result($result, $i, "first_name"));
$last_name = trim(mysql_result($result, $i, "last_name"));
  
echo "<tr>";
   echo "<td>".$territory."</td>";
   echo "<td>".$employer."</td>";
   echo "<td>".$last_name.", ".$first_name."</td>";
   echo "<td><a href='edit_client.php?id=".$id."'>edit</a> | <a href='delete_client.php?id=".$id."'>delete</a></td>";
   echo "</tr>";
}   
}  
?>

</table>
            </form>
            <!-- End of page -->
            </td>
          </tr>
        </table>
</td>
<tr>
     <td height="38">
         <table width="760" border="0" cellpadding="0" cellspacing="0">      
         <td width="200" height="35" align="center"  bgcolor="#1B1C78" class=white>
         <a href="disclaimer.html">
             <font color="#FFFFFF">Legal Disclaimer</font>
             </a>
         </td>
         <td width="560" align="center"  bgcolor="#0076CC">
         Copyright &copy; 2006 - 2010 AsiaLimited. All rights reserved.
         </td>
</table></td>
</tr>
</table>

 what I need is for a loop to run to make tabbed pannels according to categories.  then I need the buttons to be put into the correct tab based on the category it falls under.  then a subcategory tabs inside the other tabs for products that have that specific sub category.

here is what I sorta made....it doesn't work though....

Code: [Select]
<div id="TabbedPanels1" class="TabbedPanels">
        <ul class="TabbedPanelsTabGroup"><?php $sql = mysql_query("SELECT * FROM categories");
while($row = mysql_fetch_array($sql)){
$category = $row["category"];
$sub =$row["subcategory"];
?>
         
<li class="TabbedPanelsTab" tabindex="0"><?php echo $category; ?></li>
<div class="TabbedPanelsContentGroup">
<div class="TabbedPanelsContent">
 <?php
// set layout vars
$x = 1; // set $x
$start = array ('1', '10', '19', '28', '37', '46', '55', '64', '73', '82', '91', '100', '109', '118', '127', '135'); //columns will be started at each of these numbers
$end = array( '9', '18', '27', '36', '45', '54', '63', '72', '81', '90', '99','108','117', '126' ); // set numbers to end columns at
?>

        <?php echo '<table border="1px" cellpadding="0px" cellspacing="0px" ><tr height=\'50px\'>'; //start the table, and the row.
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM products where category=".$category."");
while($row = mysql_fetch_array($sql)){
$product = $row["product"];
$id =$row["id"];
$price =$row["price"];
if (in_array($x, $start)) { // if x equals a number in the start array
echo '<td width="100">';                   // start a column
} ?>

     <?php $sql = mysql_query("SELECT * FROM categories");
while($row = mysql_fetch_array($sql)){
$category = $row["category"];
$sub =$row["subcategory"];
?>
         
<?php
}
?>
     
       
    <div id="products">
      <form action="" method="POST" name="myform<?php echo $id; ?>" class="myform<?php echo $id; ?>">
        <input type="hidden" name="hiddenField" class="hiddenField" value="<?php echo $product; ?>" />
        <input type="hidden" name="hiddenField2" class="hiddenField2" value="<?php echo $id; ?>" />
        <input type="hidden" name="hiddenField1" class="hiddenField1" value="<?php echo $price; ?>" />
      <input type="submit" name="submit" class="submit" value="<?php echo $product; ?>" style="background-color:lightgreen; height:50px; padding: 0px; margin:0px; width:100px;">   </form>
    </div>   
<?php
if (!in_array($x, $end)){ // if $x equals anything OTHER than 9, 18, etc - put in a line break
} else { // else if it DOES equal 9, 18 ,etc end the column
echo '</td>';
}
$x ++; // increase x to keep count
} // while loop ends
//now outside of the loop, 
$x = $x - 1; //subtract the last $X++ so you know exactly how many buttons were added
if (!in_array($x, $end)){ // if $x equals anything OTHER than 9, 18, etc - end the column as it wouldn't have ended itself
echo '</td>';
}
echo '</tr></table>'; // close the row and table

?><?php
}
?>             </div>     

   </ul>
       
      </div> 
any help is greatly appreciated.

Hello all. I'm using this code to go through the database and output certain user-defined numbers

Code: [Select]
<?php
mysql_connect ("pdb1.awardspace.com", "anastasov_db","moscow1945")  or die (mysql_error());
mysql_select_db ("anastasov_db");
 
$term = $_POST['term'];
 
$sql = mysql_query("select * FROM countries WHERE cocode = '$term'");
 
while ($row = mysql_fetch_array($sql)){
    echo '<br/> Code: '.$row['cocode'];
    echo '<br/> Country: '.$row['coname'];
    echo '<br/><br/>';
    }
 
?>
Now how would I go about making a page that appears if the script can't find any results in the database?

Thank you in advance

Hey all.

I have a query that selects data from a datbase based on a criteria.  Easy enough.   But now I am growing and the amount displaying is too much.

How can you, via php, have a queries result be displayed only so many at a time and auto create links that show the rest?  Like if query returns 82 results, I want it to display 25 immediately and create 3 links at the bottom.  The next link would show 26-50.  The next 51-75.  And the final 76-82.  etc

Example:
Code: [Select]
$result = mysql_query("SELECT * FROM pay");
$num_rows = mysql_num_rows($result);


while($row = mysql_fetch_array($result))
  {
echo $row['first_name'];
echo $row['last_name'];
echo $row['item_name'];
echo $row['option_selection1'];
echo $row['payment_date'];
echo $row['stat'];
}


This is simple.  But what happens when the results are 125?  I want to limit it to displaying 25 at a time.

Is the only way to manually create seperate pages and have each one show 1-25, then 26-50, etc?

Or is there a way to have the script do it, itself?  Any tutorials out there on this specifically?  Hopefully I am making sense.

Thanks!

I am pulling some info from a mysql table, checking some logic, and displaying in on a page. The way this is written now it shows all of the items in a one column table, I simply want to break it up into multiple columns (ideally by specifying say 20 items per column). I know I need a counter and a loop but I'm just not sure how it all fits in with my existing program. Any help would be greatly appreciated.

Here is my code
Code: [Select]
$result2 = mysql_query("SELECT * FROM propertyids ORDER BY propertyname ASC");
while($row2 = mysql_fetch_array($result2)){
${'resp'.$row2['id']} = curl_multi_getcontent(${'ch'.$row2['id']});
${'status'.$row2['id']} = strpos(${'resp'.$row2['id']},$httpvar);
if(${'status'.$row2['id']} === false) {
echo "<tr><td>";
echo "<img src='images/down.png'> <a href='" . $row2['primaryurl'] . "' target='_blank'>" . $row2['propertyname'] . "</a>";
echo "</td></tr>";
}
else {
echo "<tr><td>";
echo "<img src='images/up.png'> <a href='" . $row2['primaryurl'] . "' target='_blank'>" . $row2['propertyname'] . "</a>";
echo "</td></tr>";
}
}
echo "</td></table>";

EDIT: sorry - new to posting guidelines - using XAMPP with mysql 5.1.44 (I think this is correct!!)

Newbie question he I have successfully created a form that that displays students (based on a selected lesson/group/date) with the ability to enter scores.

I'm now trying to set the form up so that if data already exists then it is displayed in the form.

Eg: if a member of staff choses group 7AS, lesson 1, 24/09/2010 and another member of staff has entered a score already for one student it shows up in the <select> drop down by using
Code: [Select]
<option>" . $scorevalue . "</option>

I had this working at one point but have made a change somewhere and cannot get it working again! can anyone spot an obvious mistake I am making?

The code I am using is as follows:
Code: [Select]
<input type="hidden" name="tutor" value="<?php echo $_GET["tutor"]; ?>" />
<input type="hidden" name="date" value="<?php echo $_GET["date"]; ?>" />
<input type="hidden" name="lesson" value="<?php echo $_GET["lesson"]; ?>" />


<?php

error_reporting(-1);

$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("lakeside", $con);

$result = mysql_query("SELECT students.admin, students.fname, students.surname, students.tutor
FROM students
WHERE tutor='$_GET[tutor]' 
ORDER BY students.tutor, students.surname");


echo "<table class='scores'>
<tr>
<th>Admin</th>
<th>Firstname</th>
<th>Surname</th>
<th>Tutor</th>
<th>Score</th>
<th>Code</th>
<th>Comment</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  
$sqlstatement = "SELECT * FROM scores where admin = '" . $row['admin'] . "' and lesson = '" . $_GET[lesson] . "' and date = '" . $_GET[date] . "' ";
$scorevalue = mysql_query($sqlstatement);  



echo " . $score . ";

while($rowvalue = mysql_fetch_array($scorevalue))
{
$score = $rowvalue['score'];
$comment = $rowvalue['comment'];
$code = $rowvalue['code'];
}
  
  
  echo "<tr>";
  echo "<td>" . $row['admin'] . "</td>";
  echo "<td>" . $row['fname'] . "</td>";
  echo "<td>" . $row['surname'] . "</td>";
  echo "<td>" . $row['tutor'] . "</td>";

  echo "<td><select name='score"  . $row['admin'] . "' value='{$row['score']}' />
   <option>" . $scorevalue . "</option>
   <option>0</option>
   <option>1</option>
   <option>2</option>
   <option>2.5</option>
   <option >3</option>
   <option>3.5</option>
   <option>4</option>
   </select>
   </td>";

I am trying to display certain MySQL data based off of what link is clicked. For example.. I want to display all the entries from 2009 when a link for 2009 is clicked; maybe like..
<a href="http://website.com/page?yr=09">2009</a>
But I am having trouble doing so.. any help would be great!

P.S. The years are in my database with only the last two numbers.. 10, 09, 08, etc.

    $result = mysql_query("select setlist_id, month, day, year, name, venue, location, label1, set1, set2, set3, encore, notes, photos, recording, poster
        from $database_table order by setlist_id DESC, year, month, day",$db) 
        or die_now("Could not select setlists");

    while($row = mysql_fetch_array($result)) {
     $the_id = $row["setlist_id"];
        $the_month = $row["month"];
        $the_day = $row["day"];
        $the_year = $row["year"];
$the_name = $row["name"];
$the_venue = $row["venue"];
        $the_location = $row["location"];
        $the_label1 = $row["label1"];
$the_set1 = $row["set1"];
$the_set2 = $row["set2"];
$the_set3 = $row["set3"];
$the_encore = $row["encore"];
$the_notes = $row["notes"];
$the_photos = $row["photos"];
$the_recording = $row["recording"];
$the_poster = $row["poster"];

                echo("<div class='date' id='date' tabindex='0'>" . "$the_month" . "." . "$the_day" . "." . "$the_year" . " - ");
echo ($the_name != '') ? "" . "$the_name" . " - " : '';
echo("" . "$the_venue" . " - " . "$the_location" . "</div>");
                echo("<div class='set'>" . "$the_label1" . ":<br /></div><div class='list'>" . "$the_set1" . "<br /></div>");
                echo ($the_set2 != '') ? "<div class='set'>Set Two:<br /></div><div class='list'>" . "$the_set2" . "<br /></div>" : '';
echo ($the_set3 != '') ? "<div class='set'>Set Three:<br /></div><div class='list'>" . "$the_set3" . "<br /></div>" : '';
echo ($the_encore != '') ? "<div class='set'>Enco <br /></div><div class='list'>" . "$the_encore" . "<br /></sdiv>" : '';
                echo("<div class='line'></div>");
                echo nl2br("<div class='notes'>" . "$the_notes" . "</div>");
}

When I replace the $result line with...
    $result = mysql_query("SELECT * FROM `$database_table` WHERE `year` = '09' order by setlist_id DESC, year, month, day",$db) 
        or die_now("Could not select shows");... I get all the results from just 2009, which is what I want, but I want the results to depend on what link has been clicked. I hope I am making sense.

I have a program which have written with c+ +. This program is a generic server stats program for all Silkroad versions. ( Silkroad = MMORPG game like WoW ). " So if you have a website, you can upload the file via FTP to your own directory and write a simple PHP script or ASP script to parse the file and display the results. Or, you can post the data via PHP via a web URL. "
I need to make this what i write that write the results.

This write the following data:
Code: [Select]
Server Id
Server Name
Current Players
Max Players
State (1 = open, 0 = check)

For example:
2
220
Zeus
354
2500
1
221
Venus
539
2500
1
And save this data to any.txt file.

Here is the site:
http://www.error-soft.net/forum/prvsro.php

u need to se the server stats :
Server Name Players State Status
Total Capacity 2059 / 6000 [34%]
ZSZC(Fire) 0 / 2000 Empty Offline
ZSZC (Water) 2059 / 2000 Full Online
ZSZC (Retro) 0 / 2000 Empty Offline

i have the program what check the server and write this information to text file, but i do not know how can i parse this information like this website.

Hello everyone,

Very new to coding - enjoying it but struggling! I think I'm trying to do something pretty common but I seem to have come up against a complete wall now and after hours/days searching the internet and reading books I'm completely stuck! I'm  trying to write some code to search a MySQL database of products, then display the results. For some search results there will be lots of products so I want to display 10 products on the first page then allow visitors to go to the next page to see another 10, and so on - a type of pagination, as they should then be able to click back to see the last page etc.
I've got to the point of being able to display the first 10 search results, but I can't figure out at all how to create some kind of page scrolling/pagination system.
Please, does anybody have any ideas??
I've attached my code, I hope this is the correct way of doing things here.
Many thanks for your time!

The PHP search code...
Code: [Select]

<?php
//opens connection to mysql server
$dbc = mysql_connect('localhost');
if (!$dbc) {
die('Not connected :' . mysql_error());
}
echo "Connected to mysql database<br />";
//select database
$db_selected = mysql_select_db("NAME_OF_DATABASE", $dbc);
if (!$db_selected)
{
die ("Cannot connect :" . mysql_error());
}
echo "Connected to database<br /><hr />";
echo "Here are your results";

$term = $_POST['term'];
$category = $_POST['category'];
$brand = $_POST['brand_name'];
 
  
$sql = mysql_query("SELECT * FROM products where product_name like '%$term%' AND category_name like '%$category%' AND brand_name like '%$brand%' LIMIT 0, 10");
 
{ 
while ($row = mysql_fetch_array($sql)){
echo "<table border='1' width='100%'> ";
echo "<tr>"; 
echo "<td style='vertical-align:top' width='25%'>" . '<img src="', $row['image_url'], '" alt="', $row['product_name'], '"  width="100" height="100" />' . "</td>";
echo "<td style='vertical-align:top' width='50%'>" . $row['product_name'];
echo "<br />";
echo  "<span style='font-size: 10px'>" . $row['description'] . "</span>" . "</td>"; 
echo "<td style='vertical-align:top' width='25%'>" . $row['price'];
echo "<br />";
echo "<br />";
echo "<hr />";
echo "$row['merchant_name'] </td>";
echo "</tr>";
    }
echo "</table>"; 
}
?>

I have no clue about to go abt this one:
I have  form which has some:
Code: [Select]
<table>
   <tr>
     <td>
        <form>
         Title
        display info
         </form>
     </td>
   </tr>
</table>
I need to add an additional link next to title such that when someone clicks on the link the table expands and displays rsult of a query.

Code: [Select]
<table>
   <tr>
     <td>
        <form>
         Title          LINK
         if( link is clicked )
        {
           $query=select
           display query results
        }
        else
       {
         dont display query results
         display info
       }
         </form>
     </td>
   </tr>
</table>

 

I've got my code working OK in that the correct results are drawn from the database. What I have here in the code is an array consisting of an image, accompanied by its title and thirdly a link to activate a quiz associated with the image. Everything works fine, except because the page is dynamic, I always have an unknown number of sets of data (image, title and link) which I want to display so that each set of data takes up a new row.
The code I have here, while displaying the correct data, places all of the results into the same row.
Any suggestions are most welcome.
Code: [Select]
<?php
// Query the database
$query1 = mysql_query("SELECT title FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC"); 
$query2 = mysql_query("SELECT url_small FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC"); 
$query3 = mysql_query("SELECT title FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC");
while($row1 = mysql_fetch_array($query3))
{
$linkname .= $row1['title']."<br />\n";
}
?>
                  <table>
                    <tr>
                      <td>
                      <?php
                      while ($row2 = mysql_fetch_array($query2)) 
                      { 
                      $thumbnail.= $row2['url_small'];
                      echo "<img src='wood_tool_images/{$row2['url_small']}' alt='' /><br />\n";
                      }
                      ?>
                      </td>
                      <td height="200">
                      <?php
                      echo $linkname 
                      ?>
                      </td>
                      <td>
                      <?php
                      while ($row1 = mysql_fetch_array($query1)) 
                      { 
                      $quizname.= $row1['title'];
                      echo "<a href='../{$row1['title']} Safety Quiz/{$row1['title']} Safety Quiz.php'>Take This Quiz</a><br />\n";
                      }
                      ?>
                      </td>
                     </tr>
                  </table>