PHP - Multiple Function Array

Hi,

I have a menu that is generated from my mysql database and I want it on every page of my website as the main menu. However I can''t figure out how to do this. I managed to get it on the view article page by duplicating the my query like this:
Code: [Select]
function viewArticle() {

  if ( !isset($_GET["articleId"]) || !$_GET["articleId"] ) {
    homepage();
    return;
  }

  $result['article'] = Article::getById( (int)$_GET["articleId"] ); //single record
  $result['pageTitle'] = $result['article']->title . " | Widget News";

  $results = array();
  $all_data = Article::getList( HOMEPAGE_NUM_ARTICLES ); //multiple record
  $results['articles'] = $all_data['results'];
  $results['totalRows'] = $all_data['totalRows'];

  require( TEMPLATE_PATH . "/viewArticle.php" );
}

However I can't figure out how to place it on for example the new article page.
Code: [Select]
function newArticle() {

  $results = array();
  $results['pageTitle'] = "New Article";
  $results['formAction'] = "newArticle";

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

    // User has posted the article edit form: save the new article
    $article = new Article;
    $article->storeFormValues( $_POST );
    $article->insert();
    header( "Location: admin.php?status=changesSaved" );

  } elseif ( isset( $_POST['cancel'] ) ) {

    // User has cancelled their edits: return to the article list
    header( "Location: admin.php" );
  } else {

    // User has not posted the article edit form yet: display the form
    $results['article'] = new Article;
    require( TEMPLATE_PATH . "/admin/editArticle.php" );
  }

}

Can anybody help me out i'm really struggling?
Thanks

Hi All,

I have a function that creates an array using a few sql quereys.  I then use the array to output to html.  I am wanting to add more data to the array to populate another column in the created table.

I am unsure how to add $miqty to the array and then output it in the Qty On Order column. 

I feel like i need to add the [] to

$menuItemsInCat[$mcatname][$miid] = $miname;

section but i am not sure where in there it should be.

 

<?php if (session_status() == PHP_SESSION_NONE) {
session_start();
}
if (!isset($_SESSION['user_id'])){
	header("location: index.php");
	exit;
}
//name of the pagea
$_SESSION['this_page'] = 'new-menu';

