PHP - Increase Value Of Array By 1 Via Form

I'm using the following function/php code to create some JSON for some NVD3 charts I am using. The problem I have is that for each KEY, the $i variable will count even and odd numbers. Here is the data below as you can see in the first line, every x:counts as 0, 2, 4 , 6. and for KEY:IDNB it counts 1,3,5,7. I need them all to count equally so that they are against the same line on my graph. How can I make them count 1,2,3,4  for both "keys"

[{"key":"IDNA","values":[{"x":0,"y":387.73},{"x":2,"y":388.57},{"x":4,"y":388.04},{"x":6,"y":387.94},{"x":8,"y":388.24},{"x":10,"y":388.44},{"x":12,"y":387.99},{"x":14,"y":388.53},{"x":16,"y":388.79},{"x":18,"y":388.6},{"x":20,"y":388.55},{"x":22,"y":388.48},{"x":24,"y":388.72},{"x":26,"y":389.02},{"x":28,"y":388.59},{"x":30,"y":388.07},{"x":32,"y":388.14},{"x":34,"y":388.58},{"x":36,"y":388.12},{"x":38,"y":388.76},{"x":40,"y":388.15},{"x":42,"y":388.26},{"x":44,"y":388.09},{"x":46,"y":388.58},{"x":48,"y":386.85},{"x":50,"y":388.23},{"x":52,"y":388.16},{"x":54,"y":388.83},{"x":56,"y":388.79},{"x":58,"y":388.74},{"x":60,"y":388.78},{"x":62,"y":388.54},{"x":64,"y":388.36},{"x":66,"y":388.7},{"x":68,"y":388.54},{"x":70,"y":388.02},{"x":72,"y":388.05},{"x":74,"y":388.31},{"x":76,"y":388.65},{"x":78,"y":388.98},{"x":80,"y":387.78},{"x":82,"y":389.42},{"x":84,"y":388.86},{"x":86,"y":388.66},{"x":88,"y":388.51},{"x":90,"y":388.27},{"x":92,"y":389},{"x":94,"y":387.8},{"x":96,"y":388.18},{"x":98,"y":388.66}]},{"key":"IDNB","values":[{"x":1,"y":387.33},{"x":3,"y":388.5},{"x":5,"y":387.75},{"x":7,"y":387.98},{"x":9,"y":388.57},{"x":11,"y":388.23},{"x":13,"y":387.83},{"x":15,"y":388.31},{"x":17,"y":388.99},{"x":19,"y":388.7},{"x":21,"y":388.49},{"x":23,"y":388.21},{"x":25,"y":388.4},{"x":27,"y":389.05},{"x":29,"y":388.26},{"x":31,"y":387.88},{"x":33,"y":388.2},{"x":35,"y":388.3},{"x":37,"y":388.08},{"x":39,"y":388.29},{"x":41,"y":388.04},{"x":43,"y":387.91},{"x":45,"y":388.23},{"x":47,"y":388.47},{"x":49,"y":386.83},{"x":51,"y":387.55},{"x":53,"y":388.03},{"x":55,"y":388.98},{"x":57,"y":388.7},{"x":59,"y":388.94},{"x":61,"y":388.47},{"x":63,"y":388.5},{"x":65,"y":387.66},{"x":67,"y":388.17},{"x":69,"y":388.29},{"x":71,"y":387.73},{"x":73,"y":388},{"x":75,"y":388.36},{"x":77,"y":388.35},{"x":79,"y":388.75},{"x":81,"y":387.36},{"x":83,"y":389.32},{"x":85,"y":388.74},{"x":87,"y":388.86},{"x":89,"y":388.57},{"x":91,"y":388.21},{"x":93,"y":388.74},{"x":95,"y":387.84},{"x":97,"y":388.18},{"x":99,"y":388.7}]}]

Here is the PHP im using to make the data from a query

