PHP - Php And Mysql Output

Hi,

I'm trying to make a mysql output to a link so the name will be a link so when you hit this link you will get the full information of this mysql input.

Can someone point me in the correct direction?

Here is how i get the output from my mysql database into my table.
Code: [Select]
<td>";
echo $row['name'];
echo "</td>

I currently have php code that outputs information from my database, but how do i make it also display the name of the fields beside each entry of the database?

heres my PHP code:
Code: [Select]
<?php

$server = "";      // Enter your MYSQL server name/address between quotes
$username = "";    // Your MYSQL username between quotes
$password = "";    // Your MYSQL password between quotes
$database = "";    // Your MYSQL database between quotes

$con = mysql_connect($server, $username, $password);       // Connect to the database
if(!$con) { die('Could not connect: ' . mysql_error()); }  // If connection failed, stop and display error
mysql_select_db($database, $con);  // Select database to use
// Query database
$result = mysql_query("SELECT * FROM Properties");

if (!$result)
{
    echo "Error running query:<br>";
    trigger_error(mysql_error());
}
elseif(!mysql_num_rows($result))
{
    // no records found by query.
    echo "No records found";
}
else
{
    $i = 0;
    echo '<div style="font-family:helvetica; font-size:15px; padding-left:15px; padding-top:20px;">';
    while($row = mysql_fetch_array($result)) {     // Loop through results
        $i++;
         echo '<img class="image1" src="'. $row['images'] .'" />';   //image
        echo "Displaying record $i<br>\n";
        echo "<b>" . $row['id'] . "</b><br>\n";      // Where 'id' is the column/field title in the database
        echo $row['Location'] . "<br>\n";            // Where 'location' is the column/field title in the database
        echo $row['Property_type'] . "<br>\n";       // as above
        echo $row['Number_of_bedrooms'] . "<br>\n";  // ..
        echo $row['Purchase_type'] . "<br>\n";       // ..
        echo $row['Price_range'] . "<br>\n";         // ..
    }
echo '</div>';
}

mysql_close($con);  // Close the connection to the database after results, not before.
?>



thanks in advance

Hi guys.I am making a Query Analyzer in php which takes the query string inside a form and out puts the result table in that particular page.How do i output the notification by MySQL when you do a successful insertion of data into mysql.i want to know if there are any methods in php which gives you that such as "1 row affected","Query took 0.00sec".Thanks

if I'm outputting from mysql with this:

Code: [Select]
// Connects to your Database
 mysql_connect("localhost", "root", "") or die(mysql_error()) ;
 mysql_select_db("test") or die(mysql_error()) ;
 
 //Retrieves data from MySQL
 $data = mysql_query("SELECT * FROM tickets") or die(mysql_error());

//Puts it into an array
while($info = mysql_fetch_array( $data )) {
//Outputs the image and other data


 Echo "<b>asset number:</b> ".$info['AssetNumber'] . "<br> ";
 Echo "<b>subject:</b> ".$info['subject'] . " <br>";
 Echo "<b>notes:</b> ".$info['Notes'] . " <hr>"; }
can I base the record it outputs somehow on this:

Code: [Select]

$value="";
$value = ProcessLargeText(GetData($data,"Asset Number", ""),"","",MODE_VIEW);
if($mainTableOwnerID=="Asset Number")
$ownerIdValue=$value;
$xt->assign("Asset_Number_value",$value);
if(!$pageObject->isAppearOnTabs("Asset Number"))
$xt->assign("Asset_Number_fieldblock",true);
else
$xt->assign("Asset_Number_tabfieldblock",true);

It's kind of like a job history so its getting records of job history from one table while the second piece of code is getting the asset details from a main table

This topic has been moved to MySQL Help.

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

I create a post just now but cannot seem to find it to add to it. Anyhow, I have 2 tables, I need to multiply qty from the one table to the mass from the other to get a total, which I have achieved with this code:

$sql_total_mass = "
	SELECT jobs_assembly.assemble_qty, jobs.mass,
	(jobs_assembly.assemble_qty * jobs.mass) AS 'sum'	
	FROM jobs_assembly
	LEFT JOIN jobs on jobs_assembly.jobs_id = jobs.id
	LEFT JOIN job_names ON jobs.job_names_id = job_names.job_id
	WHERE jobs_assembly.assemble_date = '$link_date'
	ORDER BY job_names.job_name, jobs.assembly
	";

	$result_total_mass = mysqli_query($conn, $sql_total_mass);

	if (mysqli_num_rows($result_total_mass) > 0) {
		while($row_total_mass = mysqli_fetch_assoc($result_total_mass)) {
			echo $row_total_mass['sum'].'<br />';
		} //while
	} //if

Now I need to take all these totals and make a grand total. So basically add all the results from $row_total_mass[‘sum’] together and show it.

 

 

I'm trying to organize MySQL output in an HTML table based on individual states. Here is how the static HTML is currently displayed: http://www.u-s-s-a.org/breeders.html. Here is my working document: http://www.u-s-s-a.org/breeders.php. As you can see on the HTML page, each db row is organized into individual states. I'm only concerned about the US states, and not the countries outside of the US.

