PHP - Looping Value Increase Resulting In Odd And Even Numbers

I have a text file with the following:

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

I have a form:
Code: [Select]
<?php

if (isset($_POST['price']))
{
$filename = "houses.txt";
$fileOpen = fopen($filename, "r");
$max = $_POST['price'];
$rowsArr  = file ($filename);
foreach ($rowsArr as $row)
{
$lineDetails = $row;
$item_array = explode (",", $row);

if (((int) $item_array[1]) <= $max)
{
?>
                <form action='visit2.php' method='post'>
                <?php
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>");
?>
               
<input type='checkbox' name='mybox'>
<input type='submit' value='Visit Property'>
</form>
<?php
}


}
fclose($fileOpen);
}
?>

and i also have "visit.php"

Code: [Select]
<?php

if (isset($_POST['mybox']))
{
$filename = "houses.txt";
$fileOpen = fopen($filename, "r+");

$filename2 = "houses2.txt";
$fileWrite = fopen($filename2, "w");



$visit = $_POST['mybox'];

$rowsArr  = file ($filename);
foreach ($rowsArr as $row)
{
$lineDetails = $row;
$item_array = explode (",", $row);

$fileText = $item_array[3]+1;


if ($visit == true)
{

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>");
fwrite($fileWrite, $fileText);

}


}
fclose($fileOpen);
fclose($fileWrite);

}


?>
What i need is , when the user in the form, clicks on the checked box, it sends the information to 'visits.php' and it writes to the text file, increasing the selected value by one

Please can anyone help, im really struggling with this

Thank You

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

I have a proposal solicitation application where I select typically 5 or so individuals and they get individual emails such as "Hello Bob, please click <here> if you wish to provide pricing for the following scope of work..."  It uses PHPmailer with a smtp gmail account.  The FROM name is my name, the FROM email is an email account associated with the application <bidding@bidsoliciationapp.com>, and the REPLY-TO name and email are both mine. 

A while back, individuals have told me that my emails often windup in their spam folder.

What might be causing this and what can be done to decrease its likelihood?

One potential culprit is all of the emails have a small footer with a disclaimer and a link back to a website, but the link utilized https which was no longer supported on the site and was broken.  Maybe related?

Thanks

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

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

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 "&nbsp;&nbsp;&nbsp;";
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.

ok I'm a bit stuck here were I would think something would work easily im getting an error.

What I am trying to loop is..


$data="UPDATE ts12 SET djid='$_POST[TS0]' WHERE id=1";
$data="UPDATE ts12 SET djid='$_POST[TS1]' WHERE id=2";

This would go on for 84 id's. So I figured I could just loop this line so I only have to type it once. Right now I have it set up for just testing 7 ids and I have this code....

if ($edit == yes) {
for ($i=0; $i < 7; $i++){ $n=($i+1);
$data.="UPDATE ts12 SET djid='$_POST[TS$i]' WHERE id=$n";
}
if (!mysql_query($data,$con))  die('Error: ' . mysql_error());
}else{}

The error I am getting is...
PHP Parse error:  syntax error, unexpected T_VARIABLE, expecting ']' in dir/page on line 6


What am I doing wrong here?

Take a look he
http://answers.yahooapis.com/AnswersService/V1/questionSearch?appid=YahooDemo&query=test

That is a generated XML file from Yahoo's API. If you take a look, it has a node titled "Question". With PHP, how can I loop through each "Question" node and grab all of it's children as well?

I tried this code, but apparently it did not work:


$req = "http://answers.yahooapis.com/AnswersService/V1/questionSearch?appid=YahooDemo&query=php";
$res = file_get_contents($req);
$xml = simplexml_load_string($res);

foreach ($xml->xpath('//Question') as $question) { // "//question" means for each question node
  echo((string)$question['Subject']." - ".(string)$question['Content']); // you get all the child nodes in $question
} 

