PHP - Program Php To Produce Html Output Using Tables To Render Results.

i have a php script:

$sql5 = "select *,count(*) from rc_language_type_assoc_table group by language_type_id";
$result5 = mysql_query($sql5);                                                 //not correct
$count5 = mysql_num_rows($result5);                                   //not correct

$myFile = "/home/rainbowcode/StatsFile.txt";
$fh = fopen($myFile, 'w') or die("can't open file");

fwrite($fh, $sql5."\n");



the above is not what i  want,   i want  the actual result set of the select to print in my StatsFile
how can i achieve this please???

Help please.. 50yr old PHP noob..
I have a PHP script that runs a personality survey and returns the dominant personality type, but I need to display the results as a bar chart reflecting the % totals for each of the 4 personality types.
Code is he http://codepad.org/wQN3qN3v Grateful for any help!

Hey Guys,

I'm struggling with some logic of how to do something wondering if anyone can point me in the right direction.

Details:
I am making a PHP/MySQL game to learn more PHP, I've got my login/logout system created. However I am planning on the game been map based on a 100x100 grid. I have two tables:

USERS
Username, Password, x, y
Test, Test, 1, 1


MAP
X, Y, type
0,1,1
0,2,1
0,3,2
0,4,3
0,5,2
etc

I am stuck on how to get the user's logged in X and Y coordinates and then compare them with the map table X and Y, to see what type of field to show, 1,2 or 3.

Is there a name for this type of function so I can do some research on it? Or could someone give me an example? Would be fantastic if anyone has any advice.

Thanks in advance
NewcastleFan

I have a variable called clientid being passed via a url. I place that in a variable called $clientid

I have two tables, client and web_info

I want to select all from client and web_info for the appropriate clientid. I may not have my tables set up correctly. The primary key on the table client is auto genereated and titled client_id the primary key on web_info is e_mail and I want to pull information from the table web_info where the e_mail columns match.

Below is my PHP:

$query = "SELECT * FROM client WHERE $clientid = client_id and FROM web_info WHERE client.e_mail = web_info.e_mail";
$result = mysqli_query($connection,$query);
$row = mysqli_fetch_array($result);

I know I probably screwed all this up but please help

I have a cart script, and I need to display the products the user has added.  This is a school assignment and I'm very stuck on this seemingly 'little' error.

Right now, I have two tables:

For time's sake, I am showing duplicate products with different prod_id's:
Table: products
prod_id category sub_category thumb_href image_href title desc summary manufacturer price 17 sofa leather red_leather_sofa_small.jpg red_leather_sofa_main.jpg Red Leather Sofa [BLOB - 134B] [BLOB - 59B] Balenty 999.99 18 sofa leather red_leather_sofa_small.jpg red_leather_sofa_main.jpg Red Leather Sofa [BLOB - 134B] [BLOB - 59B] Balenty 999.99 19 sofa leather red_leather_sofa_small.jpg red_leather_sofa_main.jpg Red Leather Sofa [BLOB - 134B] [BLOB - 59B] Balenty 999.99
And this is the cart table that holds temporary cart items (storing the product ID to pull later):
Table: cart
temp_cart_item cart_id (assigned by session_id() ) prod_id user_id 22 jier11u0e7cl2ghosjodpaark2 17 asdfasdf 23 jier11u0e7cl2ghosjodpaark2 17 asdfasdf 24 jier11u0e7cl2ghosjodpaark2 35 asdfasdf 25 jier11u0e7cl2ghosjodpaark2 5 asdfasdf 26 jier11u0e7cl2ghosjodpaark2 19 asdfasdf
SO, user 'asdfasdf' is logged in and has selected 5 items for his cart - two of which are the same (prod_id 17).  Basically,

I need to compare the prod_id's of each table and output all products (and quantities) matching the temporary cart prod_id.

What I have now to loop through and display the cart items are (bear with me):


