Learn VBA & Macros in 1 Week!

PHP - Use A Foreach Statement To Add A Record To A Table

Full Excel VBA Course - Beginner to Expert

Use A Foreach Statement To Add A Record To A Table	View Content

I have some code that will update a record and is generic, meaning any POST variables can be used - whatever you have on the form. See below:
Code: [Select]
$set = array();
foreach($_POST as $field => $value){
$field = mysql_real_escape_string($field);
$value = mysql_real_escape_string($value);
$set[] = "`{$field}` = '{$value}'";
}

$query .= implode(", ",$set) . " WHERE $id_name = '".$id."' LIMIT 1";

mysql_query($query) or die(mysql_error());
My question is, how would I modify this to insert a NEW record (not update an existing one). I'm not sure how to order this within a foreach statement because the add query has a different form: insert into tabel (all the fieldnames here) VALUES (all the values here)

Full Excel VBA Course - Beginner to Expert

Trouble With Insert Statement To Add Record

Similar Tutorials

View Content

I am trying to create a query to insert data into a table in my Access database. I have the following query:

INSERT INTO Issues (DateRequested, CustomerID, ComputerID, Issue, ItemsIncl, ImageName) VALUES (#1/14/2015#, 1, 1, "Computer freezes while I'm on the internet.", "AC Adapter", "none.gif")

which should be performed from within my PHP page. However, when I check the database afterward, the new record isn't there. I then tried performing the query directly in Access and it worked fine. Why would it work in Access, but not when I run the same query in PHP? Chris

If Statement In Foreach Loop

Similar Tutorials

View Content

Object- Take array of IP addresses and add up all occurrences of a particular IP address.

//$item is an array of IP addresses

foreach ($item as $key => $unique_ip)
{
if($unique_ip == $ip)
$a++;
}
echo $a;

I get a blank page. What am I missing?

Issue With Foreach With If Statement

Similar Tutorials

View Content

Hi I am new to PHP and I am having an issue with a foreach loop combined with an if statement, basically the if statement is getting the data from the first result in the foreach but not getting the second result, I have tried implement a count by using a variable to iterate but it isnt working:

Code as follows:

foreach(findCustomAlerts($customerid) as $key=>$value){

    echo "ID of cat : ".$rifdid = $value['Catid']."<br>";

    echo "Visits required per day : ".$visitsneeded= $value['Visits required']."<br>";

}

foreach(getTodaysVisits($device_id) as $rfid){

    foreach($rfid as $key=> $read){

        if($key ==$rifdid && $read < $visitsneeded) {

            echo"<br>". $key." has not visited enough";

        }

    }

}

Ouput is :

ID of cat : 5609
Visits required per day : 3
ID of cat : 23641
Visits required per day : 5

Array ( [rfid_id] => Array ( [23641] => 1 [5609] => 3 ) ). -------> this is the array data

23641 has not visited enough

-----------------------------------------------

How can I get the loop to iterate to the next value?

Edited October 3, 2020 by Barand
code block/indents

How To Exit Foreach At The Following Statement

Similar Tutorials

View Content

HI,
I have a foreach loop but after some execution it begins to show me this:Invalid argument supplied for foreach() ... so I want to exit from it.how can I do that?

Thanks

My Foreach Statement Is Not Finding The Array. Can Anyone See Why?

Similar Tutorials

View Content

I am having a go at writing my own simple gallery.

As the I want to display an image from a folder in a directory of all the images... for example, I have 10 folders each containing images. I want my code to take image 01.jpg out of each folder and display it on my page, so that when I add folders to my main images folder, they will automatically be added to the page... but I only want the last 10 folders to display... so once I have 20 folders, it only shows 10.

I also want the images to be 5 across and then make a new row.

My folders will be numbered in order... 001, 002, 003, etc... and I need them sorted in reverse order, so the folder added last is displayed first.

So... this is where I am at with the code :

Code: [Select]

$dir = "gallery/";

if (is_dir($dir)) {
[color=red] foreach(array_keys($file) as $n) {[/color]
if ($n+1 == 5) {
echo "<td><img src=\"" . $dir . $file . "/01.jpg\" width=\"140px\" height=\"93px\" alt=\"\" /></td></tr><tr>";
}
elseif ($n+1 > 10) {
echo "";
}
else {
echo "<td><img src=\"" . $dir . $file . "/01.jpg\" width=\"140px\" height=\"93px\" alt=\"\" /></td>";
}
closedir($dh);
}
}
For some reason, I am getting the following error on the page :

Warning: First argument to array_keys() should be an array in /path/to/gallery.php on line 8

Warning: Invalid argument supplied for foreach() in /path/to/gallery.php on line 8

line 8 is the one in red above.

So... I have a couple of questions...

1. What have I done wrong so far? I cannot see it
2. How would I then go about putting the galleries in reverse order? I know it must be rsort, but not to sure if I need to do this first or after... ?

Any help greatly appreciated, and I would also be greatful f an idiot's explanation, as I am really trying to understand all this!

I'm getting there... slowly!

Need Sorting In Foreach / If Statement. Can't Make It Happen

Similar Tutorials

View Content

hi,

i am having issues with sorting within a conditional statement. please see the code below. right now, i ve commented out the sorting below. basically i want to sort by: $venue1->hereNow->count. I am managing to pull the data correctly. see: http://marineboudeau.com/lab/4sq/
<?php if (is_object($venue->response)) { //sort($venue->response->groups[0]->items->hereNow->count); foreach ($venue->response->groups[0]->items as $venue1) { if ($venue1->hereNow->count != '0'){ //var_dump ($venue1); echo "<div style='font-weight:bold;'>".$venue1->name."</div>"; echo "<div>".$venue1->location->address." ".$venue1->location->city."</div>"; echo "<div>".$venue1->hereNow->count."</div>"; echo "</br>"; } } }?>()

any idea what i need to do to make it happen?

thank you.
marine

How To Update A Record In My Table

Similar Tutorials

View Content

Not sure how to update a record in my table here. I got my insert and delete statement working. Just can't get the update to work correctly. I'm not really sure how to do it.

Here is my code for my page, and my update and delete page

Code: [Select]
<?php

ini_set ("display_errors", "1");
error_reporting(E_ALL);

require_once('database.php');
session_start();

if (isset($_POST['add_grade']))
{

$query = "INSERT INTO grades (grade_id, student_id, grade_type, grade_name, grade_points) ";
$query .= "VALUES (:grade_id, :student_id, :grade_type, :grade_name, :grade_points) ";

$statement = $db->prepare($query);
$statement->bindValue (':student_id', $_SESSION['student_id']);
$statement->bindValue (':grade_id', $_SESSION['grade_id']);
$statement->bindValue (':grade_type', $_POST['grade_type']);
$statement->bindValue (':grade_name', $_POST['grade_name']);
$statement->bindValue (':grade_points', $_POST['grade_point']);

$statement->execute();

$statement->closeCursor();

$grade_type = $_POST['grade_type'];

if ($grade_type == 'Lab') {

$final *= .60;
}

echo $final;

$grade_type = $_POST['grade_type'];

if ($grade_type == 'Mid-Term') {

$final *= .20;
}

echo $final;

$grade_type = $_POST['grade_type'];

if ($grade_type == 'Final') {

$final *= .20;
}

echo $final;

}

?>
<!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>View Course Grades</title>

<link rel="stylesheet" type="text/css" href="main.css" />
</head>

<body>

<?php

$student_name = $_SESSION['student_name'];
$student_id = $_SESSION['student_id'];
$query = "SELECT * FROM grades WHERE student_id = :student_id ";

$statement = $db->prepare($query);
$statement->bindValue (':student_id', $student_id);
$statement->execute();
$grades = $statement->fetchAll();
$statement->closeCursor();

echo "<h1>Show Grades for $student_name </h1>";

foreach ($grades as $grade)
{

echo $grade['grade_type'] . " " . $grade['grade_name']. " " . $grade['grade_points'] . "<br />";
}

?>

<div id="content">


<table>
<tr>
<th>Grade Type</th>
<th>Grade Name</th>
<th>Grade Points</th>
<th>Remove</th>
</tr>
<?php foreach ($grades as $grade) : ?>
<tr>
<td><?php echo $grade['grade_type'];   ?></td>
<td><?php echo $grade['grade_name'];   ?></td>
<td><?php echo $grade['grade_points']; ?></td>
<td><form action="delete_grade.php" method="post">

<input type="submit" name="remove" value="Delete" />

</form></td>
</tr>
<?php endforeach; ?>
</table>

</div>
</div>

<div id="footer">

</div>

<form name="grades" method="post" action="grades.php">

<p>Grade Type<SELECT NAME="grade_type">
<OPTION VALUE="Mid-Term">Mid-Term
<OPTION VALUE="Final">Final
<OPTION VALUE="Lab">Lab
</SELECT>
<br>

Grade Name:<input type="text" name="grade_name" value=""><br />
Grade Points:<input type="text" name="grade_point" value="">

<input type="submit" name="add_grade" value="Add Grade">

</form>

</table>

</body>

</html>

My delete and update page

Code: [Select]
<html>
<head>
<title>Delete Grade</title>
</head>
<body>
<form method="post" action="delete_grade.php">

<?php

ini_set ("display_errors", "1");
error_reporting(E_ALL);

$dbc = mysqli_connect('localhost', 'se266_user', 'pwd', 'se266')
or die(mysql_error());

//delete grades

if (isset($_POST['remove']))
{
foreach($_POST['delete'] as $delete_id)
{
$query = "DELETE FROM grades WHERE grade_id = $delete_id";
mysqli_query($dbc, $query) or die ('can\'t delete user');
}
echo 'user has been deleted.<br />';
}

if (isset($_POST['update']))
{
foreach($_POST['update'] as $update_id)
{
$query = "UPDATE grades SET grade_id = $grade_id";
mysqli_query($dbc, $query) or die ('can\'t update user');

}
}

//Display grade info with checkbox to delete
$query = "SELECT * FROM grades";
$result = mysqli_query($dbc, $query);
while($row = mysqli_fetch_array($result))
{
echo '<input type="checkbox" value="' .$row['grade_id'] . '" name="delete[]" />';
echo ' ' .$row['grade_type'] .' '. $row['grade_name'];
echo '<br />';
}
mysqli_close($dbc);

?>

<input type="submit" name="remove" value="Remove" />
<input type="submit" name="update" value="Update" />

</form>
</body>
</html>

How To Check If A Record/row Exists In A Table

Similar Tutorials

View Content

Hi, I just want to know how to check if a row/record already exists for a given table, but this code gives me message in browser: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in myTest.php

This is the the snippet I am running:
Code: [Select]
<?php
$connxn=mysql_connect("localhost","root");
$db=mysql_select_db("siliconvalley");
$toyNodePath="#document/siliconValleyHELLO";
$queryA=mysql_query("SElECT FROM pathexpress (path_express) WHERE path_express='$toyNodePath'");//make sure AT MOST ONE ROW EXISTS!!
if(mysql_num_rows($queryA)==1)
print "ALREADY IN table pathexpress!";
else {
mysql_query("INSERT INTO pathexpress (path_express) VALUES ('$toyNodePath')");
print "ADDED $toyNodePath to table pathexpress!";
}

?>
Please, any help is greatly appreciated!

Displaying A Record From A Table As A Link In Php

Similar Tutorials

View Content

I have the following code:

Code: [Select]
$result = mysql_query("SELECT * FROM ESSAY_QUESTIONS WHERE SUBJECT = 'ENGLISH'")
or die(mysql_error());

while($essay_data=mysql_fetch_array($result)){

$question = $essay_data['QUESTION'];
$id = $essay_data['ID'];

echo "<a href=\"englishessays.php?id=$id>";
echo "$question </a>";
echo "<br><br>";
}
It seems to be almost working but it just displays one link and the address is all the rest of the code including </a>"; echo "<br><br>"; and other questions.

I presume there's an error with how I've written the echo statements so can anyone see it? Or can anyone suggest a better way to do this?

On the next page, the php will read the ID from the address and display the information form that record.

I Would Like To Grab The Id Of An Edited Record And Insert Into Another Table. Is This Possible?

Similar Tutorials

View Content

Greetings mates,

I have not been here for years. I have been thrust into an app written by someone else.

The requirement is to amend, not edit, an existing record. In other words, rather than edit an existing record, management would like an empty new text box to enter amended data and save to another table so that when queried, would display existing record and the newly amended record.

Below is an ID of an existing record:

	$sql = "SELECT * FROM DBO.existingTable where year_created = 2019 Order by Id";
    echo '<table id="results-table">
	<thead>
		<tr>
			<th>ID</th>
			<th>Edit</th>
			<th>View PDF</th>
			<th>Task Lead</th>
			<th>Task Title</th>
			<th>Division</th>
          		</tr>
	</thead>';

	while ( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_BOTH  ) ) {
		$div = ($row['division'] == "1" ? "Divname" : ($row['division'] == "2" ? "Highway" : "NULL"));
		$taskType = ($row['task_type'] == 0 ? "Annual" : ($row['task_type'] == 1 ? "Carryover" : ($row['task_type'] == 2 ? "New" : "NULL")));
		if($row['year_created'] == 2019){
			echo '<tr id="taskId">
			<td>'.$row['Id'].'</td>
			<td><a href="project_edit.html?id='.$row['Id'].'" target="_blank">Edit</a></td>
			<td><input type="button" onclick="getReport('.$row['Id'].')" value="View PDF"></td>
			<td>'.$row['task_lead'].'</td>
			<td>'.$row['task_title'].'</td>
			<td>'.$div.'</td>
    		</tr>
		}

	}
	echo '</table>'

The above code isa snippet of code in edit.php.

What I would like to do is grab the ID which is '.$row['Id'].' from this edit page and use it when inserting the amended code which is in insert,php file:

//The ID from edit.php code should go here
$task_lead = (empty($_POST['task_lead'])) ? "''" : "'" . str_ireplace( "'", "", $_POST[ 'task_lead' ] ) . "'";
$task_title = (empty($_POST['task_title'])) ? "''" : "'" . str_ireplace( "'", "''", $_POST[ 'task_title' ] ). "'";
$division = (empty($_POST['division'])) ? "''" : "'" . str_ireplace( "'", "", $_POST[ 'division' ] ) . "'";

//Then my insert statement should be something like this:
	$sql = "INSERT INTO DBO.Amended_Records ({id from table with existing record}, amended_taskActivities, amended_taskProducts,amendscope_dev_fhwa, amendconsultant_procurement, amendcontract_negotiations, amendconsultant_notice, amendtotal_duration, year_created)
	VALUES ({$rowId - that I need to get from edit.php}, $amendproposed_activities, $amendanticipated_products,$amendscope_dev_fhwa,$amendconsultant_procurement,$amendcontract_negotiations,$amendconsultant_notice,$amendtotal_duration, 2021)";

When I insert this record into the DB, the id from edit.php is getting inserted as null.

Can you please advise how I can resolve this?

Moved: How To Overwrite An Existing Table Record

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

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

Linking Checkbox Value To A Table Record In Php And Changing Values

Similar Tutorials

View Content

I posted a topic earlier and there was confusion as to what I could not work out. I am able to display the checkbox, either checked or unchecked depending of the value or 1 or 0 in the obcDisplay field.

<input type="checkbox" name="obcDisplay" value="<?=$r['obcDisplay'] ?>" <?=($r['obcDisplay']) ? 'checked="checked"' : ''; ?>/>

I am trying to update the DB table by the checkbox. If the checkbox is checked (obcDisplay = 1) and I uncheck the box and submit, I want the table updated so that obcDisplay now equals 0. When the form is displayed, the checkbox is now uncheck (obcDisplay = 0). Now I check the box and submit and the update changes the field from 0 to 1. I can display the checkbox as checked or unchecked by the DB field obcDisplay being either 0 or 1. It is changing the value where I am having the problem.

Save Each Record Into Database And Then Update Table For All Users

Similar Tutorials

View Content

Hello, Here is my current code: index.php

<html>
<body>
<form id="hey" name="hey" method="post" onsubmit="return false">
Name:<input type="text" name="name">
<input type="submit" name="submit" value="click">
</form>
<table class="table table-bordered" id="update">
<thead>
<th>Name</th>
</thead>
<tbody>
<script type="text/javascript">
      $("#hey").submit(function() {
          
        $.ajax({
          type: 'GET',
          url: 'response.php',
          data: {   username: $('#name').val()},
          success: function (data) {
            $("#update").prepend(data);
          },
          error: function (xhr, ajaxOptions, thrownError) {
            alert(thrownError);
          }
        });
      });
      
    </script>
</tbody>
</table>

response.php

<?php
$username = $_GET['username'];
echo "<tr>";
echo "<td>$username</td>";
echo "</tr>";
?>

This code works fine, it prints out the rows as what the user enters. Now what I want to do is, log all these entries to a mySQL database and also, display these rows over the site. i.e., any user who is online, should be seeing this without having to refresh the page too.. Real time updates in a way. How can I achieve that? Thanks!

Foreach Into Table

Similar Tutorials

View Content

Hi All

Please see code below. I cannot get my table to produce correctly. I have a multidimensional array $data['id']['fieldid']=$row['content']
I want this to loop through and create a new line in a table for each sub-array. hence the table would look like this.

(id1 in this row) field1 content field2 content field3 content field4 content (id2 in this row) field1 content field2 content field3 content field4 content (id3 in this row) field1 content field2 content field3 content field4 content (id4in this row) field1 content field2 content field3 content field4 content etc etc. The table can grow or shrink depending on the data I'm retrieving.

<table><font size="8">
<tr>
<?php

foreach ($header_out as $value){

echo "<td>$value</td>";
}
?>

</tr>
<?php

echo"<tr>";

foreach($data as $value){

$count++;

foreach($value as $dataout){

echo "<td>$dataout $count</td>";

}

}echo"</tr><tr>";

</tr></font></table>

<?php } ?>