I am pulling data from an sql data base. I want it to displayed (Item # | Error button | Link) however as its looping with a while on the database info I cant seem to get it to loop on the item number so it shows 1, 2, 3,.... on each row.

Current coding is:

while ($info = mysql_fetch_array($data)){

Print '<tr>';
Print"<td style='width: 15px;' class='cat-list'>$D</td>";

if ($info['id']==""){
Print"<td class='cat-list'>&nbsp;</td>";
}else{
Print"<td class='cat-list' style='width: 20px;'><img border='0' src='images/error.png' width='16' height='16'></td>";
}

if ($info['link']==""){
Print"<td class='cat-list'>&nbsp;</td>";
}else{
Print"<td class='cat-list'><a target='_blank' href='".html_entity_decode(stripslashes($info[link]))."'>".substr(html_entity_decode(stripslashes($info[link])), 0, 85)."</a></td>";
}
}



How would I get the $D item to show 1 2 3... ect?

Thanks,
Jim

i have this bit of code which is supposed to do a while loop of rows from a database then inside that does a while loop of columns, so its basically creating a html table of dynamic data from mysql.

the column loop works fine, but the row one isnt, it only goes through and echos out the first row then stops.

ive spent hours now trying to see why and i cant see it hence my call for help.


$totalrows = 4;
$columns = 5;
$columncount = 1;
$rowcount = 1;

echo "<table>";
while ($rowcount <= $totalrows) {
echo "<tr>";
$sql = "SELECT * FROM ville_map WHERE id = '$rowcount'";
$sql_result = mysql_query($sql, $connection); 
while ($row = mysql_fetch_array($sql_result)) { 
$c1 = explode(',', $row["c1"]);
$c2 = explode(',', $row["c2"]);
$c3 = explode(',', $row["c3"]);
$c4 = explode(',', $row["c4"]);
$c5 = explode(',', $row["c5"]);

while ($columncount <= $columns) {
$arraynum = ${'c'.$columncount};
 if ($arraynum[2] > 0) { $playerimage = '<img src="images/player' .$arraynum[2]. '.png"'; } else { $playerimage = ""; }
echo '<td background="images/' .$arraynum[0]. '.jpg" width="50" height="50">' .$playerimage. '</td>' ;
$columncount++;
}
}
echo "</tr>";
$rowcount++;
}
?>
</table>


any help would be much appreciated.

Hey,

I have the following code that gets the name of the course from the XML.

XML Snippet
Code: [Select]
<?xml version="1.0"?>
<courses>
  <course>
    <id>70</id>
    <name>Marketing and Social Media</name>
    <dates>
      <date>
        <instance_id>6747</instance_id>
        <location />
        <course_type>Day</course_type>
        <date_available>2011/07/13</date_available>
        <time_start>9:30</time_start>
        <time_end>17:00</time_end>
        <availibility>7</availibility>
        <running_dates>
          <running_date>2011/07/13</running_date>
          <running_date>2011/07/14</running_date>
        </running_dates>
      </date>
    </dates>
  </course>
  <course>
</courses>

PHP
Code: [Select]
$dom = new DomDocument();
$dom->load("courses.xml");
$xp = new domxpath($dom);

$titles = $xp->query("/courses/course/name");
foreach ($titles as $node) {

    print $node->textContent . " ";

}


This prints out the course name fine. My question is how Can i get the rest of the data from the same query. For example why cant I do something like..

Code: [Select]
...
foreach ($titles as $node) {

    print $node->name. " ";
    print $node->time_start. " ";
    print $node->course_type. " ";

etc..

}


So I want to loop through get the name and assign the rest of the nodes in there to variables or something.

ok, here is some code:
Code: [Select]
<?php
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM products");
while($row = mysql_fetch_array($sql)){
$product = $row["product"];
?>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="http://ajax.microsoft.com/ajax/jquery.validate/1.7/jquery.validate.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#myform").validate({
debug: false,

submitHandler: function(form) {
// do other stuff for a valid form
$.post('process.php', $("#myform").serialize(), function(data) {
$("#price").load("index.php #price");
$('#results').html(data);
});
}
});
});
</script>
<form name="myform" id="myform" method="POST" action=""> 
     
        <input type="hidden" name="hiddenField" id="hiddenField" value="<?php echo $product; ?>" />
<input type="submit" name="submit" value="Submit" style="background-color:lightgreen; height:50px; width:100px;">     </form> 

<?php

}
?>and here is process.php Code: [Select]
<?php
include_once("/connect.php");
?>
<?php 
$price=$_POST['hiddenField'];
 $sql = "INSERT INTO cart (price) 
VALUES('$price')";
 $rs = mysql_query($sql) or die ("Problem with the query: $sql<br>" . mysql_error());
echo mysql_error();
?>.

what is happening is it is supposed to be submitting form without page reload.......but only the first one in the loop does it.  I want all of them to do it.  can anyone help me do this properly.

ANYONE WHO CAN HELP ME WITH MY LOOP? THIS IS THE CODE THANKS IN ADVANCE. <?php
$testTwo = 'bakit ayaw po gumana paulit ulit bakit';
$testOne = 'bakit paulit ulit bakit ulit';
$tTwo = explode(' ', $testTwo);
$tOne = explode(' ', $testOne); echo"SIMILARITIES:</br>";
foreach($tOne as $first) {
foreach($tTwo as $second) {
if($second == $first) {
echo $second.'&nbsp';
} 
} 
echo"</br>"; 
} ?> THIS IS THE OUTPUT SIMILARITIES:
bakit bakit 
paulit 
ulit 
bakit bakit 
ulit THIS IS MY EXPECTING OUTPUT.
bakit
paulit
ulit
bakit 
ulit 
lang