echo "<h1>Cart</h1>";
}
// Display welcome and navigation links
displayWelcome();
displayNav();

// Getting the prod_id's from the table cart to compare with the product table
$cart_id = session_id();
$user_id = ($_SESSION['login_username']);
$query = "SELECT prod_id FROM cart WHERE cart_id='$cart_id' AND user_id='$user_id'";
$result = mysqli_query($cxn,$query) or die("<h2 class=\"warning\">Whoa! Problem with the cart script here!</h2>");
$nrows = mysqli_num_rows($result);
if($nrows < 1)
{
echo "<h2>Your cart is empty</h2><p><a href=\"catalog.php\">Go back to the catalog</a></p>";
}
else {  // Continue to gather products for all the product IDs in the products DB table...
echo "<h4>$nrows items in your cart</h4>";
while($row = mysqli_fetch_array( $result )) {
$user_id = ($_SESSION['login_username']);
$product = $row['prod_id'];

// Is the query my problem?
$query = "SELECT * FROM products WHERE prod_id='$product'";
$result = mysqli_query($cxn,$query) or die("<h2 class=\"warning\">Whoa! Problem with the cart script here!</h2>");
$nrows = mysqli_num_rows($result);
if($nrows < 1) { // If the item doesn't exist, display an error
echo "<h2>That is not a valid product, or any of the items you had in your cart are missing or have been deleted.</h2><p><a href=\"catalog.php\">Go back to the catalog</a></p>";
// Protect from continually displaying an error by deleting the invalid cart record
$deletequery = "DELETE FROM cart WHERE prod_id='$product'";
$deleteresult = mysqli_query($cxn,$deletequery) or die("<h2 class=\"warning\">Whoa! Problem with the cart script here!</h2>");
exit();
}
while($row = mysqli_fetch_array( $result )) {  //  Then disply them in a table
echo "<h2>Items in Your Cart:</h2>";
echo "
<table id=\"products\">
<thead>
<tr>
<th class=\"col1 headercol\" scope=\"col\">Thumbnail</th>
<th class=\"col2 headercol\" scope=\"col\">Summary</th>
<th class=\"col3 headercol\" scope=\"col\">Manufacturer</th>
<th class=\"col4 headercol\" scope=\"col\">Price</th>
</tr>
</thead>

<tbody>\n";
$query = "SELECT SUM(price) FROM products WHERE prod_id='$product' GROUP BY price";
$priceResult = mysqli_query($cxn,$query) or die("<h2 class=\"warning\">Whoa! Problem with the cart script here!</h2>");
// keeps getting the next row until there are no more to get
// Print out the contents of each row into a table
echo "<tr>
<td class=\"col1\">"; 
echo "<a class=\"imgHref\" href=\"detail.php?prod_id=".$row['prod_id']."\" title=\"".$row['title']."\"><img src=\"../images/".$row['thumb_href']."\" alt=\"".$row['title']."\" /></a>";
echo "</td>\n"; 
echo " <td class=\"col2\">"; 
echo "<h3 class=\"title\"><a href=\"detail.php?prod_id=".$row['prod_id']."\" title=\"".$row['title']."\">".$row['title']."</a> <span class=\"inlineh3\">by <a href=\"categories.php?manufacturer=".$row['manufacturer']."\" title=\"View all products by ".$row['manufacturer']."\">".$row['manufacturer']."</a></span></h3>";
echo "<p class=\"summary\">".$row['summary']."</p>
<p class=\"descHeading\">&#38;#9758; <em>Full Description:</em></p>
<p class=\"desc\">".$row['desc']."</p>";
echo "</td>\n"; 
echo " <td class=\"col3\">"; 
echo "<p class=\"manufacturer\"><a href=\"categories.php?manufacturer=".$row['manufacturer']."\" title=\"View all products by ".$row['manufacturer']."\">".$row['manufacturer']."</a></p>";
echo "</td>\n"; 
echo " <td class=\"col4\">"; 
echo "<p class=\"price\">$".$row['price']."</p>";
echo "</td>
</tr>\n"; 
}
while($priceRow = mysqli_fetch_array( $priceResult )) {
echo "<tr class=\"short\"><td class=\"col1\"><h3><a href=\"clear_cart.php\">Empty Cart</a></h3></td><td class=\"col2\"></td><td class=\"col3 nobackground\">Total:</td><td class=\"col4\">$".$priceRow[0]."</td></tr>";
}
echo "</tbody>
</table>";
echo "<p class=\"submitOrder\"><form action='submit_order.php' method='post' id='form'>
  <input type='submit' name='pButton' value='Submit Order'>
  <input name='order_total' type='hidden' id='order_total' value='".$priceRow[0]."' />
</form>
</p>";
}
}