The header section works fine, but the double foreach loop seems to be where I'm failing.

Any advice guys?

Echoing Mysql Table Data And Making A Countdown Timer For Each Record

Similar Tutorials

View Content

Hey all!
In the code in question I echo out individual records of data from MySQL successfully. For each record there is a number which is used as a var in the javascript that does the count-down-timer part.
However when I view the resulting page the timer works dynamically only with the first record. With the rest, the timer is static.

Code: [Select]
<?
$result0 = mysql_query("SELECT * FROM table WHERE field='$value'");
while ($riw0 = mysql_fetch_assoc($result0)) {
$seconds1 = $riw0['seconds'] ;
//// echo out data and set variable for the number of seconds to count down
?>

<script language="JavaScript">
var countDownInterval=<?=$seconds1?>;
var c_reloadwidth=200
</script>
<ilayer id="c_reload" width=&{c_reloadwidth}; ><layer id="c_reload2" width=&{c_reloadwidth}; left=0 top=0></layer></ilayer>
<script>
var countDownTime=countDownInterval+1;
function countDown(){
countDownTime--;
if (countDownTime <=0){
countDownTime=countDownInterval;
clearTimeout(counter)
window.location.href="military3.php" //Redirection URL
return
}
var mins = Math.floor(countDownTime/60)
var secs = countDownTime-(mins*60)
if (document.all) //if IE 4+
document.all.countDownText.innerText = mins+" minutes "+secs+ " ";
else if (document.getElementById) //else if NS6+
document.getElementById("countDownText").innerHTML=mins+" minutes "+secs+ " "
else if (document.layers){
document.c_reload.document.c_reload2.document.write('Soldiers will be ready in... <span id="countDownText">'+countDownTime+' </span> seconds')
document.c_reload.document.c_reload2.document.close()
}
counter=setTimeout("countDown()", 1000);
}

function startit(){
if (document.all||document.getElementById)
document.write('Soldiers will be ready in <span id="countDownText">'+countDownTime+' </span> seconds')
countDown()
}

if (document.all||document.getElementById)
startit()
else
window.onload=startit
</script>
<? } ?>

