PHP - Dynamic Table Rows From A Exec() Function

I have a PHP script containing the function exec which works fine in PHP 4 in IIS 7 on Windows 7. However this function does not work in PHP 4 in IIS 5 on windows server 2003. But I have to make it work there because that is what we have on our web server.
Can someone provide a solution?

Hey guys I usually code in C and I started looking into PHP which I think is pretty good. I'm wondering if there's a function that can be used to execute a command from a remote server on my local machine???

As example if I'd like to have a PHP page/script running on my server which when logged onto would display me a page with buttons like "PING, NETSTAT, IPCONFIG, TRACERT" and when clicked on it would exec those commands but not on the server but from my machine??? So that I would get the PING from my local machine to google.com instead of from the server to google.com

??? making any sense ??? thanks

Im working on a site and particularly the photo gallery section. I want to display 9 images on 3 rows (3 per row).

And im stuck. Te only way i can get the images to show up not one on top of the other is by using a table. but how can i tell the table to only put 3 <td>'s then to <br>

Heres my code so far...
<?php
$sql_images = mysql_query("SELECT * FROM photos ORDER BY upload_date DESC LIMIT 9");

while($row = mysql_fetch_array($sql_images)){

$photo_id = $row["id"];
$location = $row["location"];

$display_pics .= '
<td width="125px">
<a href="image.php?id='. $album_id .'" class="black"><img src="images/uploads/thumbs/' . $location . '" /></a> 
</td>';
}
?>

Then to display it ...
Code: [Select]
    <table width="top" cellpadding="10" cellspacing="20">
        <tr>
            <?php echo $display_pics; ?>
            </tr>
        </table>

My goal is to do it as simple as possible!

Can anyone help?

If you don't think tables are the way to go im open to any suggestions.

I've thought about <divs> but then the images show up one on top of the other and not beside each other.

By the way all the images are a max of 100px heigh and 100px wide

Thanks for any help or suggestions!

Hey guys,

I got another one that i could use some help on.  I have a input form that utilizes a javascript that adds additional rows to my table.  here is a look at what i got.

Code: [Select]
<script type="text/javascript">
function insertRow()
{
    var x = document.getElementById('results_table').insertRow(-1);
    var a = x.insertCell(0);
    var b = x.insertCell(1);
    var c = x.insertCell(2);
    var d = x.insertCell(3);
    var e = x.insertCell(4);

    a.innerHTML="<input type=\"text\" name=\"id\">";
    b.innerHTML="<input type=\"text\" name=\"place\">";
    c.innerHTML="<input type=\"text\" name=\"username\">";
    d.innerHTML="<input type=\"text\" name=\"earnings\">";
    e.innerHTML="<input type=\"button\" value=\"delete\" onClick=\"deleteRow(this)\">";
}

function deleteRow(r)
{
    var i=r.parentNode.parentNode.rowIndex;
    document.getElementById('results_table').deleteRow(i);
}

</script>
this is my code stored in the header of my page.  basically just a button to add a new row and a button in each row to delete rows if needed.

here is a look at my html table, pretty basic...

Code: [Select]
<table id="results_table">

            <th>Event ID</th><th>Place</th><th>Username</th><th>Earnings</th>

            <tr>
                <td><input type="text" name="id"></td><td><input type="text" name="place"></td><td><input type="text" name="username"></td><td><input type="text" name="earnings"></td><td><input type="button" value="delete" onClick="deleteRow(this)"</td>
            </tr>

        </table>
Now what I am hoping to acheive is once i submit all of these rows to the database i will insert each of these rows into their own row in the database.  is this doable?

the structure of my database is:

ResultID (Primary Key)
Place
Earnings
UserID (Foreign Key)
EventID (Foreign Key)


now i think the biggest problem i'm having with submitting data to the database is that in the original HTML form I am typing in the actual username and not the userID. 

so when it comes to processing I need to do a switch of these two things before I run my query.  Should something like this work?

Code: [Select]

$username = $_POST['username'];

$userID = "SELECT userID FROM users WHERE username="$username";

$query = mysql_query($userID);



also i've never tried to submit multiple entries at a time.  maybe i have to create an array somehow in order to capture each rows data.  any thoughts?

as always thanks for the help.

I have 2 queries that I want to join together to make one row  

Morning

I have a table with many rows. Some of these rows have the same id number. I'm wondering how I print all the rows with the like id like so programing,design,help. My fucntion is below.

  function getPostTags($postid){
     
     $sql = mysql_query("SELECT tag FROM tags WHERE id=$postid") or die(mysql_error());
 if (mysql_num_rows($e)){
    extract(mysql_fetch_array($sql));
$tags[$postid]=array();
$tags[$postid]['tag'];

 }
 return $tags;
   }   