And so the cart.php looks something like this (this example asdfasdf has 6 items in his cart):



So you can see that it only displays ONE item, even though asdfasdf DOES have 6 items in his cart (proven by checking database).  And the price is not accurate, either.

Can anyone help me in where my problem might be?  Is it my query?  Or my while clause?

I'm trying to do a following feed. This feed includes posts and comments that the user is following. The first 3 following types are in the content table and the last following type is in the comments table.   This query fetches the first 3 following types successfully.

$construct = $connectdb->prepare("SELECT parent.*
FROM `content` as parent
JOIN followers ftable on (
(ftable.parent_id=parent.sid AND ftable.userposts='1')
OR
(ftable.`parent_id`=parent.pageid AND ftable.topic='1')
OR
(ftable.parent_id=parent.pageid AND ftable.page='1')
) AND ftable.userid=:userid
WHERE parent.deleted='0'
GROUP BY parent.id
ORDER BY parent.posted DESC");

This query fetches the following comments type successfully

$construct = $connectdb->prepare("SELECT parent.*
FROM `comments` as parent
JOIN followers ftable on ftable.parent_id=parent.postid AND ftable.comments='1' AND ftable.userid=:userid
WHERE parent.deleted='0'
ORDER BY parent.posted DESC");

How do i combine the two queries? In this feed i want the results to be ORDER by posted DESC.

I am using multiple levels of JSON data coming into php from a C# application, as in: return new RootObject()
{
ID_Project = 4,
Name_Project = "Test",
Receiver_ID = 4,
Receiver_Name = "ABCDE",
UserID = 20,
UserRole = new User_Role()
{
ID_User = 20,
Role_User = "level 3",
User_Role_Description = "U",
UserGroup = new List<user_group>()
{
new User_Group() { ID_UserGroup = 30, Name_UserGroup = "usergroup8", UserID = 20 },
new User_Group() { ID_UserGroup = 31, Name_UserGroup = "usergroup9", UserID = 21 },
new User_Group() { ID_UserGroup = 32, Name_UserGroup = "usergroup10", UserID = 22 }
}
}
}; i am having troubles accessing the second level: UserRole and 3rd level: User_Group in my php script.
im currently trying like this: foreach ($phpArray as $key => $value) {
echo "<h2>$key</h2>";
foreach ($value as $k => $v) { echo "$k | $v
"; foreach ($v as $key1) { echo "$key1
";
}
}
}   does anyone have an idea? Thanks,
Revathy

This topic has been moved to MySQL Help.

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

I have the following four tables. The query below is supposed to retrieve all projects and related data in associated tables where the project has been archived (i.e., archive field in project_info table set to '1') and user ID = '599zxj'. 

Hey there. Not sure how to word this. I've been flying blind as a newbie trying to figure out some pagination for a left joined query. I've got syntax errors trying to set up the SELECT COUNT function that adds up the results of the search on a previous page so it knows how many results matched both tables.

Right now, I've got this mess, and it's giving me a syntax error,
"You have an error in your SQL syntax; .... near 'LEFT JOIN plantae ON (descriptors.plant_id = plantae.pla' at line 12"
Code: [Select]
$data = "Select (SELECT COUNT(*)
                    FROM
                        descriptors
                    ) AS
                        count1,
                (SELECT COUNT(*)
                    FROM
                         plantae
                    ) AS
                        count2

                    LEFT JOIN
                        plantae ON (descriptors.plant_id = plantae.plant_name)
                    WHERE
                        `leaf_shape` LIKE '%$select1%'
                        AND `leaf_venation` LIKE '%$select3%'
                        AND `leaf_margin` LIKE '%$select4%'";
                   
 