function getMenuItems($conn){
	$output = '';
	$stmt = $conn -> query("
	                         SELECT menu_category_name
	                         FROM ssm_menu_items
	                         INNER JOIN  ssm_menu_category on menu_item_category_id = menu_category_id
	                         ORDER BY menu_category_display_order
	                         ");
	//create an empty array of all of the menu categories that are in use
	foreach ($stmt as $item){
		$menuItemsInCat[$item['menu_category_name']] = [];
	}
	$stmt = $conn -> prepare("
	                         	SELECT menu_item_id, menu_item_name, menu_category_name, sum(menu_item_qty)
								FROM ssm_menu_items mi
								INNER JOIN ssm_menu_category mcat ON mi.menu_item_category_id = mcat.menu_category_id
								left join ssm_menu_order USING (menu_item_id)
								GROUP BY menu_item_id
	                         ");
	$stmt -> execute();
	$stmt -> bind_result($miid, $miname, $mcatname, $miqty);
	while ($row = $stmt -> fetch()) {
		//put items into the blank array created above under their correct category
		
		$menuItemsInCat[$mcatname][$miid] = $miname;
	}

	echo "<pre>";
	print_r($menuItemsInCat);
	echo "</pre>";

		//foreach thing in $menuItemInCat array there is $menucat array associated with $menuit(ems) array
		//we want the menu cat
	foreach ($menuItemsInCat as $menucat => $menuit) {
		$output .= "<tbody>";
		$output .= "<tr class='bg-secondary text-white text-center'><th>$menucat</th>";
		$output .= "<th>Qty On Order</th><th>Manage</th></tr>";
		//foreach thing in menu items array there is an array of ids and an array of items
		foreach ($menuit as $itemId => $itemName) {
			$output .= "<tr><td>$itemName</td>";
			$output .= "<td></td>";
			$output .= "<td><div class='btn btn-primary'>Manage</div></td></tr>";
		}
		$output .= "</tbody>";
	}
	return $output;
}



?>
<?php include '_includes/head.php'; ?>
<div class="container-fluid">
	<div class="row">
		<?php include '_includes/header.php'; ?>
	</div>
	<div class="row" >
		<div class="col-sm-2 p-0 bg-dark text-light">
			<?php include '_includes/nav.php'; ?>
		</div>
		<div class="col-sm-10" style="height: calc(100vh - 80px);overflow:scroll;">
			<div class="mt-3">
				<table class="table table-striped table-hover table-bordered text-center align-middle">
					<?= getMenuItems($conn) ?>
				</table>
			</div>
			<div class="col-sm-12"><?php include '_includes/footer.php'; ?></div>
		</div>
	</div>
	
</div>
<script>
	//set sidebar active indicator
	//XX = name of parent if in dropdown eg "sheet"
	if(document.getElementById('menu')){
		document.getElementById('menu').classList.add('show')
	}
	//nav button ID
	if(document.getElementById('newMenu')){
		document.getElementById('newMenu').classList.add('blOrange')
	}
</script>

As always your help is very appreciated.

Edited February 5, 2020 by Adamhumbug

I have a Description field that gets sent to my Payment Gateway which can be put in an e-mail to my customer after a successful purchase.

Is it possible to have multiple lines and line-breaks in one Array Value??

For example...

Code: [Select]
$post_values = array(
"x_description" => "Fuzzy Sweater
Girls
Medium
Long-Sleeve
$75",


Debbie

Hi. I have a form with a selection of checkboxes. I am trying to use an array to store the results in a single column of a mysql database. The problem is, instead of the values, it just stores 'array'.

Each checkbox is like so:

<input name="previous_diseases[]" value="Tuberculosis"/>

Here is my code:

Code: [Select]
<?php
try{
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$database = new PDO('mysql:host=localhost;dbname=db', 'username', 'password', $pdo_options);
 
$execution=$database->prepare('INSERT INTO form(title, forename, surname, address_1, address_2, address_city, address_county, address_country, address_postcode, email, previous_diseases, hear) VALUES(:title, :forename, :surname, :address_1, :address_2, :address_city, :address_county, :address_country, :address_postcode, :email, :previous_diseases, :hear)'); 
$execution->execute(array('title' => $_POST['title'],
         'forename' => $_POST['forename'],
 'surname' => $_POST['surname'],
         'address_1' => $_POST['address_1'],
 'address_2' => $_POST['address_2'],
 'address_city' => $_POST['address_city'],
 'address_county' => $_POST['address_county'],
 'address_country' => $_POST['address_country'],
 'address_postcode' => $_POST['address_postcode'],
 'email' => $_POST['email'],
 'previous_diseases' => $_POST['previous_diseases'],
     'hear' => $_POST['hear']));
Can anyone please show me what I need to change to get the values inserted into the database.

Thank you

I have six rows of text boxes for users to enter into. The fields are named like

ROW1: invqty, invpart, invdesc, invlist, invprice, parttotal
ROW2: invqty02, invpart02, invdesc02, invlist02, invprice02, parttotal02
ROW3: ...
ROW4: ...

How can I add these to variables so $invoiceqty = invqty, invqty2, invqty3, etc. $invoicepart = invpart, invpart02, invpart03, etc.

and then loop through them, inserting all rows into a table until all data is INSERTED

Hi Guys   I have a number of arrays that are posted from a form   They are $home_rider $order $away_rider $awayorder   for each home rider I want to to action the following query   "INSERT INTO tbl_lg_rider_order (`name`,`card_id`,`homeaway`,`riderorder`) VALUES ('$homerider',$card_id,'h','$homeorder')"   and for each away rider I want to do the following   "INSERT INTO tbl_lg_rider_order (`name`,`card_id`,`homeaway`,`riderorder`) VALUES ('$awayrider',$card_id,'a','$awayorder')"   I am using the following code  

$i=0;
for($i){
$homerider=$home_rider[$i];
$homeorder=$order[$i];
$homesql="INSERT INTO tbl_lg_rider_order (`name`,`card_id`,`homeaway`,`riderorder`) VALUES ('$homerider',$card_id,'h','$homeorder')";
echo $homesql;
$i++;
}
$i=0;
for($i){
$awayrider=$away_rider[$i];
$awayorder=$awayorder[$i];
$homesql="INSERT INTO tbl_lg_rider_order (`name`,`card_id`,`homeaway`,`riderorder`) VALUES ('$awayrider',$card_id,'a','$awayorder')";
echo $awaysql;
$i++;
}

  I am getting an error saying Parse error: syntax error, unexpected ')', expecting ';'   Where am I going wrong?

Afternoon All,

I can't seem to work this problem out;

I have a form that is generated from a sql list and have two inputs as follows;
Code: [Select]
<input type="text" name="suppliernumber[]" id="suppliernumber[]" />
<input name="snomed[]" type="checkbox" id="snomed[]" value="<?php echo $row['VPPID']; ?>" />

Both are fed to my processing files as arrays, i then run the following foreach which uses the VPPID from the post to search in a database using a where clause.

The problem comes when i also need to obtain the data from the suppliernumber $_POST if any has been supplied.

My php code;

Code: [Select]
foreach ($_POST['snomed'] as $value) {

$getRecord_sql = "SELECT vmps.NM AS NM,  vmpps.QTYVAL AS QTYVAL,  bnf_lookup_subcatagory.BNF_SUBCAT AS BNF_SUBCAT,  bnf_lookup_catagory.BNF_CAT AS BNF_CAT FROM bnf_lookup_catagory INNER JOIN bnf_vmp ON  bnf_lookup_catagory.BNF_CAT =  bnf_vmp.BNF_CAT INNER JOIN bnf_lookup_subcatagory ON  bnf_vmp.BNF_SUBCAT =  bnf_lookup_subcatagory.BNF_SUBCAT RIGHT OUTER JOIN vmps INNER JOIN vmpps ON  vmps.VPID =  vmpps.VPID ON  bnf_vmp.VPID =  vmpps.VPID WHERE VMPPS.VPPID = '$value'";
$getRecord = mssql_query($getRecord_sql);
$row = mssql_fetch_array($getRecord);

$nm = $row['NM'];
$qtyval = $row['QTYVAL'];
$BNF_SUBCAT = $row['BNF_SUBCAT'];
$BNF_CAT = $row['BNF_CAT'];
$SUPPLIER = $_POST['suppliernumber'];

array_push($data_array, array($value, $nm, $BNF_CAT, $BNF_SUBCAT, '', $SUPPLIER, '', '1', '', '', '', '', '', '', '', '1', '', '', $qtyval));

}

I can't work out how to add the suppliernumber, i know i need another foreach but can't work out how to do it.

Hope someone can help.

Sam

Hi

I am trying to have the following as an example:

Code: [Select]
<select name="test[]" multiple="multiple">options here</select>
<select name="test[]" multiple="multiple">options here</select>

Then using $_POST['test'] to grab the boxes in the array. I want to then loop over each box so for example:

Code: [Select]
$boxes = $_POST['test'];

foreach ( $boxes as $box )

    // now here i would of expected $box to be an array of the options,
}

but it's not working like this, all the options from all submitted select boxes come in one array so I cannot distinguish which select box in the array they relate to, is there a way to do this??

I have a multidimensional array that I want to sort by "price" then by "date".  Here is an example of the array:
Code: [Select]
$productArray   = array ( array ("Bus", "1/1/2010", 15.99),
                                        array ("Train", "2/1/2010", 14.99),
                                        array ("Car", "3/1/2010", 18.00),
                                        array ("Plane", "3/1/2010", 15.99),
                                        array ("Bike", "3/1/2010", 9.99),
                                        array ("Truck", "1/1/2010", 19.99)
);
//sort by date
function sortElement1Asc($x, $y)
{
if ( $x[1] == $y[1] )
  return 0;
        else if ( $x[1] < $y[1] )
  return -1;
        else
  return 1;
}
//sort by price
function sortElement2Asc($x, $y)
{
if ( strtotime($x[2]) == strtotime($y[2]) )
  return 0;
else if ( strtotime($x[2]) < strtotime($y[2]) )
  return -1;
else
  return 1;
}
usort($productArray, 'sortElement1Asc');
usort($productArray, 'sortElement2Asc');

Unfortunately this is just sorting by price (or whatever i sort last).

Any ideas?

I have a really confusing question.  I dynamically generate arrays, but for the simplicity of the example we can just use two arrays.

Code: [Select]
Array 1 (
     [0] = 1
     [1] = 5
)

Array 2 (
     [0] = 2
     [1] = 6
)
How can I make the arrays multiple based on the same key value? 

array 1[0] * array 2[0] = 2
array 1[1] * array 2[1] = 30

I then want to sum the total of the multiplication.

$total = 2 + 30;

I need to do this to calculate covariance for a statistics procedure I am trying to run but I can't wrap my head around how to do the logic.

I am trying to add markers on my google maps which will show the location of all users with the status “active” and on click of the marker it displays the following results from the arrays i am getting over API

login
status
gps

This is my index.php file

<!DOCTYPE html>
<html>
<body>

<?php
$api_url = 'xxxx'; // please set your x URL
$admin_login = "xxxx"; // x administrator login
$admin_password = "xxxx"; //  administrator password

$api = new SplynxAPI($api_url);
$api->setVersion(SplynxApi::API_VERSION_2);

$isAuthorized = $api->login([
   'auth_type' => SplynxApi::AUTH_TYPE_ADMIN,
   'login' => $admin_login,
   'password' => $admin_password,
]);

if (!$isAuthorized) {
   exit("Authorization failed!\n");
}

$customerApiUrl = "admin/customers/customer/";

print "<pre>";

$result_customers = $api->api_call_get($customerApiUrl);
$customers_list = $api->response;
if ($result_customers) {
} else {
   print "Fail! Error code: $api->response_code\n";
   print_r($api->response);
}
?>
   <table>
   	<thead align="left" style="display: table-header-group">
   		<tr>
   			<th>CLIENT</th>
   			<th>STATUS</th>
   			<th>GPS</th>
   		</tr>
   	</thead>
   	<tbody>
   		<?php foreach($customers_list as $item) :?>
   			<tr class="item_row">
   				<td> <?php echo $item['login']; ?></td>
   				<td> <?php echo $item['status']; ?></td>
   				<td> <?php echo $item['gps']; ?></td>
   			</tr>
   		<?php endforeach;?>
   	</tbody>
   </table>
</body>
</html>

This is the output result

|CLIENT|STATUS|GPS|
|---|---|---|
| user1@example.com| active| -00.269704939193858,00.085300236009065|
| user2@example.com| active| -00.29697452399767,00.120804981797505|

But now i need this to generate the google maps markers on the map and this is my map below

var handleGoogleMapSetting = function() {
	"use strict";
	var mapDefault;
	
	var mapOptions = {
		zoom: 14,
		center: new google.maps.LatLng(-00.297106, 00.119429),
		mapTypeId: google.maps.MapTypeId.ROADMAP,
		disableDefaultUI: true,
	};
	mapDefault = new google.maps.Map(document.getElementById('google-map-default'), mapOptions);
	
	$(window).resize(function() {
		google.maps.event.trigger(mapDefault, "resize");
	});
	
	var defaultMapStyles = [];
	var flatMapStyles = [{"stylers":[{"visibility":"off"}]},{"featureType":"road","stylers":[{"visibility":"on"},{"color":"#ffffff"}]},{"featureType":"road.arterial","stylers":[{"visibility":"on"},{"color":"#fee379"}]},{"featureType":"road.highway","stylers":[{"visibility":"on"},{"color":"#fee379"}]},{"featureType":"landscape","stylers":[{"visibility":"on"},{"color":"#f3f4f4"}]},{"featureType":"water","stylers":[{"visibility":"on"},{"color":"#7fc8ed"}]},{},{"featureType":"road","elementType":"labels","stylers":[{"visibility":"off"}]},{"featureType":"poi.park","elementType":"geometry.fill","stylers":[{"visibility":"on"},{"color":"#83cead"}]},{"elementType":"labels","stylers":[{"visibility":"off"}]},{"featureType":"landscape.man_made","elementType":"geometry","stylers":[{"weight":0.9},{"visibility":"off"}]}]; 
	var turquoiseWaterStyles = [{"featureType":"landscape.natural","elementType":"geometry.fill","stylers":[{"visibility":"on"},{"color":"#e0efef"}]},{"featureType":"poi","elementType":"geometry.fill","stylers":[{"visibility":"on"},{"hue":"#1900ff"},{"color":"#c0e8e8"}]},{"featureType":"landscape.man_made","elementType":"geometry.fill"},{"featureType":"road","elementType":"geometry","stylers":[{"lightness":100},{"visibility":"simplified"}]},{"featureType":"road","elementType":"labels","stylers":[{"visibility":"off"}]},{"featureType":"water","stylers":[{"color":"#7dcdcd"}]},{"featureType":"transit.line","elementType":"geometry","stylers":[{"visibility":"on"},{"lightness":700}]}];
	var icyBlueStyles = [{"stylers":[{"hue":"#2c3e50"},{"saturation":250}]},{"featureType":"road","elementType":"geometry","stylers":[{"lightness":50},{"visibility":"simplified"}]},{"featureType":"road","elementType":"labels","stylers":[{"visibility":"off"}]}];
	var oldDryMudStyles = [{"featureType":"landscape","stylers":[{"hue":"#FFAD00"},{"saturation":50.2},{"lightness":-34.8},{"gamma":1}]},{"featureType":"road.highway","stylers":[{"hue":"#FFAD00"},{"saturation":-19.8},{"lightness":-1.8},{"gamma":1}]},{"featureType":"road.arterial","stylers":[{"hue":"#FFAD00"},{"saturation":72.4},{"lightness":-32.6},{"gamma":1}]},{"featureType":"road.local","stylers":[{"hue":"#FFAD00"},{"saturation":74.4},{"lightness":-18},{"gamma":1}]},{"featureType":"water","stylers":[{"hue":"#00FFA6"},{"saturation":-63.2},{"lightness":38},{"gamma":1}]},{"featureType":"poi","stylers":[{"hue":"#FFC300"},{"saturation":54.2},{"lightness":-14.4},{"gamma":1}]}];
	var cobaltStyles  = [{"featureType":"all","elementType":"all","stylers":[{"invert_lightness":true},{"saturation":10},{"lightness":10},{"gamma":0.8},{"hue":"#293036"}]},{"featureType":"water","stylers":[{"visibility":"on"},{"color":"#293036"}]}];
	var darkRedStyles   = [{"featureType":"all","elementType":"all","stylers":[{"invert_lightness":true},{"saturation":10},{"lightness":10},{"gamma":0.8},{"hue":"#000000"}]},{"featureType":"water","stylers":[{"visibility":"on"},{"color":"#293036"}]}];
    
	$('[data-map-theme]').click(function() {
		var targetTheme = $(this).attr('data-map-theme');
		var targetLi = $(this).closest('li');
		var targetText = $(this).text();
		var inverseContentMode = false;
		$('#map-theme-selection li').not(targetLi).removeClass('active');
		$('#map-theme-text').text(targetText);
		$(targetLi).addClass('active');
		
		switch(targetTheme) {
			case 'flat':
				mapDefault.setOptions({styles: flatMapStyles});
			break;
			case 'turquoise-water':
				mapDefault.setOptions({styles: turquoiseWaterStyles});
			break;
			case 'icy-COLOR_BLUE':
				mapDefault.setOptions({styles: icyBlueStyles});
			break;
			case 'cobalt':
				mapDefault.setOptions({styles: cobaltStyles});
				inverseContentMode = true;
			break;
			case 'old-dry-mud':
				mapDefault.setOptions({styles: oldDryMudStyles});
			break;
			case 'dark-red':
				mapDefault.setOptions({styles: darkRedStyles});
				inverseContentMode = true;
				break;
			default:
				mapDefault.setOptions({styles: defaultMapStyles});
				break;
		}

		if (inverseContentMode === true) {
			$('#content').addClass('content-inverse-mode');
		} else {
			$('#content').removeClass('content-inverse-mode');
		}
	});
};

var MapGoogle = function () {
	"use strict";
	return {
		//main function
		init: function () {
			handleGoogleMapSetting();
		}
	};
}();

$(document).ready(function() {
	MapGoogle.init();
});

 

Hello all, im new to this forum, im a noobie, just started coding about 3 weeks ago, don't be too hard on me.   My question is I wan't to check for challenges a user's team posted that have not been excepted after 1 day, then auto refund the user's team back there credits, and then also delete all the challenges. So far here is my code.

//Delete all matches not accepted after 1 day
$arrayin = array();
$autorefund = mysql_query("SELECT * FROM `challenges` WHERE `a` = " . $team['id'] . " "
. "AND `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 AND (`expires` < " . ((int) time()) . ")");
if (mysql_num_rows($autorefund) > 0) {
while ($autorefund = mysql_fetch_assoc($autorefund)) {
$arrayin[] = $autorefund['id'];
mysql_query("UPDATE `teams` SET `balance` = `balance` + " . $autorefund['credits'] . " "
. "WHERE `id` IN (" . mysql_real_escape_string(implode(',', $arrayin)) . ")");
mysql_query("DELETE FROM `challenges` WHERE `a` IN "
. "(" . mysql_real_escape_string(implode(',', $arrayin)) . ") "
. "AND `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 "
. "AND (`expires` < " . ((int) time()) . ")");
}
}

FYI here is the code i had, it works fine, however it will only delete 1 challenge per team, not all of there challenges. 

$autorefund   = mysql_query("SELECT * FROM `challenges` WHERE `a` = " . $team['id'] . " AND  `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 AND (`expires` < ".((int)time()).")");
if (mysql_num_rows($autorefund) > 0) {
while ($autorefund  = mysql_fetch_assoc($autorefund)) {
if ($autorefund['accepted'] == 0 and $autorefund['expires'] < time()) {
mysql_query("UPDATE `teams` SET `balance` =  `balance` + " . $autorefund['credits'] . " WHERE `id` = " . $team['id'] . "");
mysql_query("DELETE FROM `challenges` WHERE `a` = " . $team['id'] . " AND  `accepted` = 0 AND `completed` = 0 AND `chtype` = 1 AND (`expires` < ".((int)time())."));
}
}
}

I inherited this script, its using deprecated statements, i know im not skilled to rewrite the entire site to use prepared statements.

Hi,

As the title suggests I am unsure on how to first run a query which stores values into an array. I then need to run a function multiple times but use the array within the function. How is this possible? I have had no luck figuring it out yet.

1. RUN QUERY
2. BUILD ARRAY USING QUERY RESULTS
3. RUN FUNCTION MULTIPLE TIMES
4. WITHIN FUNCTION I NEED TO USE ARRAY

Many thanks
Simon

I have this code working fine (thanks to Thorpe).  FYI, this code is getting info for each day and putting that info into the array and then later on a calendar is generated and the data gathered here is placed onto each specific day.  This is working EXCEPT when there are MULTIPLE data sets on the SAME day.  In those cases, it's just displaying the first data set.

In other words, if $hunches['day'] = 3 and there is just one data set with that date, it will display that info on the calendar fine. But if there are five data sets with $hunches['day'] = 3, then it only displays the first one.

I need it to display all data sets, so any clue how I could alter this code to do that?


Code: [Select]
$sql = "SELECT  *, DATE_FORMAT(`dob`, '%e') AS day FROM hunches
WHERE poolid = '{$_GET['poolid']}'
AND  (DATE_FORMAT(`dob`,'%m')) = " . $month1 . "
ORDER BY day";
$gethunches = mysql_query($sql, $connection);
if (!$gethunches) {
die("Database query failed: " . mysql_error());
} else {

while ($hunches = mysql_fetch_array($gethunches)) {         
    $days1[$hunches['day']] = array(NULL,NULL,'<span class="red">' . $hunches['firstname'] . '</span>');
}
}

Here is a further explanation...
Say $hunches['day'] = 5 and there are four data sets for that day (with respective firstnames of Bob, Joe, Jim and Tony).  I would essentially need this to happen in the code...
Code: [Select]
$days1[$hunches['day']/*which would be 5 in this example*/] = array(NULL,NULL,'<span class="red">' . $hunches['firstname'] . '</span><br>
<span class="red">' . $hunches['firstname'] . '</span><br>
<span class="red">' . $hunches['firstname'] . '</span><br>
<span class="red">' . $hunches['firstname'] . '</span>');

And that would then output...

Bob
Joe
Jim
Tony

...in the 5th day box on the calendar.  Right now, I'm just getting...

Bob

I fear this is very complicated to do but holding out hope that there is some relatively easy way to make this work.