PHP - Scoreboard Output From Mysql Help.

Hello dear members, first of all sorry for my grammer i'm from Switzerland  . So now: I have a problem with php. I want to put out the date of a blogpost in this format dd:mm:yyyy instead of yyyy:mm:dd. I tried it a long time and used many different ways like: date, dateformat, strto etc. but at the and nothing worked for me. So here is a picture of the blogpost and i'll add the file with my compressd php code.   I'd be glad if you could help me Regards Mr_Ironic

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>

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

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

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

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

This topic has been moved to MySQL Help.

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

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>';
  }
?>

I have created a PHP page where the contents are pulled from DB. Is there a way that I can save the file with the output and stylesheet to PDF with a click of a button. 

Edited May 5, 2020 by ZulfadlyAshBurn
Grammer

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!!!

I'm not getting any errors but I"m not getting the output I'm expecting. When it gets the characterIDList values if there is a value for that field it needs to take that value then explode it and get the ID and characterName of each of the values so say the value inside of characterIDList was 2,3 then for each of those values it would find the characterName and ID of the value and be able to put each of them as a LI inside the UL.  I was hoping I could have the charactersQuery separate because I use it for the dropdown.

Code: [Select]
$newsQuery = "
    SELECT
        news.categoryID,
        news.newsTitle,
        news.newsPicture,
        news.content,
        news.characterIDList
    FROM
        news
        LEFT JOIN categories
            ON news.categoryID = categories.ID
    WHERE
        news.ID = '" . $newsID . "'";
$newsResult = mysqli_query ( $dbc, $newsQuery ); // Run The Query
echo $newsQuery;
$row = mysqli_fetch_array ( $newsResult, MYSQL_ASSOC );
$characterIDList = $row[ 'chracterIDList' ];

$characterIDList = explode(',',  $characterIDList);

foreach($characterIDList as $value){
    $charactersQuery = "
        SELECT
            ID,
            characterName
        FROM
            characters
        ORDER BY
            characters.characterName";
    $charactersResult = mysqli_query ( $dbc, $charactersQuery ); // Run The Query
}

Code: [Select]
<div class="field required">
            <label for="charactersDrop">Characters Involved</label>
            <ul id="characterList" style="list-style: none; margin-left: 195px;">
            <?php
              mysqli_data_seek( $charactersResult, 0 );
              while($row = mysqli_fetch_array ( $newsResult, MYSQL_ASSOC )) {
                if ($row['characterName'] == NULL  ) { 
                    
                } else {
             ?>
                    <li characterID="<?php echo $row['ID']; ?>" characterName="<?php echo htmlentities( $row['characterName'] ); ?>"><?php echo htmlentities($row['characterName']); ?> <a href="#">Remove</a></li>   
             <?php }} ?>
            </ul>
            <select class="dropdown" name="charactersDrop" id="charactersDrop" title="Characters Dropdown" style="margin-left: 195px;">
                <option value="">- Select -</option>
               <?php
                    mysqli_data_seek( $charactersResult, 0 );
                    while ( $row = mysqli_fetch_array ( $charactersResult, MYSQL_ASSOC ) ) { 
                        print "<option value=\"".$row['ID']."\">".$row['characterName']."</option>\r";
                    }
                ?>
            </select>
            <input type="button" value="Add Character" class="" onclick="CharactersInvolved()"/>
        </div>