I tried replacing the javascript vars with PHP echoes for unique variables, but then no timer shows up, even static.
So could anyone advice me on how I could use this code to apply for all MySQL records?

Thanks in advance,
Thauwa

P.S. If I am unclear with my quandary, do let me know. Thank you.

Arrange The Results Of A Foreach In A Table

Similar Tutorials

View Content

Hello everyone !

I am currently developing a module for my site that will allow me to classify each solution to help a disability by type.
For example, here's an example:

Type : Visual disability
Solution : Add screen readers

For this, I have a database in which these types and solutions are found. In this database, the solutions of one type or another are not in a defined order. They can be put randomly, when a user adds one.

I need to display, in a table, these Types first (as a title), then the solutions corresponding to this type.

I manage to generate a display thanks to a foreach loop, but my solutions are all mixed up and therefore not clearly sorted.

This is how it is currently displayed

Visual disability

    Audio-described cut-scenes

    Highlighted path to follow

    Sensitivity settings for all the controls

    Screen readers on menus

    Slow down the game speed

But I would need it to look like this:

Visual disability

    Audio-described cut-scenes

    Highlighted path to follow

    Screen readers on menus

    Slow down the game speed

Physical disability

    Sensitivity settings for all the controls

In my example above, only the solution "Sensitivity settings for all the controls" is part of the "Physical disability" type. The rest is part of the "Visual disability" type.