Following is the code I've been working on (directoryoutput.php):

Code: [Select]
<?php
require '/home/srob/public_html/u-s-s-a.org/config.php';

$connect = mysql_connect ($dbhost, $dbuser, $dbpass) or die ('Cannot connect: '.mysql_error());
mysql_select_db ($dbname);

$query = "SELECT * FROM directory ORDER BY flockname";
$result = mysql_query($query) or die ('Error, query failed.');

echo "<tr><td width='33%' class='style9'><p align='left' class='style12'><a name='AR'></a>Arkansas</p></td><td width='34%'>&nbsp;</td><td width='33%' valign='top'><div  align='right'><a href='#TOP'><img src='returnTOTOPGRAPHIC/RETURNTOTOP.gif' width='113' height='21' border='0' align='absmiddle'></a></div></td></tr>";

$cnt = 0;

while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
if ($cnt == 0){
echo "<tr><td valign='top' class='style9'><p align='center'><span class='style10'><strong>";
if($row['flockname']){ echo $row['flockname']; }
echo "</strong></span><strong></br>";
if($row['firstname']){ echo $row['firstname']." ".$row['lastname']."</br>"; }
if($row['address1']){ echo $row['address1']."</br>"; }
if($row['address2']){ echo $row['address2']."</br>"; }
if($row['city']){ echo $row['city'].", ".$row['state']." ".$row['zip']."</br>"; }
if($row['email1']){ echo "<a href='mailto:".$row['email1']."'>".$row['email1']."</a></br>"; }
if($row['email2']){ echo "<a href='mailto:".$row['email2']."'>".$row['email2']."</a></br>"; }
if($row['website1']){ echo "<a target='_blank' href='http://".$row['website1']."'>".$row['website1']."</a></br>"; }
if($row['website2']){ echo "<a target='_blank' href='http://".$row['website2']."'>".$row['website2']."</a></br>"; }
echo "</br></p></td>";
$cnt++;
} elseif ($cnt == 1){
echo "<td valign='top' class='style9'><p align='center'><span class='style10'><strong>";
if($row['flockname']){ echo $row['flockname']; }
echo "</strong></span><strong></br>";
if($row['firstname']){ echo $row['firstname']." ".$row['lastname']."</br>"; }
if($row['address1']){ echo $row['address1']."</br>"; }
if($row['address2']){ echo $row['address2']."</br>"; }
if($row['city']){ echo $row['city'].", ".$row['state']." ".$row['zip']."</br>"; }
if($row['email1']){ echo "<a href='mailto:".$row['email1']."'>".$row['email1']."</a></br>"; }
if($row['email2']){ echo "<a href='mailto:".$row['email2']."'>".$row['email2']."</a></br>"; }
if($row['website1']){ echo "<a target='_blank' href='http://".$row['website1']."'>".$row['website1']."</a></br>"; }
if($row['website2']){ echo "<a target='_blank' href='http://".$row['website2']."'>".$row['website2']."</a></br>"; }
echo "</br></p></td>";
$cnt++;
} elseif ($cnt == 2){
echo "<td valign='top' class='style9'><p align='center'><span class='style10'><strong>";
if($row['flockname']){ echo $row['flockname']; }
echo "</strong></span><strong></br>";
if($row['firstname']){ echo $row['firstname']." ".$row['lastname']."</br>"; }
if($row['address1']){ echo $row['address1']."</br>"; }
if($row['address2']){ echo $row['address2']."</br>"; }
if($row['city']){ echo $row['city'].", ".$row['state']." ".$row['zip']."</br>"; }
if($row['email1']){ echo "<a href='mailto:".$row['email1']."'>".$row['email1']."</a></br>"; }
if($row['email2']){ echo "<a href='mailto:".$row['email2']."'>".$row['email2']."</a></br>"; }
if($row['website1']){ echo "<a target='_blank' href='http://".$row['website1']."'>".$row['website1']."</a></br>"; }
if($row['website2']){ echo "<a target='_blank' href='http://".$row['website2']."'>".$row['website2']."</a></br>"; }
echo "</br></p></td></tr>";
$cnt = $cnt - 2;
}
}

mysql_close($connect);

?>
I'd appreciate any help on this code, including a more efficient way to parse out the MySQL db rows into 3 columns in the HTML table.

Thanks in advance!

Ryan

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

Well I have a script that executes a scan on a system set to run infinitely, and I need it to echo out a message each time it loops through, but I don't want it to echo out the message with the next loop message below it, and the next one below that etc... I've tried using the flush(); function and been messing around with that with no luck. For security reasons I don't want to release any of the processing code, but here is the basic construction of the script:

<?PHP
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
$RepeatIt = -1;
for($g=1; $g!=$RepeatIt+1; $g++)
{
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***

$ScanMessage = ":.:.: SCANNING THE HITLIST FOR MOBSTER: ".$MobName." (SCAN #$g) :.:.:"."<br/><br/>";
echo $ScanMessage;

***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
}
?>

At the moment it's returning:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #1) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #2) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #3) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #4) :.:.:

So what I want it to do is just delete the scanning message and replace it with the next scan message so while running this script you would see just the number increment on the same line.