So if I do this <?php print $tags; ?> It only prints out one result from my table.

What do I have to do it get it to print all row field values from the table with a comma.

Right now the only way I can do this is instead of printing "$tags" (which only gives me one of the many values) I query the database again and do a while statement with
$row = mysql_fetch_array. This isn't the right way to do it.  Can someone help or give me some pointers?


Thanks for the help.

On my site, I currently have a page that lists my team's fixtures: http://www.cfrclunj.co.uk/fixtures.php

As can be seen, in between each separate month there is a row of blank, grey cells.

I am now updating the site so that it takes all information from a database (for easier update). On my test page (at bottom) I have recreated the fixtures table using my db: http://www.cfrclunj.co.uk/db_test.php

What I am wondering is if there is any way to get the grey monthly separater row into my table. Could this be done by inserting a row of data into the db table that uses an if statement to change it's appearance? Or could I somehow use MYSQL/PHP to make it put a row in for each separate month?

I have to admit my PHP and MYSQL skills are still at a very basic level, and so any help would be great!

I wonder if anyone can help me, I have a MySQL table of football teams (team_name; link; description; rival_1; rival_2; rival_3;) where each 'team_name' has its own page with the relevant information from the table and is named as the link field from the table. Within each team page I also want to display the rival_1,2 and 3 teams with links to their pages. I know how to just display the information but am struggling with picking up the link from the relevant row in the table. Is this possible or would I be better off just placing a <a href> link around each rival team when I enter it into the MySQL table??

I hope this makes sense, any help would be very much appreciated. Thanks

Hi,

I'm using a table to list results from a MySQL query.

I wanted to make the rows of the table alternate colours and found the following code on this website which does the job perfectly:

$counter++;
$bgcolor = ($counter % 2)?"#e8edff":"#ffffff";

echo "<tr class='border'>\n
<td bgcolor='".$bgcolor."'>$n</td>\n
<td bgcolor='".$bgcolor."'>$player</td>\n
<td bgcolor='".$bgcolor."'>$score</td>\n
</tr>\n";

On my webpage i have six tables listing results from six MySQL queries and i use the above code after each query to construct the table and alternately colour the rows blue then white.

My problem arises when there are an odd number of rows in the first table.  This results in the first row of the second table being coloured white, not blue.

I would like the first row of each table to be blue.

Is there a simple way to reset the counter for each table?  Any advice much appreciated.

Thanks.

Hi all,
I have a data base with the following table:

---member_data---
id ^ mid ^fieldname^ fieldvalue
1 - 2 - applicant - Seth Smith
2 - 4 - firstname - Chris
3 - 4 - lastname - Cooper
4 - 7 - full_name - Joey Jones
5 - 7 - occupation - Programmer
6 - 7 - phone - 800-555-1212


And below is a snippet that I use to display the selected members data for editing

-------------------------------
<table>
<tr>
<td>Name:</td>
<td>Value:</td>
</tr>
<?php

$query = "SELECT * FROM member_data WHERE mid='$mid'";
$result= mysql_query($query);
  while($row = mysql_fetch_array($result)) {

      $fieldname = $row["fieldname"];
      $fieldvalue = $row["fieldvalue"];

?>
<tr>
<td><input type="text" name="<?php echo $fieldname;?>" value="<?php echo $fieldname;?>"></td>
<td><input type="text" name="<?php echo $fieldvalue;?>" value="<?php echo $fieldvalue;?>"></td>
<?php } ?>
</tr>
</table>
-------------------------------

My question is:

- using the Db example above:
- lets say Ive selected mid#7 (member id 7) to edit which is displayed using the snippet code from above.
- once displayed how do I edit  mid#7  given the fact that  mid#7  is located on 3 seperate rows from the same table?

Thank you,
Dave


*ALSO - I tried the snippet below which did Not work.

foreach($_POST as $key => $val) {
$sql = "UPDATE member_data SET fieldname='$key', fieldvalue='$val' WHERE mid='$mid'";
$result = mysql_query($sql);
}

Hi, I'm very new to these forums and php alike.  I've been working on this bit of code for weeks now.  I've written numerous versions and made endless revisions; trying pieces from many similiar source and well, it's still not quite working out for me.

The form I've been trying to finish will have multiple rows. The user will input values specific to each row, but I'm trying to make it so that each row is synonymous with each other in regard to the database table. Like an order form, an inventory form, or a roster. I'd really like to make this code work out because I can think of numerous applications for it's use. I'm sure others could use it for even more.