$lrs = CDB::ExecuteQuery($sql);
if($lrs) {
$jsonData = convert($lrs);
}
function convert($lrs) {
$i = 0;
$intermediate = array();

while ($vals = CDB::GetAssoc($lrs)) {
$key = $vals['VARIABLE'];
$x = $i;
$y = $vals['VAR_MEASURE_1'];
$intermediate[$key][] = array('x' => $x, 'y' => $y);
$i++;
}

$output = array();
foreach($intermediate as $key => $values) {
$output[] = array(
"key" => $key,
'values' => $values
);
}

return json_encode($output, JSON_NUMERIC_CHECK);


}

can anyone point me in the right direction?  

For the section of code below, is there a way to say, "first time through the query print on A2, B2,etc, then each query following add increase the number besides column name to be A3, B3, etc, then A4, B4, etc"...?


$result = mysqli_query($connection,"SELECT * FROM table")
or die(mysqli_error($connection));

while($row = mysqli_fetch_array($result)) {

//get all rows you want from the table

$var1 = $row['var1'];
$var2 = $row['var2'];
$var3 = $row['var3'];
$var4 = $row['var4'];

$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A2', $var1)
            ->setCellValue('B2', $var2)
            ->setCellValue('C2', $var3)
            ->setCellValue('D2', $var4);

}



This is for an excel spreadsheet. The code is currently printing/exporting one row only from the table.

Thanks

Jelly Bellys. So there are "recipes" of ones you can eat at the same time. The most well-known one is probably mixing a couple peanut butter jelly beans with a couple grapes. I have to say it's pretty good because they actually do taste like peanut butter and grapes, but I have one issue: the peanut butter flavor is too weak compared to the grape. Instead of a 1-1 ratio it takes more like 3-1.

Weird thing, this has got to be the most famous recipe so why isn't it listed on their site? I see candy apple, tiramisu, and lemon meringue pie, but nothing about peanut butter and jelly sandwiches. Are they just not popular anymore? Personally I prefer peanut butter and chocolate (Nutella, specifically) but whatever. Which can't be that weird because Reese's is popular... Mind you peanut butter + Nutella sandwiches don't really taste like Reese's candies, but that could just be because of the type of chocolate. Like they use milk or dark chocolate while Nutella is based on hazelnut.

Which reminds me, I have a jar of it in the cupboard, but it's been so long since I've used it that it might have turned into an oily mess by now. I know it's just the various oils and such separating but it looks like someone poured a teaspoon or two of water right into it and that just kinda puts me off the whole thing. Same for peanut butter for that matter except the "water" isn't clear. Dirty water. And mixing everything back together isn't so bad but it gets the knife dirty on the handle, which really bothers me because then my fingers get dirty and I have to stop what I'm doing and go wash my hands. I already do that enough each day, I don't want to make more reasons for me to do so.

But beyond the oily mess there's also stuff getting stale. Stale Nutella is a pain because it's stiff and hard to deal with, and the kind of bread I like most is very soft and easily rips apart so spreading it on can be a real labor. Best method I've found is to spread a little bit on at a time but it takes so long to cover the whole face. Fine, it's a good sandwich, but in that same time I could have done something else. Maybe there's something in the freezer I could quickly heat up, or maybe there's some leftovers in the fridge I could eat. And if not there's pretty good odds that I need to go to the grocery store anyways.

Ah, sorry. Forgot why I'm here.

This topic has been moved to MySQL Help.

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

Hi

Is it possible to make a row(with number) increase every time the same value is added to the table?

Example:

I enter "test" into a table and it gets the following data:

id=1  name=test  count=1

And the next time I enter "test" into the table it becomes

id=1  name=test  count=2

instead of

id=1  name=test  count=1
id=2  name=test  count=1

I want to create a form where users can suggest stuff and I want to see what is the most popular ect.

Thanks in advance

This topic has been moved to Editor Help (Dreamweaver, Zend, etc).

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

Hi:

I have a site hosted (shared) on 1and1.com hosting, and they seem to have a file upload limit of 2MB.

Is there a way to overwrite this? I have been trying a .htaccess and php.ini file, but can't get it to work.