Here is the code I currently use to retrieve my information from my database and display it. It's a Wordpress.

/*====== Accessibility Options ======*/

function cloux_accessibility_options() {
    if ( function_exists( 'rwmb_meta' ) ) {
        $output = "";
        $accessibility_options = rwmb_meta( 'accessibility-options' );
        $accessibility_options_status = rwmb_meta( 'accessibility-options-status' );
        if( $accessibility_options_status == "1" ) {
            if( !empty( $accessibility_options ) ) {
                $output .= '<div class="accessibility-options widget-box">';
                    $output .= cloux_title( $title = esc_html__( 'Accessibility Options', 'cloux' ), $style = "style-4", $align = "left", $colored_title = '' );
                    $output .= '<ul>';
                        $output .= '<li class="title visual_disability">' . esc_html__( 'Visual disability', 'cloux' ) . '</li>';
                    $output .= '</ul>';

                        foreach ( $accessibility_options as $accessibility_options ) {
                            if( !empty( $accessibility_options ) ) {
                                $accessibility_name =  isset( $accessibility_options['accessibility-options-name'] ) ? $accessibility_options['accessibility-options-name'] : '';
                                $accessibility_type =  isset( $accessibility_options['accessibility-type-name'] ) ? $accessibility_options['accessibility-type-name'] : '';
                                $accessibility_type = get_term( $accessibility_type, 'accessibility' );
                                $accessibility_type_name = $accessibility_type->name;
                                $availability =  isset( $accessibility_options['availability'] ) ? $accessibility_options['availability'] : '';

                            if ( $accessibility_type_name == "Visual disability" ){
                                if( !empty( $accessibility_name ) or !empty( $availability )) {
                        $output .= '<ul>';
                                    $output .= '<li class="item accessibility_name">';
                                        if( !empty( $accessibility_name ) ) {
                                            $accessibility_name = get_term( $accessibility_name, 'accessibility' );
                                            if( ( !empty( $accessibility_name ) ) ) {
                                                $output .= '<a href="' . get_term_link( $accessibility_name ) . '">' . esc_attr( $accessibility_name->name ) . '</a>';
                                            }
                                        }
                                    $output .= '</li>';
                                    $output .= '<li class="item visual_disability status">';
                                        if( $availability == "1" ) {
                                            $output .= '<i class="fas fa-check" aria-hidden="true"></i>';
                                        } else {
                                            $output .= '<i class="fas fa-times" aria-hidden="true"></i>';
                                        }
                                    $output .= '</li>';
                                }
                            }
                            
                            
                            if ( $accessibility_type_name == "Motor/Physical disability" ){
                                if( !empty( $accessibility_name ) or !empty( $availability )) {
                        $output .= '<ul>';
                                    $output .= '<li class="item accessibility_name">';
                                        if( !empty( $accessibility_name ) ) {
                                            $accessibility_name = get_term( $accessibility_name, 'accessibility' );
                                            if( ( !empty( $accessibility_name ) ) ) {
                                                $output .= '<a href="' . get_term_link( $accessibility_name ) . '">' . esc_attr( $accessibility_name->name ) . '</a>';
                                            }
                                        }
                                    $output .= '</li>';
                                    $output .= '<li class="item visual_disability status">';
                                        if( $availability == "1" ) {
                                            $output .= '<i class="fas fa-check" aria-hidden="true"></i>';
                                        } else {
                                            $output .= '<i class="fas fa-times" aria-hidden="true"></i>';
                                        }
                                    $output .= '</li>';
                                }
                            }
                            
                            
                        $output .= '</ul>';
                        }
                    }
                $output .= '</div>';
            }
        }
        return $output;
    }
}