So, as you see; the html code represents the table that contains the form. Currently, I only have five of these rows in the form, but would like for anybody using the code to be able to add in code for as many rows in the table as needed.
Code: [Select]
<html>

<head>
  <title></title>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<FORM action="post_multiple.php" method="POST">
<table width="80%" border="1">
  <tr>
    <td>Vendor</td>
    <td>Item Description</td>
    <td>Quantity</td>
    <td>Price</td>
  </tr>
  <tr>
    <td><select name="vendor" id="vendor" >
<option value="other1">other1</option>
<option value="other2">other1</option>
<option value="other3">other3</option>
<option value="other4">other4</option>
<option value="other5">other5</option>
</select></td>
    <td><input name="description" type="text" id="description" size="50" /></td>
    <td><input name="quantity" type="text" id="quantity" size="50" /></td>
    <td><input name="price" type="text" id="price" size="50" /></td>
  </tr>
  <tr>
    <td><select name="vendor" id="vendor">
      <option value="other1">other1</option>
      <option value="other2">other1</option>
      <option value="other3">other3</option>
      <option value="other4">other4</option>
      <option value="other5">other5</option>
    </select></td>
    <td><input name="description" type="text" id="description" size="50" /></td>
    <td><input name="quantity" type="text" id="quantity" size="50" /></td>
    <td><input name="price" type="text" id="price" size="50" /></td>
  </tr>
  <tr>
    <td><select name="vendor" id="vendor">
      <option value="other1">other1</option>
      <option value="other2">other1</option>
      <option value="other3">other3</option>
      <option value="other4">other4</option>
      <option value="other5">other5</option>
    </select></td>
    <td><input name="description" type="text" id="description" size="50" /></td>
    <td><input name="quantity" type="text" id="quantity" size="50" /></td>
    <td><input name="price" type="text" id="price" size="50" /></td>
  </tr>
  <tr>
    <td><select name="vendor" id="vendor">
      <option value="other1">other1</option>
      <option value="other2">other1</option>
      <option value="other3">other3</option>
      <option value="other4">other4</option>
      <option value="other5">other5</option>
    </select></td>
    <td><input name="description" type="text" id="description" size="50" /></td>
    <td><input name="quantity" type="text" id="quantity" size="50" /></td>
    <td><input name="price" type="text" id="price" size="50" /></td>
  </tr>
  <tr>
    <td><select name="vendor" id="vendor">
      <option value="other1">other1</option>
      <option value="other2">other1</option>
      <option value="other3">other3</option>
      <option value="other4">other4</option>
      <option value="other5">other5</option>
    </select></td>
    <td><input name="description" type="text" id="description" size="50" /></td>
    <td><input name="quantity" type="text" id="quantity" size="50" /></td>
    <td><input name="price" type="text" id="price" size="50" /></td>
  </tr>
  <tr>
    <td><select name="vendor" id="vendor">
      <option value="other1">other1</option>
      <option value="other2">other1</option>
      <option value="other3">other3</option>
      <option value="other4">other4</option>
      <option value="other5">other5</option>
    </select></td>
    <td><input name="description" type="text" id="description" size="50" /></td>
    <td><input name="quantity" type="text" id="quantity" size="50" /></td>
    <td><input name="price" type="text" id="price" size="50" /></td>
  </tr>
</table>
<input type="submit" name="Submit" value="Submit" />
</FORM>

</body>
</html>

In the php script I've tried using the count, loop, if, several others functions to try to get it to insert all the completed rows from the form into the table but just can't seem to get it to work out.  Anyways, here's a representation of what i'd like to achieve.  Not necessarily the code I've written trying to accomplish this, I'd have to upload a book if that were the case.

<?php 
ini_set('display_errors','On'); 
error_reporting(E_ALL); 

$host="localhost"; // Host name  
$username="root"; // Mysql username  
$password="password"; // Mysql password  
$db_name="testing"; // Database name  
$tbl_name="test_multiple"; // Table name 

// Connect to server and select databse. 
mysql_connect("$host", "$username", "$password")or die("cannot connect");  
mysql_select_db("$db_name")or die("cannot select DB"); 

//declarations 
$vendor = $_POST['vendor']; 
$description = $_POST['description']; 
$quantity = $_POST['quantity']; 
$price = $_POST['price']; 

// Check if button name "Submit" is active, do this  
$sql1="INSERT INTO $tbl_name (vendor, description, quantity, price) VALUES ('".$vendor."', '".$description."', '".$quantity."', '".$price."')"; 
$result1=mysql_query($sql1); 

mysql_close(); 
?>