Any suggestions?

Thanks.

Hi, I have this code below which groups all the SubHeading together and then queries the same table to find RiskConsequence which are grouped that match SubHeading then to query this table one more last time with all the Risk Mitigation that matches the grouped RiskConsequence.

Problem I get is it does the SubHeading, the RiskConsequences it only does one of them not all of them before it moves onto the RiskMitigation.

I know I have a php coding issue just cant see the wood from the tree's as the queries work.

Code: [Select]
<?php
include ("include.php");
$query = "SELECT * FROM tblriskassessmentdatabank GROUP BY SubHeading";
$results = mysql_query($query) or die("Error: " . mysql_error());
while($row1 = mysql_fetch_array($results)){
    

    echo'<a href="#" onClick="return(changeDisplay(';echo"'";echo($row1[SubHeading]);echo"'))";echo'">';echo($row1[SubHeading]);echo'</a><br /><br />';
echo'<div id="';echo($row1[SubHeading]); echo'" class="HideText">';

$risksub = $row1[SubHeading];

$query1 = "SELECT * FROM tblriskassessmentdatabank GROUP By RiskConsequence";
$results1 = mysql_query($query1) or die("Error: " . mysql_error());
while($row2 = mysql_fetch_array($results1)){


echo'<a href="#" onClick="return(changeDisplay(';echo"'";echo($row2[RiskConsequence]);echo"'))";echo'">';echo($row2[RiskConsequence]);echo'</a><br />';
echo'<div id="';echo($row2[RiskConsequence]); echo'" class="HideText">';
$risksub1 = $row2[RiskConsequence];
$query1 = "SELECT * FROM tblriskassessmentdatabank WHERE RiskConsequence = '$risksub1'";
$results1 = mysql_query($query1) or die("Error: " . mysql_error());
while($row3 = mysql_fetch_array($results1)){

echo'<input name="checkbox[]" type="checkbox" id="checkbox[]" value="';echo($row3[IssueNumber]);echo'" />
    <label for="checkbox[]"></label>';echo($row3[RiskMitigation]);echo'<br /><br />';
}
echo'</div>';

}

echo'</div>';
  }
?>

Hi all,

Is there a simple way to log the command output of a linux console?

This command locks up my screen. It is a screen on an Aastra IP phone.

$command = 'logsave /var/www/html/aastra/test.log ls';

shell_exec($command);


Thanks!

help me.
i have an index.php file in admin folder.
this is the code inside the file:
Code: [Select]
<?php
?>

Or any other code
and i get output 0 ,
but if i echo something else then i get the string has output,

help find out what is the problam please!!!

Hi,

This script lists all the contents of the dir it is placed in bar itself. Perfect for what I need. However, I want to output the results as xml and being new to php I really don't know where to start.

<?php
foreach (new DirectoryIterator('.') as $file) {
     if ( (!$file->isDot()) && ($file->getFilename() != basename($_SERVER['PHP_SELF'])) ) {
            echo ($file->isDir()) ? "(Dir) ".$file->getFilename() : $file->getFilename();
         }
}
?>

I'd be thankful for the help

Thanks in advance.

I don't have any output after I push the button :s I dont know how
http://fhcs.be/index3.php
Code: [Select]
<?php
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions

session_start();
?>
<?php if (!isset($_POST['submit'])) { ?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

        <form method="post" action="<?php echo $PHP_SELF; ?>">
        <input type="submit" value="Toon Output" name="submit"/>
         

<?php
$dranken=array()   ;
$DrinkResult=mysql_query("SELECT name,price FROM products")or die(mysql_error());

      while($DrinkRow=mysql_fetch_assoc($DrinkResult)){
         $dranken[] = $DrinkRow;

      }
echo "<table>";

    foreach ($dranken as $DrinkRow) {
$optionlist = "<select name='{$DrinkRow['name']}_aantal'>";
for  ($i=0;$i<10;++$i) {
$optionlist .= "<option value='$i'>$i</option>";
}
$optionlist .= "</select>";
echo "<tr><td>".$DrinkRow['name']." ".$DrinkRow['price']."</td>\n";
echo "<td>$optionlist</td></tr>\n";
}
echo "</table>";
?>
     

    </form>

    <?php
    }
    
    
$dranken=array()   ;
$DrinkResult=mysql_query("SELECT name,price FROM products")or die(mysql_error());

      while($DrinkRow=mysql_fetch_assoc($DrinkResult)){
         $dranken[] = $DrinkRow;

      }
echo "<table>";
    

    $totaalPrijs = 0;

    foreach ($dranken as $DrinkRow) {
        $aantal = $_POST[$DrinkRow['name'] . "_aantal"];
        if ($aantal > 0) {
            $prijsperDrank = $aantal * $DrinkRow['price'];
            echo $DrinkRow['name'] . " : " . $aantal . " Prijs: " . $prijsperDrank . "</br>";
$totaalPrijs=$totaalPrijs + $prijsperDrank; }
    
}
if($totaalPrijs>0){    
    echo " totaal: " .$totaalPrijs;}
    ?>

</html>