Thank you in advance for all the help you can give me!

Edited January 13 by Sagaroth

Foreach Printing In Html Table

Similar Tutorials

View Content

I want to print in an html table the Seasons,the Months,and the days of each month.
the following code prints the seasons and the days
i need another foreach in between that prints the months also
Any ideas???
Please help...

$seasons=array (
   "Fall"=> array ("September"=>"30","October"=>"31","November"=>"30"),
   "Winter"=> array ("December"=>"31","January"=>"31","February"=>"28"),
   "Spring"=> array ("March"=>"31","April"=>"30","May"=>"31"),
   "Summer"=> array ("June"=>"30","July"=>"31","August"=>"31")
);
$tab = "<table border=\"1\">";
foreach($seasons as $season => $months) {
   $tab .= "<tr><td colspan=\"4\">$season</td></tr>" ;
   $tab .= "<tr>" ;
   foreach($seasons[$season] as $days) {
      $tab .= "<td>$days</td>" ;
   }
   $tab .= "</tr>" ;
}
$tab .= "</table>" ;
echo $tab ;

Using Foreach To Loop Data In Array To Display It On A Table With 5 Columns

Similar Tutorials

View Content

Now I am stumped this is far any help would be awesome

This is what I have gotten so far, this is what it does right now is display each Header above each bit of data and spans across 5 columns for each foreach loop but what i am trying to understand here is i am trying to get the header then the data then another header and data and so on but only about 4 or number of my choosing grouped header/data but select how many are in each column up to 5 columns. Heres an example of what i am trying to do.

