PHP - Multiple Lines In Array Value

So I have this textarea in an HTML form that I need to convert the contents of from having multiple line breaks into only one line break for each.

Example: I want to convert the following:
Code: [Select]
I went to the store.

I had a good time.



I ran into a friend.
Into this:
Code: [Select]
I went to the store.
I had a good time.
I ran into a friend.
Any help would be super appreciated.

So I'm trying to create an Array from a comma separated string containing array{s}. How can I take a string full of comma separated hex values such as : 

<?php
    $myStr = (
        "00ffff", "00cccc", "009999", 
        "007777", "004444", "001111", 
        "01ffff", "01cccc", "019999"
    );
?>

& turn it into 3 separated arrays like : 

<?php
    $myNewArrs = [
        Array1 ( 3 ), 
        Array2 ( 3 ), 
        Array3 ( 3 ), 
    ];
?>

which REALLY looks like : 

<?php
    $myNewArrs = [
        Array ( "00ffff", "00cccc", "009999" ), 
        Array ( "007777", "004444", "001111" ), 
        Array ( "01ffff", "01cccc", "019999" ), 
    ];
?>

?

Any assistance is most-definitely appreciated!

Thank you & have a great afternoon!

 

 

Edited May 27 by AquariaXI

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

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

Hello

I am having some trouble with array_keys

I have an array for which I want to return all the keys based on value X

This is my code:

Code: [Select]

$depth = array_keys(X', $Array);

echo print_r ($depth,1);



I have checked the content of my array $Array and it contains at least 1 instance of 'X' but I am getting nothing when I do the print_r

Any suggestions would be appreciated

Thanks

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

How can I make a multiple function array?

i'm setting up reminders for users and fetch_reminders does what it says... fetches all the reminder functions. Well that's what I want it to do and the other functions are just checks.

How can I make $reminder and array of the functions that I want checked? Is this the best way to do it?

Code: [Select]
$reminder =array()
function fetch_reminders($reminder === true)
{
return true
}

function capital_requested_reminder($requested, $accounttype)
{
$requested = (int)$requested;
$accounttype = (int)$accounttype;

if (empty($requested) && ($accounttype === 1))
{
return true;
}
}

function associates_reminder($associates)
{
$associates = (int)$associates;

if ($associates >= 1)
{
return true;
}
}

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

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

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?

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?

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

I have a Form that has 10 questions.

When the User completes the Form, each Response needs to be a separate record.

(My database has a many-to-many relationship with a "member" and "question" table joined by a "answer" table in the middle.  And each Form field will go into its own unique record to make the many-to-many work.)

At the top of my Form I have...

if ($_SERVER['REQUEST_METHOD']=='POST'){
// Form was Submitted (Post).

// Initialize Errors Array.
$errors = array();

// Trim all form data.
$trimmed = array_map('trim', $_POST);


// ************************
// Validate Form Data. *
// ************************

// Validate Answer1.
if (strlen($trimmed['answer01']) >= 2 && strlen($trimmed['answer01']) <= 1024){
// Valid Answer1.
$answerArray[0] = $trimmed['answer01'];
}else{
// Invalid Answer1.
$errors['question01'] = 'Answer must be 2-1024 characters.';
}//End of VALIDATE ANSWER1


// Validate Answer2.
// :
// :
// Validate Answer10.



And down farther in my code, I have each Field in my Form set up like this...
Code: [Select]
<!-- Question 1 -->
<label for="question01">1.) Why did you decide to start your own business?</label>
<textarea id="question1" name="answer01" cols="60" rows="8"><?php if (isset($answerArray[0])){echo htmlentities($answerArray[0], ENT_QUOTES);} ?></textarea>
<?php
if (!empty($errors['question01'])){
echo '<span class="error">' . $errors['question01'] . '</span>';
}
?>


So if my Form works like I am thinking, all 10 Form Fields would end up here...
Code: [Select]
$answerArray[0]
$answerArray[1]
$answerArray[2]
$answerArray[3]
$answerArray[4]
$answerArray[5]
$answerArray[6]
$answerArray[7]
$answerArray[8]
$answerArray[9]


First of all, does that sound correct?


If that part is correct, then how do I take the $answerArray[] and INSERT each value into a different record in my "answer" table??

Hope that makes sense?!

Thanks,


Debbie