$result = mysql_query ($data);
if (!$result) {
    die("Oops, my query failed.  The query is: <br>$data<br>The error is:<br>".mysql_error());
}

For example with an IDE to run a program is there a way to put some code in the path and let it tell me where it came from like a referral?
For example lets say I am at pgm1.php and at the top of that program i put something like.

$ref = $_SERVER['HTTP_REFERER'];
echo("$ref<br>";

Result: https://www.mydomain.com/wp-admin/admin.php?page=lambo

As you can clearly see the page that we have entered the code in is referred by the URL here.

It tells me that it was last at a word press page /wp-admin/admin-php and I can go to that page and it will be the last page it was at..

So bottom line then if i add this code to the admin page and click the same button i had before.. it will tell me the file that called out the admin page.

Baslcaly I am looking for ideas on how to track the page i am now all the way back to the page with the button on it and all intermediate pages that it passes thru to get to the final destination.  It seems that to succesfully troubleshoot a fault is to follow the path of the entire job and see if any breaks...

Any thoughts or suggestions on how to best do this would greatly be appreciated.

 

$sqlresdays="SELECT DATEDIFF(CURDATE(),MAKEDATE(YEAR(CURDATE()),1)) AS date_difference";
            $resdays=mysqli_query($donnees,$sqlresdays);
            $daysinyr=mysqli_fetch_object($resdays);
            $divider = $daysinyr->date_difference;

When running the sql request raw, no problem, date_difference shows the right number but in the script nothing is echo'd. Thanks for clues on how to resolve this.

I have the two files below and want to separate php and html. How do I output forum.html with forum_post.html in it? I want to post as many forum_post.html as mysql_num_rows() says.

Code: [Select]
forum.html
======
<div>
<form method="post">
<textarea name="text"></textarea>
<input type="submit" />
</form>
</div>
<div>
[b]???[/b]
</div>

Code: [Select]
forum_post.html
======
<div>
<h1>Title</h1>
<p>Text</p>
</div>

I am trying to be true to the principle that logic and presentation should be kept separate.

However, the only way to generate dynamic content and output is using something like PHP, so there is somewhat of a conflict.

I just wrote this Function, and I am curious if it breaks the principle above...

/**
 * Returns Online Status Indicator Markup
 *
 * Takes User's Last Activity and determines the User's Online Status.
 * Returns HTML for appropriate Online Status Indicator.
 *
 * @param DateTime $lastActivity MySQL DateTime format (yyyy-mm-dd hh:mm:ss)
 * @return string
 */
function getOnlineStatus($lastActivity){
// strtotime() converts DateTime format (yyyy-mm-dd hh:mm:ss) into a Unix Timestamp (seconds).
// time() is current time measured in the # of seconds since Unix Epoch (January 1 1970 00:00:00 GMT).
$minutesOnline = (time() - strtotime($lastActivity))/60;

// Determine Online Status.
if ($minutesOnline < 15){
// Member Online
$indicator = '<img src="/images/Light_Green_10.png" width="10" alt="Member Online" /><br />';
}else if ($minutesOnline < 30){
// Member Idle
$indicator = '<img src="/images/Light_Yellow_10.png" width="10" alt="Member Idle" /><br />';
}else{
// Member Offline
$indicator = '<img src="/images/Light_Gray_10.png" width="10" alt="Member Offline" /><br />';
}

return $indicator;
}//End of getOnlineStatus


Thanks,


Debbie