A D K N S AlexandraHeadlands DickyBeach KingsBeach Nambour SandstonePoint Aroona Diddillibah KielMountain Ninderry ShellyBeach Doonan KundaPark NoosaHeads SippyDowns B Dulong Kuluin Ningi SunriseBeach Beachmere DeceptionBay Kilcoy NorthArm SunshineBeach BanksiaBeach Noosaville Scarborough Beerburrum E L Beerwah EerwahVale Landsborough O T Bellara Elimbah Tanawha Bellmere Eudlo M P TowenMountain Birtinya Eumundi Maleny Petrie Tewantin Bongaree Mapleton Palmview TwinWaters Bokarina F Marcoola Palmwoods BribieIslandArea Flaxton MarcusBeach Parklands U Buddina ForestGlen MaroochyRiver Parrearra UpperCaboolture Burnside Maroochydore PeregianBeach Buderim G Minyama Pinbarren V Burpengary GlassHouseMountains MoffatBeach PointArkwright Valdora BliBli Mons PelicanWaters H Montville PacificParadise W C Highworth Mooloolaba WeybaDowns CoolumBeach Hunchy Mooloolah Q Warana Caboolture MountainCreek WestWoombye CabooltureSouth I MountCoolum R Woombye Caloundra ImageFlat Morayfield Rosemount Woorim CastawaysBeach Mudjimba Redcliffe WamuranBasin Chevallum J Woodford CoesCreek WoodyPoint Cooroy Wamuran Currimundi Wurtulla X Y YandinaCreek Yandina Z

This is an example of how it is being displayed right now

A
Airlie Beach Andergrove Alexandra Armstrong Beach
Alligator Creek
B
Bucasia Blacks Beach Beaconsfield Bakers Creek
Balberra Bloomsbury Breadalbane Ball Bay Belmunda
C
Cannonvale Calen Crystal Brook Cremorne
Chelona Campwin Beach Cape Hillsborough
Conway

Heres The Code i have so far.

Code: [Select]
<?php
  $file = "widget.csv";
@$fp = fopen($file, "r") or die("Could not open file for reading");
$outputArray = array();
$count = 0;

while(($shop = fgetcsv($fp, 1000, ",")) !== FALSE)
{
    $outputArray[array_shift($shop)] =  array_filter($shop);
}