If anybody can suggest where I need to go with that, that would be great.  Like I said above, I've tried about everything I could find any reason to from forum threads I had found in google searches and whatnot.  Also, if there is a good article, link or tutorial that would address this that anybody knows about that would be great.  However, I'm not looking for a link to a product or plugin that will do this stuff for me.  I'm trying to get halfway decent at php and would like to have working code for myself to build upon, modify, and learn from.  Any help is greatly appreciated!!!!

Hi all,

So I'm not completely sure on how to do this, but basically this i what i want.

I want the users to be able to create "fields" in my table, so let's say we have a structure like this:

Field 1   Field 2   Field 3
Data 1   Data 2   Data 3

Problem is, that i want my users to update both the <td> and <tr> information via mysql, without altering the database.
And I'm not sure on how I can make sure, that everything gets out in the right order.

I have this so far:

Code: [Select]
<table id="sort-table">
<thead>
<tr>
<?PHP
echo ' <td> Identifier </td> ';

$result = mysql_query("SELECT * FROM fields ORDER BY `order`");
while($row = mysql_fetch_array($result))


{

echo ' <td> ' . $row["name"] . ' </td> ';
}
?>
<th style="width:128px">Options</th>

</tr>
</thead>
This will display the field 1, 2, 3 etc..

My problem is.. How do i get the content displayed in the right order to the right fields.. :/

I hope you understand me, if not, please tell me so I can elaborate ^_^
I know this might seems like a noob question, and I'm sorry that I couldn't search, but I didn't know what to search for.

hi

i have table in my database holding food items.

i need users to be able to order those items individually for example...if apples are third from the top..they should be able to move them up or down the list 1 place at a time perhaps with an up and down arrow.

i have a field in my table called item_order

the only problem is...users are going to be able to insert new items to the database...but i dont know how they can populate the order field...i cant set it to auto increment because the item_id is the primary key auto incrementing...how can i populate the order field?

and then once i have this problem sorted how do i then allow users to change this order?

im looking for code if possible please because ive spent WAY to long on this now and im struggling to grasp things people advise me to do. terminology and methods of accomplishing this are just going over my head.

please help.

Hi,

I have a problem regarding counting rows in a mysql table. Here is the code:

Code: [Select]
<?php
require_once('includes/connection.inc.php');
$conn = dbConnect('read');
$check = 'SELECT COUNT(*) FROM images';
$checkRes = $conn->query($check) or die(mysqli_error());
if($checkRes <= 0) { header('Location: empty_blog.php'); // redirect to another page
} else { // do something else... }
?>

The error I'm getting: "Notice: Object of class mysqli_result could not be converted to int in C:\xampp\htdocs\photoblog\index.php on line 6"

Any help is greatly appreciated!

I know how much you guys hate people asking for help without any starting code but I'm not even sure how to start this..

I want a script to read this page and count all the admins and referees.

If anyone is willing to help, here's a sample of the html code:
Code: [Select]
<div class="boxInner"><h3>Arena Referees</h3><table class="list"><thead><tr><th style="width:16px;"></th><th style="width:150px;">Name</th><th style="width:300px;">Position</th><th style="width="150px;">Gamertag</th></tr></thead><tbody><tr><td><a href="http://gamebattles.com/profile/GottaHaveFaith78"><img src="http://media.gamebattles.com/icons/16/profile.png" class="icon16" /></a></td><td class="alt1">Faith</td><td><b>Head Referee</B></td><td class="alt1">GB CombatBarbie</td></tr><tr><td class="alt2"><a href="http://gamebattles.com/profile/Jack.-"><img src="http://media.gamebattles.com/icons/16/profile.png" class="icon16" /></a></td><td>Jack</td><td class="alt2"><b>Asst. Head Referee</b></td><td>Get Jacked x</td></tr><tr><td><a href="http://gamebattles.com/profile/amghawk"><img src="http://media.gamebattles.com/icons/16/profile.png" class="icon16" /></a></td><td class="alt1">Mike</td><td><b>Asst. Head Referee (IS)</b></td><td class="alt1">GB amghawk</td></tr><tr><td class="alt2"><a href="http://gamebattles.com/profile/cory94bailly"><img src="http://media.gamebattles.com/icons/16/profile.png" class="icon16" /></a></td><td>Cory</td><td class="alt2">Referee</td><td>Cory xz</td></tr><tr><td><a href="http://gamebattles.com/profile/crago"><img src="http://media.gamebattles.com/icons/16/profile.png" class="icon16" /></a></td>

I'm just wondering how I could even count them.

Any help will be appreciated, thanks.