The folder with the upload form is called "admin," in the ROOT of the site.

Been trying (in both the ROOT and the "admin" folder):
php.ini
Code: [Select]
; Maximum size of POST data that PHP will accept.
post_max_size = 8M

; Maximum allowed size for uploaded files.
upload_max_filesize = 8M

ini_set('memory_limit','128M');

.htaccess (in both the ROOT and the "admin" folder):
Code: [Select]
php_value memory_limit 24M

That is all the code in each file - am I missing some code?

Can this be done?

Thank you.

I'm trying to increase the variables $schedulemonth, $scheduledate, $scheduleyear in each loop so that they look like $schedulemonth1, $schedulemonth2, $schedulemonth3, etc... for each of them.  I've tried several options and know I'm on the right track, but no go.

The customer will choose how many payments and the script below will loop that many times - I have that part working - but the calendar I'm using with the variables above is the issue.

Here's the code I'm using.

while ($balance > 0){

if ($balance>$monthlypayment){
$myCalendar = new tc_calendar("date" . $paymentnumber, true);$myCalendar->setIcon("images/iconCalendar.gif");$myCalendar->setDate($scheduledate, $schedulemonth, $scheduleyear);
//output the calendar
$myCalendar->writeScript();
echo "   ";
echo "<input type=\"text\" name=\"payment" . $monthlypayment . "\" value=\"" . $monthlypayment . "\">\n";
$paymenttotal=($monthlypayment+$paymenttotal);
$balance=round(($invoicetotal-$paymenttotal),2);
echo "&nbsp;&nbsp;&nbsp;Balance: $balance\n";
$schedulemonth++;
if ($schedulemonth==13){
$schedulemonth=1;
$scheduleyear=($scheduleyear+1);
}
echo "<br>\n";
}
if ($balance<$monthlypayment||$balance==$monthlypayment){
$myCalendar = new tc_calendar("date" . $paymentnumber, true);$myCalendar->setIcon("images/iconCalendar.gif");$myCalendar->setDate($scheduledate, $schedulemonth, $scheduleyear);
//output the calendar
$myCalendar->writeScript();
echo "&nbsp;&nbsp;&nbsp;";
echo "<input type=\"text\" name=\"payment" . $paymentnumber . "\" value=\"" . $balance . "\">\n";
$paymenttotal=($balance+$paymenttotal);
$balance=round(($invoicetotal-$paymenttotal),2);
echo "&nbsp;&nbsp;&nbsp;Balance: $balance\n";
$schedulemonth++;
if ($schedulemonth==13){
$schedulemonth=1;
$scheduleyear=($scheduleyear+1);
}
echo "<br>\n";
}
}


Additionally it needs to  pick up each of these variables on the next page  the variables are part of hidden fields in an form later in the page.  So my question is actually 3 fold.
1. How do I increase the variable count in the loop above.
2. How do I put the <input type="hidden".......> in the form so that it loops through and catches the increasing variables
3. How do I loop through on the insertion page after the form is submitted to catch how many inserts to the database are needed.

This one has me bent over.

I've created a quotation form and some of the values are passed in an array (i've used jQuery to clone the form for necessary fields).

I currently have the following:


foreach ($_GET as $var => $value) {  // Stick POST names into "$var" and the values into "$value"
if(!is_array($value)) { // Test us $value contains and array (horse detials are an array everything else isn't)
echo "<strong>$var:</strong> $value<br />\n"; // Echo out the customer detials and additional information
}
else { // If the value is an array....

} 
}
}


But i'm kind of stuck for ideas on how to echo out the rest of the details in the way i need it...

There are 6 arrays, I know I can do something like:

$array = $_GET['quote-details'];
    foreach($array as $detail) {
        echo "<strong>Detail:</strong> $detail<br />\n";
        }

But I have to do this  6 times...

I also want to sort these details in a logical manor, but again im a little stuck. So instead of it exporting like:

Detail1
Detail1
Detail1
Detail2
Detail2
Detail2