echo "<table>";
foreach ($outputArray as $alphabetical=>$value){
    echo "<th colspan='4'><b>" . $alphabetical ."</b></th>";
    echo "<tr>";
foreach ($value as $key){
$afterkey=preg_replace('/\s+/','-',$key);
    if ($count == 4){
    echo '</tr><tr><td><a href="map.php?mapaddress='.$afterkey.'-qld&mapname='.$key.'">'.$key.'</a></td>';
    $count = 0;
    }else{
    echo '<td><a href="map.php?mapaddress='.$afterkey.'-qld&mapname='.$key.'">'.$key.'</a></td>';
    }
$count++;
}
    echo "</tr>";
$count = 0;
}
    echo "</table>";

    echo "\n<br />";

?>

Heres my CSV File:

Quote

A,Airlie Beach,Andergrove,Alexandra,Armstrong Beach,Alligator Creek,,,,,,,,,,,,,,
B,Bucasia,Blacks Beach,Beaconsfield,Bakers Creek,Balberra,Bloomsbury,Breadalbane,Ball Bay,Belmunda,,,,,,,,,,
C,Cannonvale,Calen,Crystal Brook,Cremorne,Chelona,Campwin Beach,Cape Hillsborough,Conway,,,,,,,,,,,
D,Dows Creek,Dumbleton,Dolphin Heads,,,,,,,,,,,,,,,,
E,Eimeo,Eton,Erakala,,,,,,,,,,,,,,,,
F,Foulden,Foxdale,Flametree,Farleigh,Freshwater Point,,,,,,,,,,,,,,
G,Glen Isla,Glenella,,,,,,,,,,,,,,,,,
H,Homebush,Hampden,,,,,,,,,,,,,,,,,
I,,,,,,,,,,,,,,,,,,,
J,Jubilee Pocket,,,,,,,,,,,,,,,,,,
K,Kinchant Dam,Kolijo,Koumala,Kuttabul,,,,,,,,,,,,,,,
L,Laguna Quays,,,,,,,,,,,,,,,,,,
M,McEwens Beach,Mackay,Mackay Harbour,Mandalay,Marian,Mia Mia,Middlemount,Midge Point,Mirani,Moranbah,Mount Charlton,Mount Jukes,Mount Julian,Mount Marlow,Mount Martin,Mount Ossa,Mount Pelion,Mount Pleasant,Mount Rooper
N,Narpi,Nebo,Nindaroo,North Eton,,,,,,,,,,,,,,,
O,Oakenden,Ooralea,,,,,,,,,,,,,,,,,
P,Palmyra,Paget,Pindi Pindi,Pinevale,Pioneer Valley,Pleystowe,Preston,Proserpine,,,,,,,,,,,
Q,,,,,,,,,,,,,,,,,,,
R,Racecourse,Richmond,Riordanvale,Rosella,Rural View,,,,,,,,,,,,,,
S,St Helens Beach,Sandiford,Sarina,Seaforth,Slade Point,Shoal Point,Shute Harbour,Shutehaven,Strathdickie,Sugarloaf,Sunnyside,,,,,,,,
T,Te Kowai,The Leap,,,,,,,,,,,,,,,,,
U,,,,,,,,,,,,,,,,,,,
V,Victoria Plains,,,,,,,,,,,,,,,,,,
W,Wagoora,Walkerston,Woodwark,,,,,,,,,,,,,,,,
X,,,,,,,,,,,,,,,,,,,
Y,Yalboroo,,,,,,,,,,,,,,,,,,
Z,,,,,,,,,,,,,,,,,,,

Problem In Using Foreach And While Loop In Displaying Data On Table Format

Similar Tutorials

View Content

Hi...

I tried to use foreach in displaying my table header, but I encountered problem when I tried to display data on the first row , my query only display the last Sum for the last Comp.

here is my code:

<html>
<head>
<title>Half Shell</title>
<link rel="stylesheet" type="text/css" href="kanban.css" />
<?php
  error_reporting(E_ALL ^ E_NOTICE);
  date_default_timezone_set("Asia/Singapore"); //set the time zone
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);

?>

<body>
<form name="param" action="" method="post" onSubmit="return false">

<div id="fieldset_PS">
<?php
   echo "<table>";

   $sql = "SELECT DISTINCT s.Comp FROM sales_order s, param_settings p WHERE s.Comp = p.Compounds ORDER BY s.Comp";
   $res_comp = mysql_query($sql, $con);
   while($row_comp = mysql_fetch_assoc($res_comp)){
        $Comp[] = $row_comp['Comp'];
   }
   echo "<th> </th>";
   foreach($Comp AS $Comp){
    echo "<th>$Comp</th>";
  }

   echo "<tr>
   <td>Total Kg/Compound</td>";
      $sql_sec = "SELECT SUM(TotalKg) AS TotalKg FROM sales_order  WHERE Comp = '$Comp' ORDER BY Comp";
   $res_sec = mysql_query($sql_sec, $con);

   while($row_sec = mysql_fetch_assoc($res_sec)){
       $TotalKg[] = $row_sec['TotalKg'];

   }
   foreach($TotalKg AS $TotalKg){
    echo "<td>$TotalKg</td>
    </tr>";
  }

   ?>

