PHP - Best Way To Code Loops To Display Data - Noob

Basically I am trying to make a list of items which I have put into an sql database. When I click on an item in the list, I want a "generic" page loaded, with the items description. Im having alot of trouble with getting this generic page to work. Heres what Ive done so far.

The page with shows the list

http://pastebin.com/PE8FkyYQ
http://pastebin.com/GiCpV5AH

The generic page with the items description.

http://pastebin.com/HFnSfqN4
http://pastebin.com/C0zsHpZY

If anyone can help me solve this problem, ill be greatly in there debt!

In an .html, before : <!-- BEGIN myquery -->

I need to stop output and check the content of "myquery"

Is there a command for that ?

Thank You.

Hi all,

Just to check if it is possible to have 2 while loops in a single code? Below are my codes.


SQL code

$tutor_id = mysqli_real_escape_string($dbc, $_GET['tutor_id']);
    $query = "SELECT tl.level_id, tl.level_name,
                     ts.subject_id, ts.subject_name, tsl.subject_level_id, 
                     IF(tosl.tutor_id='{$tutor_id}', 1, 0) as checked
              FROM tutor_level AS tl
              INNER JOIN tutor_subject_level AS tsl
                  USING (level_id)
              INNER JOIN tutor_subject AS ts
                  USING (subject_id)
              LEFT JOIN tutor_overall_level_subject AS tosl
                  ON tosl.subject_level_id = tsl.subject_level_id
                  AND tosl.tutor_id = '{$tutor_id}'
              ORDER BY tl.level_id, ts.subject_name";
    $sql = mysqli_query($dbc, $query) or die(mysqli_error($dbc));

$query1 = "SELECT tl.level_id, tl.level_name,
                     IF(tslvl.tutor_id='{$tutor_id}', 1, 0) as checked
              FROM tutor_level AS tl
              LEFT JOIN tutor_selected_level AS tslvl
                  ON tslvl.level_id = tl.level_id
                  AND tslvl.tutor_id='{$tutor_id}'
              ORDER BY tl.level_id, tl.level_name";
    $sql1 = mysqli_query($dbc, $query1) or die(mysqli_error($dbc));

PHP code (2 while loops)

//Process the results
    $checkboxes = ''; //Create variable for output
    $current_level_id = false; //Flag to check when records change level
   while($data = mysqli_fetch_array($sql)) //Iterate throug the DB results
    {
        if($current_level_id != $data1['level_id']) //Determine if this level is different from the last
        {

print_r ($data);
            $checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);
            $current_level_id = $data['level_id'];
            $subject_data = array();
        }
        //Add the current record to the $level_data array
        $subject_data[] = $data;
    }

//$checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);

while($data1 = mysqli_fetch_array($sql1))

{

print_r ($data1);

$checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);
            $level_data = array();

$level_data[] = $data1;

}

    //Call the createLevelCheckboxes() function to generate the HTML for the LAST level records
    $checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);

This has probably been asked a bunch of times , but :

I only recently started to self learn PHP , and this small project i am making is quite a challange for me.
The scripts below are not realy writen by me , but i wished to tie them together to get a fully working code.

What is suppose to happen is :

In the form i wish to put a special button that puts extra input fields in the form.

After the form is submited ,with whatever amount of feilds in it, the data goes to a processing.php file that sorts all the info gathered and finaly sends all this data formated in to the last file that will be inluded in the index.php.

i already have the code for increcing the amount of inputs but the problem is , all inputs have the same names. Coz of that i get a mess.