etc, I want it to export as:

Detail1
Detail2

Detail1
Detail2

If anyone can give me any help I would be VERY grateful!

Regards,
Mundo

Hi,
I have a Comma Delimited File called "houses.txt" with the contents of:

HA11QS, 200, house1.jpg, 4
HA22BR, 280, house2.jpg, 10
HA33AB, 390, house3.jpg, 3
HA44CD, 320, house4.jpg, 8

I have a web form "form2.html":
Code: [Select]
<html>
<head>

<title>Untitled Document</title>
</head>

<body>
<form action="any.php" method="post">

Please Enter Anything
<input type="text" name="any">

<input type="submit" value="Submit">
</form>
</body>
</html>
and PHP code of "any.php":

<?php

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

$filename = "houses.txt";

$fileOpen = fopen($filename, "r");

$max = $_POST['any'];

$rowsArr  = file ($filename);

foreach ($rowsArr as $row)

{

$lineDetails = $row;

$item_array = explode (",", $row);

if (in_array($max,$item_array))

{

echo("Post Code - " . $item_array[0]. "<br>");

echo("Price - " . $item_array[1]. ",000 <br>");

echo("Picture - " . $item_array[2]. "<br>");

echo("Number of Visits - " . $item_array[3]. "<br>");

echo("<br>");

}

}

fclose($fileOpen);
}
?>



What i need is for the user to input anything they wish for example:
4, which would search the array and find that the first house has had 4 visits or
HA44CD, to find the last house on the list etc ... however unfortunatley its not working for, if anyone can help me i would grateful

Thank You

Consider this scenario:

I'm using an ajax to make the form use only one page

I got a multistep form with step3 being the result of step2, within step3 there is an "add more steps" button which duplicates step2 and step3, this can be done countless times.

to complement this I added array to my input boxes something like this:
Code: [Select]
<input type="text" name="name[]" id="name"/>
unfortunately, I'm not sure how to approach this in the php.
In the step2 going to step3, I would call the brand id and use it in the database to get the results for step3, but now it's array
I added the following lines

$brand = $this->input->post('brand[]');
$this->load->model('MBest');
$q = $this->MBest->getbestmatching($brand[0]);


But the $brand[0] doesn't works and triggers an error.

And come to think of it, if I call a
$brand[0]
index, then everytime a person add a new step, it will always use the id of the first result.

Are there any ideas on how to fix this problem? Thanks

Hello! 

Why is it grouping the checked boxes instead of keeping them in order like area is?
if(isset($_POST['submit'])){
for($i=0; $i<10; $i++){
echo "<br />Ignore = [".$_POST['ignore'][$i]."]";

if($_POST['ignore'][$i]!="true")
echo ", Area = ".$_POST['area'][$i];
}
}
else
{
echo "<form method='post'><table>";
for($i=0; $i<10; $i++){
echo "
 <tr>
  <td><input type='checkbox' name='ignore[]' value='true' /></td>
  <td><input type='text' name='area[]' /></td>
 </tr>\n";
}
echo "
</table>
<input type='submit' name='submit' value='Submit' />
</form>";
}

Input:
Quote

Checked - ignored
Unchecked - a
Checked - ignored2
Unchecked - b
Checked - ignored3
Unchecked - c
Unchecked - d
Checked - ignored4
Unchecked - e
Checked - ignored5


Output:
Quote

Ignore = [true]
Ignore = [true]
Ignore = [true]
Ignore = [true]
Ignore = [true]
Ignore = [], Area = c
Ignore = [], Area = d
Ignore = [], Area = ignored4
Ignore = [], Area = e
Ignore = [], Area = ignored5

Hello,

Have the following form that takes data from the DB when u click on the text the left input increments when u click on it the same input decrement its value.

Have 2 main issues now:

1- the value of the input fields needs to be set after the post is submitted and having issue with that since it's an array.

2-after the submit the post is saved in an array (the out is showing in the attched image), need to choose each related item , price and quantity like product 1 price 1 quantity 1 so i can update the db later on.