I also attach the correct output that should be and the result from my code.

Thank you

Using Foreach To Loop Data In Array Todisplay It On A Table With 4 Or So Columns

Similar Tutorials

View Content

Now I am stumped this is far any help would be awesome

This is what I have gotten so far, this is what it does right now is display the first column of the array as a header for each foreach loop then i've got the data displayed under each header in the loop but what i am trying to understand here is i am trying to get under each header it to have 4 columns or a number of my choosing. Heres an example of what i am trying to do.

A airlie beach Andergrove Alexandra Armstrong Beach Alligator Creek B Bucasia Blacks Beach Beaconsfield Bakers Creek Balberra Bloomsbury Breadalbane Ball Bay Belmunda
This is an example of how it is being displayed right now

A
Airlie Beach   Andergrove   Alexandra   Armstrong Beach   Alligator Creek
B
Bucasia   Blacks Beach   Beaconsfield   Bakers Creek   Balberra   Bloomsbury   Breadalbane   Ball Bay   Belmunda
C
Cannonvale   Calen   Crystal Brook   Cremorne   Chelona   Campwin Beach   Cape Hillsborough   Conway
Heres The Code i have so far.

Code: [Select]
<?php
$file = "widget.csv";
@$fp = fopen($file, "r") or die("Could not open file for reading");
$outputArray = array();
while(($shop = fgetcsv($fp, 1000, ",")) !== FALSE)
{
    $outputArray[array_shift($shop)] =  array_filter($shop);
}
print_r($outputArray);
echo "\n<br />";
//display
echo "<table>";
foreach ($outputArray as $alphabetical=>$value){
echo "<th><b>" . $alphabetical ."</b></th>";
echo "<tr>";
foreach ($value as $key){
echo "<td>" . $key . "</td>";

}
echo "</tr>";
}
echo "</table>";

echo "\n<br />";

?>
Heres my Csv File which i am using as an array in the code

Quote

A,Airlie Beach,Andergrove,Alexandra,Armstrong Beach,Alligator Creek,,,,,,,,,,,,,,
B,Bucasia,Blacks Beach,Beaconsfield,Bakers Creek,Balberra,Bloomsbury,Breadalbane,Ball Bay,Belmunda,,,,,,,,,,
C,Cannonvale,Calen,Crystal Brook,Cremorne,Chelona,Campwin Beach,Cape Hillsborough,Conway,,,,,,,,,,,
D,Dows Creek,Dumbleton,Dolphin Heads,,,,,,,,,,,,,,,,
E,Eimeo,Eton,Erakala,,,,,,,,,,,,,,,,
F,Foulden,Foxdale,Flametree,Farleigh,Freshwater Point,,,,,,,,,,,,,,
G,Glen Isla,Glenella,,,,,,,,,,,,,,,,,
H,Homebush,Hampden,,,,,,,,,,,,,,,,,
I,,,,,,,,,,,,,,,,,,,
J,Jubilee Pocket,,,,,,,,,,,,,,,,,,
K,Kinchant Dam,Kolijo,Koumala,Kuttabul,,,,,,,,,,,,,,,
L,Laguna Quays,,,,,,,,,,,,,,,,,,
M,McEwens Beach,Mackay,Mackay Harbour,Mandalay,Marian,Mia Mia,Middlemount,Midge Point,Mirani,Moranbah,Mount Charlton,Mount Jukes,Mount Julian,Mount Marlow,Mount Martin,Mount Ossa,Mount Pelion,Mount Pleasant,Mount Rooper
N,Narpi,Nebo,Nindaroo,North Eton,,,,,,,,,,,,,,,
O,Oakenden,Ooralea,,,,,,,,,,,,,,,,,
P,Palmyra,Paget,Pindi Pindi,Pinevale,Pioneer Valley,Pleystowe,Preston,Proserpine,,,,,,,,,,,
Q,,,,,,,,,,,,,,,,,,,
R,Racecourse,Richmond,Riordanvale,Rosella,Rural View,,,,,,,,,,,,,,
S,St Helens Beach,Sandiford,Sarina,Seaforth,Slade Point,Shoal Point,Shute Harbour,Shutehaven,Strathdickie,Sugarloaf,Sunnyside,,,,,,,,
T,Te Kowai,The Leap,,,,,,,,,,,,,,,,,
U,,,,,,,,,,,,,,,,,,,
V,Victoria Plains,,,,,,,,,,,,,,,,,,
W,Wagoora,Walkerston,Woodwark,,,,,,,,,,,,,,,,
X,,,,,,,,,,,,,,,,,,,
Y,Yalboroo,,,,,,,,,,,,,,,,,,
Z,,,,,,,,,,,,,,,,,,,