What i need is each input to have a unique name or id , that way the processing file would receive different names(id's) with different values(what ever is writen in the inputs by users).

for example:

I have 2 enitial fields displayed on  form.html , i click the button "add new" 5 times and add 5 more input fields.
All this data must be sent to a process.php and on the output write all of this information formated in the last file in a row that will be displayed in the index by useing
<?include("blablabla.php");?>

The input increment is done by a java script. the problem is sending data with unique id(name) and receiving it.

The form file :

<?include("header.php");?>





 <?$i = 1; ?>

   <script type="text/javascript">

   function validate(frm)
   {
        var ele = frm.elements['feedurl[]'];

       if (! ele.length)
        {
            alert(ele.value);
        }

       for(var i=0; i<ele.length; i++)
       {
          alert(ele[i].value);
       }

      return true;
 }

  function add_feed()
 {
      var div1 = document.createElement('div');

     // Get template data
     div1.innerHTML = document.getElementById('newlinktpl').innerHTML;

     // append to our form, so that template data
     //become part of form
     document.getElementById('newlink').appendChild(div1);

 }


   var ct = 1;

   function new_link()
   {
   ct++;
  var div1 = document.createElement('div');
  div1.id = ct;

  // link to delete extended form elements
 var delLink = '<div style="text-align:right;margin-right:65px"><a href="javascript:delIt('+ ct +')">Del</a></div>';

 div1.innerHTML = document.getElementById('newlinktpl').innerHTML + delLink;

document.getElementById('newlink').appendChild(div1);

}
 // function to delete the newly added set of elements
 function delIt(eleId)
 {
d = document;

var ele = d.getElementById(eleId);

var parentEle = d.getElementById('newlink');

parentEle.removeChild(ele);

}
 </script>


<TABLE>
<style>
#newlink {width:600px}
 </style>
    <form action='sendorder.php' method='post'>
        <div id="newlink">
 <div>
<table align="center" border=0>
   <TR><TD><B>Product:</B> </TD><TD><input type=text name=prodname1 value="<?=$_GET['prodname1'];?>">&nbsp;</TD>
        <TD><B>Price:</B> </TD><TD><input type=text name=price1 value="<?=$_GET['price1'].$curency;?>"><b>%</b></TD></TR>
 </table>
 </div>

  </div>


     <p>
        <br>
         <input type="submit" name="submit1">
        <input type="reset" name="reset1">
    </p>

         <p id="addnew"></p>
     <FORM>
<INPUT type="button" value="Add New" name="button2" onClick="javascript:new_link()">
</FORM>

</form>

 <!-- Template -->
 <div id="newlinktpl" style="display:none">
 <div>
 <table border=0>
     <TR><TD><B>Product:</B> </TD><TD><input type=text name=<?$_POST[++$i];?> value="<?$_GET[$i];?>">&nbsp;</TD>
        <TD><B>Price:</B> </TD><TD><input type=text name=<?$_POST [++$i];?> value="<?$_GET[$i].$curency;?>">&nbsp;</TD></TR>

    </form>
</TABLE>

<?include("footer.php");?>



in the code above i tryed to make the programm POST the numbers in the name increcing it by 1. But when i click submit i get offset error.

The processing file :

<?
$timestamp     =     strftime("%d-%m-%Y %H:%M:%S %Y");   // for later use (ignore it)
$i =1;
####################################################################################

if(($_POST['prodname']!="")&&($_POST['price']!="")){

    ############################################################
    $writetocsv = $_POST['prodname1'] . "," . $_POST['price1']"%" <BR> . $_POST[$i] . $_POST[$i];
             $fp = fopen("data/data.csv", "a");
             fwrite ($fp,$writetocsv);
             fclose ($fp);
                            echo "<script>alert('Data sent.')</script>";
}
else{
    echo "<script>alert('Error! Please fill the form!')</script>";
}
echo "<script>location.replace('index.php')</script>";
?>

Perhaps someone knows a easyer way , since i am not sure how to make stuff due to the lack of knowlage in php. I also tryed arrays but , as said before , too tough when you are a noob

Please help.

I hope no one rolls their eyes at me, lol, but I literally, just made my first PHP script, but I ran into a snag.   Okay so the code I did was   <!DOCTYPE html>
<html>
<body>

<?php

echo <h1>"my First PHP script"</h1>;

?>

</body>
</html>   but in firefox the outcome is always "my first PHP script?> I had added the h1 tags because it wouldn't print at all before I did. I'm trying to figure out what I did wrong.

Short of deleting, how do I comment out code like this :

<!-- IF not S_DISPLAY_RECENT -->
    <!-- INCLUDE portal/block/recent.html -->
<!-- ENDIF -->

Nesting <!-- -->
/*...*/
//

do not work.

Thanks

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=355144.0

Hi guys and girls im  a new guy on this forums  and im here to beg for a favor, for my school assignment i have to make a simple php script and i have no idea how to do that so, here i am what i need is basically a video store rental application that store staff would use.   Nothing fancy just that it works. We also got sakila-db to work with and use witch is 30% of my problem  if a got to make my own db i would not be quite as confused right now. Can any1 help me because im starting to panic.

i apologize if i posted in the wrong place.

im including small dijagram of how this thing is supposed to look any help would be appreciated.







[attachment deleted by admin]

I have the following code in html:

<html>
<head>
<script type="text/javascript">
<!--
function delayer(){
    window.location = "http://VARIABLEVALUE.mysite.com"
}
//-->
</script>
<title>Redirecting ...</title>
</head>
<body onLoad="setTimeout('delayer()', 1000)">



<script type="text/javascript">
var sc_project=71304545;
var sc_invisible=1;
var sc_security="9c433fretre";
</script>

<script type="text/javascript"
src="http://www.statcounter.com/counter/counter.js"></script><noscript>
<div
class="statcounter"><a title="vBulletin statistics"
href="http://statcounter.com/vbulletin/"
target="_blank"><img class="statcounter"
src="http://c.statcounter.com/71304545/0/9c433fretre/1/"
alt="vBulletin statistics" ></a></div></noscript>


</body>
</html>

Is a basic html webpage with a timer redirect script and a stascounter code.

I know a bit about html and javascript, but almost nothing about php.

My question is:

How a can convert this html code into a php file, in order to send a variable value using GET Method and display this variable value inside the javascript code where says VARIABLEVALUE.

Thanks in adavance for your help.

Hello.  What I have created is a menu with links.  The links will display content on the page from a database.  I have the links with id displayed, but nothing is displayed when the link is clicks.  I have seen isset() and $_GET used but not a form and I don't know how to change the code to allow the display of data using ID.

My site is local, and I am using XAMPP.

The database connections work.

This is my code:

// query
$query = "SELECT * FROM topmenu ORDER BY id ASC";
$row = $PDO->query($query);

....

<table class="topmenu">
  <tr>
    <td>
      <h1 class="siteName">site title</h1>
    </td>

    <?php
    foreach($row as $data) {
     ?>
    <td><a href="index.php?id=<?php echo $data['id']; ?>">
      <?php echo $data['menuheader']; ?>
      </a></td>
    <?php
              }
            ?>
  </tr>
</table>

As a beginner, I would appreciate any help, no criticism of my code please!  Also, is there a way of hiding the id in the url?

Thanks in advance.

Hi all.  The following is a function to get and display data.  However, I've hit a wall in my progress.  It's only printing out one field.  I need to have it print out every retrieved field.  Any help is appreciated.

function get_data($table_name){
$result=mysql_query("SELECT * FROM $table_name");
$num=mysql_num_rows($result);
$i=0;
while($i < $num){
$fields=mysql_fetch_field($result,$i);
$display_fields=mysql_result($result,$i,$fields->name);
echo $display_fields;
$i++;
};
};

I realized that (I think) I need the $display_fields var to be concatenated with the $i variable so there's a unique var name for each field retrieved from the mysql_fetch_field line.  Any ideas?

Hello,

I just reach the ultimate high in frustration because  i can not display all the data from my database in a table using php.

Im trying to display all the members from my database (id, username, email and account type) in my admin cp, and what is happening is that i am displaying all my data in one td.

(Ex, in the <td></td>, it will display all the usernames at once, rather than separating them).

Code: [Select]
<?php

include_once "../config.php";
include_once "admin_check.php";

$get_members = mysql_query("SELECT * FROM members ORDER BY id");

while ($row = mysql_fetch_array($get_members))
{
$id .= $row['id'];
$username .= $row['username'];
$account_type .= $row['account_type'];
$email .= $row['email'];
}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Welcome Admin!</title>
</head>

<body>

<h1>Welcome admin! <a href='../index.php'> Click here to go back! </a></h1>

<table cellspacing="5" cellpadding="5" style="border: black thin solid" align="center">

<tr>
<td>ID</td>
<td>Username</td>
<td>Email</td>
<td>Account Type</td>
</tr>

<tr>
<td><?php echo $id;?></td>
<td><?php echo $username;?></td>
<td><?php echo $email;?></td>
<td><?php echo $account_type;?></td>
</tr>

</table>


</body>
</html>

Now i tried making the table in the while loop, but i am also having the same problem. Please help.

I'm not sure what I'm doing wrong here...

This is my index

<html

<head>
<title>Admin applications</title>
</head>

<body text="#000000">


<center>
<?php
include("connect.php"); 


echo "<table cellpadding='3' cellspacing='2' summary='' border='3'>";

echo "<tr><td>Real name:<br><br>";
echo $row['real_name'];

echo "</td><td>Age:<br><br>";
echo $row['age'];

echo "</td><td>In-Game Name:<br><br>";
echo $row['game_name'];

echo "</td><td>Steam ID:<br><br>";
echo $row['steamid'];

echo "</td><td>Agreement:<br><br>";
echo $row['agreement'];

echo "</td><td>Will use vent:<br><br>";
echo $row['vent'];

echo "</td><td>Activity:<br><br>";
echo $row['activity'];

echo "</td><td>Why this person wants to be an admin:<br><br>";
echo $row['why'];

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

</center>
</body>

</html>


and this is my database connect

<?php  
$database="admin";  
mysql_connect ("localhost", "root", "waygan914");  
@mysql_select_db($database) or die( "Unable to select database");
mysql_query("SELECT * FROM applications");
?>


The database table "applications" has 8 fields, and 2 records, but when I view the page i get the table but no data:

I have a page in my admin control panel which allows for adding and editing an existing entry on the same page.

At the moment, it displays the entries on the page in a table like format.

After I edit an entry and hit Submit, I display a message on that page that says "Link updated successfully!", but the table on the page doesn't load the new entry until I refresh again -  obviously since the data isn't entered into the database until I hit the submit button to process the form.

But I'm wondering if it's possible to update the table on the page and display that new updated table all after hitting the submit button??