All the Best

<form method='POST' action=''>
<?php 
if ($err1==0) {

  /*DB CODES...*/
  $num_rows = mysqli_num_rows($sql_1);

  if (isset($_POST["form_Order"]) && $_POST["form_Order"] == "form_Order") {
    
    $orderID=clean_input($_POST["orderID"]);
    $cat_Code=$_POST["cat_Code"];
    $sub_Cat_Code=$_POST["sub_Cat_Code"];

    $array_Order = array($_POST);
    print_r ($array_Order)."<br>";
    /*DB CODES...*/
    $res_sql_1 = mysqli_query($connection, $sql_2);

    /*additional codes*/


  }//end if $_POST

        while ($row_sql_Item = mysqli_fetch_assoc($res_sql_Item)) {

            $product_Name = $row_sql_Item["item"];
            $product_Price = $row_sql_Item["price"];
            $subCatCode=$row_sql_Item["sub_cat_code"];

            if(isset($_POST['productName[]'])){ $productname=$_POST['productName[]'];}else{ $productname=$product_Name;}
            if(isset($_POST['product_Price[]'])){ $productPrice=$_POST['product_Price[]'];}else{ $productPrice=$product_Price;}

            echo "<div>
            <input type='number' min='0' max='10' name='quantity[]' value='";
            if(isset($_POST['quantity']) && is_array($_POST['quantity'])){
              $quantitiez = array();
              foreach ($quantitiez as $quant){
                print $quant;
              }
            }else{ echo "0";}

            echo "' onclick=\"this.parentNode.querySelector('input[type=number]').stepDown();this.form.submit();\" class='productQuantity' readonly>
            <input type='text' min='0' max='10' name='productName[]' value='$productname' onclick=\"this.parentNode.querySelector('input[type=number]').stepUp();this.form.submit();\" class='productName' readonly>
            <input type='text' name='product_Price[]' value='$productPrice' class='productPrice' onclick=\"this.form.submit()\" readonly>
            <input type='hidden' name='orderID' value='$orderID'>
            <input type='hidden' name='cat_Code' value='$catCode'>
            <input type='hidden' name='sub_Cat_Code' value='$subCatCode'>
            <input type='hidden' name='form_Order' value='form_Order'></div>
            ";

        }//end While

}//end if $err1

?>
</form>

 

I have this form:     <form method="get">

I have a Form with 10 Questions that a User can choose to answer.

I am trying to store the "Answers" into an array like this...
Code: [Select]
<!-- Question 1 -->
<label for="question1">1.) Why did you decide to start your own business?</label>
<textarea id="question1" name="answerArray[0]" cols="60" rows="8"><?php if (isset($answerArray[0])){echo htmlentities($answerArray[0], ENT_QUOTES);} ?></textarea>
<?php
if (!empty($errors['question1'])){
echo '<br /><span class="error">' . $errors['question1'] . '</span>';
}
?>
<br />

<!-- Question 2 -->
<label for="question2">2.) What advice would you share with others on what NOT to do?</label>
<textarea id="question2" name="answerArray[1]" cols="60" rows="8"><?php if (isset($answerArray[1])){echo htmlentities($answerArray[1], ENT_QUOTES);} ?></textarea>
<?php
if (!empty($errors['question2'])){
echo '<span class="error">' . $errors['question2'] . '</span>';
}
?>
<br />


The problem is that when I process the Form, this code is causing issues...
Code: [Select]
if ($_SERVER['REQUEST_METHOD']=='POST'){
// Form was Submitted (Post).

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

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

I get this error...
Code: [Select]
Notice: Array to string conversion in /Users/user1/Documents/DEV/++htdocs/05_Debbie/members/create_thoughts.php on line 58
Call Stack
# Time Memory Function Location
1 0.0014 93944 {main}( ) ../create_thoughts.php:0
2 0.0716 102640 array_map ( ) ../create_thoughts.php:58

How can I either fix my code or change things to do what I need?

Thanks,


Debbie