PHP - Adding Multiple Page Numbers To While Loop

Ok I'm trying to insert multiple rows by using a while loop but having problems. At the same time, need to open a new mysql connection while running the insert query, close it then open the previous mysql connection.

I managed to insert multiple queries before using a loop, but for this time, the loop does not work? 
I think it is because I am opening another connection... yh that would make sense actually?

Here is the code:


$users = safe_query("SELECT * FROM ".PREFIX."user");
       while($dp=mysql_fetch_array($users)) { 
          
   $username = $dp['username'];
 $nickname = $dp['nickname'];
 $pwd1 = $dp['password']; 
 $mail = $dp['email'];
 $ip_add = $dp['ip'];
 $wsID = $dp['userID'];
 $registerdate = $dp['registerdate'];
 $birthday = $dp['birthday'];
 $avatar = $dp['avatar'];
 $icq = $dp['icq']; 
 $hp = $dp['homepage'];
 
echo $username." = 1 username only? :(";
      

// ----- Forum Bridge user insert -----

$result = safe_query("SELECT * FROM `".PREFIX."forum`");
$ds=mysql_fetch_array($result);
$forum_prefix = $ds['prefix'];
define(PREFIX_FORUM, $forum_prefix);
define(FORUMREG_DEBUG, 0);

$con = mysql_connect($ds['host'], $ds['user'], $ds['password']) or system_error('ERROR: Can not connect to MySQL-Server');
$condb = mysql_select_db($ds['db'], $con) or system_error('ERROR: Can not connect to database "'.$ds['db'].'"');
                
include('../_phpbb_func.php');
$phpbbpass = phpbb_hash($pwd1);
$phpbbmailhash = phpbb_email_hash($mail);
$phpbbsalt = unique_id();

safe_query("INSERT INTO `".PREFIX_FORUM."users` (`username`, `username_clean`, `user_password`, `user_pass_convert`, `user_email`, `user_email_hash`, `group_id`, `user_type`, `user_regdate`, `user_passchg`, `user_lastvisit`, `user_lastmark`, `user_new`, `user_options`, `user_form_salt`, `user_ip`, `wsID`, `user_birthday`, `user_avatar`, `user_icq`, `user_website`) VALUES ('$username', '$username', '$phpbbpass', '0', '$mail', '$phpbbmailhash', '2', '0', '$registerdate', '$registerdate', '$registerdate', '$registerdate', '1', '230271', '$phpbbsalt', '$ip_add', '$wsID', '$birthday', '$avatar', '$icq', '$hp')");
if (FORUMREG_DEBUG == '1') {
echo "<p><b>-- DEBUG -- : User added: ".mysql_affected_rows($con)."<br />";
       echo "<br />-- DEBUG -- : Query used: ".end($_mysql_querys)."</b></p><br />";
      
       $result = safe_query("SELECT user_id from ".PREFIX_FORUM."users WHERE username = '$username'");
       $phpbbid = mysql_fetch_row($result);
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('2', '$phpbbid[0]', '0', '0')");
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('7', '$phpbbid[0]', '0', '0')");
mysql_close($con);
}

         include('../_mysql.php');        
         mysql_connect($host, $user, $pwd) or system_error('ERROR: Can not connect to MySQL-Server');
mysql_select_db($db) or system_error('ERROR: Can not connect to database "'.$db.'"');
       
       }



So I need to be able to insert these rows using the while loop.. how can I do this?

I really appreciate any help.

I am writing a stock program and I am going to be getting several averages on volume over different periods, 10, 21, 50,100,120,150,200,240 are my averages.    I would like to make this fairly efficient, seeing as how its going to be a ton of data, I have over 7700 stocks in the database and they will each have all of those averages.    My question is how to do this that is the most efficient, I thought about taking the 10 day then adding 11 to it, then adding 29 to get the 50 day and so on and so forth, or is that too much work and I should just do each average individually? 

select avg(volume) from _AAPL where date between ‘2014-02-03’ and ‘2014-05-05’;

The above is my current very generic code that does work, now I just need to make a php script, which I can do, I am just curious about how different people would approach this.   Thanks for the help.
Edited by illcrx, 23 September 2014 - 10:32 PM.

I've been trying to go around with str_replace to replace numbers with words.
I have a database which has table actions. The actions are saved in numbers from 0 to 20.
I'd need to get something to replace the numbers with words to explain what actions these are.

I've tried using this.
$action1 = str_replace("5", "Command", "action1");
But that doesn't work. Not even 100% sure if that is even correct, because I am new to the str_replace thing anyway.

Could someone help me with this, please?

hello, i have created a table that desplays perticulars, price per person and number of people. the fees is then calculated by multiplying price per person with number of people. till now everything is good. but the problem is when i try to calculate the total fees.
here is an example to explain you better:
Perticulars Price Per Person Number of people Amount something 10 100 1000 something else 20 100 2000 Total 3000

Code: [Select]
$pert_query = mysql_query ("SELECT * FROM `perticulars` WHERE `invoice` =$invoice") or die(mysql_error());
$i = 1;
$sum = 0 + $_SESSION['sum'];
while($perticulars = mysql_fetch_array($pert_query, MYSQL_ASSOC)) {
?>
<tr>
      <td style="border-collapse: collapse"><div align="center"><?php echo $i;
  $i++; 
   ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['perticulars']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['ppc']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['nop']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center">
        <?php $amount = $perticulars['ppc'] * $perticulars['nop']; echo $amount; $_SESSION['sum'] = $sum+$amount;?>
      </div></td>
    </tr><?php 
} ?>
    <tr>
      <td colspan="4" style="border-collapse: collapse"><div align="center">Total</div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $sum; ?></div></td>
    </tr>
  </table>
From the above code you can see that i am getting the amount form $amount = $perticulars['ppc'] * $perticulars['nop'];
by this each row has its own amount which i got by multiplying the data from mysql.
the problem is how do i find out the Total. i know i am suppose to add up $amount but how?
i even tired using sessions to store the amount and add the new amount to get total but the problem in using sessions is it messes up my next page, no using session is a very bad idea.

I'm telling it to add 1 each time through the while loop but its not and not sure why.

Code: [Select]
<fieldset class="answerLeg">
        <legend>Edit Poll Answers</legend>
        <?php
        $j = 0;
        while($row2 = mysqli_fetch_array ( $pollAnswersResult, MYSQL_ASSOC )) { 
        ?>
            <div class="field required answers">
                <label for="answer<?php echo ($j + 1)?>">Answer #<?php echo ($j + 1)?></label><input type="text" class="text" name="answer<?php echo ($j + 1)?>" id="answer<?php echo ($j + 1)?>" title="Answer <?php echo ($j + 1)?>" value="<?php echo $row2['answer']; ?>"/>
                <span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>     
            </div>
        <?php } ?>
    </fieldset>

Hey guys,

I am trying to input data into a mysql database from data thats been added by a jquery form with cloned fields. It is working however it adds the first row correctly then a blank row and then the rest of the rows correctly

The code is this

$x=0;

do {
$fga=$_POST['ID'.$x.'fga'];
$fgm=$_POST['ID'.$x.'fgm'];
$fta=$_POST['ID'.$x.'fta'];
$ftm=$_POST['ID'.$x.'ftm'];
$tpa=$_POST['ID'.$x.'tpa'];
$tpm=$_POST['ID'.$x.'tpm'];
$fta=$_POST['ID'.$x.'fta'];
$ftm=$_POST['ID'.$x.'ftm'];
$stl=$_POST['ID'.$x.'stl'];
$trb=$_POST['ID'.$x.'trb'];
$ast=$_POST['ID'.$x.'ast'];
$blka=$_POST['ID'.$x.'blka'];
$blkf=$_POST['ID'.$x.'blkf'];
$tovr=$_POST['ID'.$x.'tovr'];

mysql_query("INSERT INTO stats (gameId, fga, fgm, tpa, tpm, fta, ftm, ast, stl, trb, blka, blkf, tovr) VALUES ('$gameId', '$fga', '$fgm', '$tpa', '$tpm', '$fta', '$ftm', '$ast', '$stl', '$trb', '$blka', '$blkf', '$tovr')")or die("<div class='errmsg'>Insert Error: ".mysql_error()."</div><br /> \n");

$x++;

Can anyone see what ive done wrong?

Thanks

Hi,

I have a database with some rows. in each row there is a number such as: 0.0023 or 0.0135...

I have the following code to loop though them and add the numbers up but it always returns 0?

Code: [Select]
$sql="SELECT * FROM tickets WHERE `round` = '$round' AND `confirmed` = 'yes' ORDER BY id ASC";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);

while($row = mysql_fetch_array( $result )) {
   $balance = $balance + $row['amount'];
}

hi i have got the following issues i am using the following code.

Code: [Select]
<?php

//DB CONNECTION

$ROWS = "id,firstname,lastname";

// explode at the comma and insert into an array
$test = explode("," , $ROWS);

//adds array test to the var sam
$sam = array($test);

// querys the database
$new = mysql_query("SELECT * FROM {$DB_TABLE}");

// while loop to loop through selected fields
while ($row = mysql_fetch_array($new)) {

foreach ($sam[0] as $v) {

echo $row[$v] . $DELIMITER . "<br />";

}

}
?>
i get the following results.

834(|)
Steph(|)
Thompson(|)
835(|)
Lucy(|)
kim(|)
836(|)
Iwan(|)
Will(|)
837(|)
Sarah (|)
Good(|)

The problem i have is the br tag where do i put it because i need it to output like this. like it shows in the $ROWS variable above "$ROWS = "id,firstname,lastname";";


834(|)Step(|)Thompson(|)
835(|)Lucy(|)kim(|)
836(|)Iwan(|)Will(|)
837(|)Sarah (|)Good(|)

Where do i add the br tag???

Any Help PLease

Hello,

I have a database that contains a column with a int value for number of slots reserved, and what I want to do is fetch the value of each column and add them together to create one whole number. For example, in my database under preserved I have two separate values of 2 and 4.. I would like to take those two values and add them up into 6 through php... here is what I have so far:


$slots = mysql_query("SELECT * FROM treservations WHERE reservation_date='$reservation_date' AND reservation_hour='$reservation_hour'") or die(mysql_error());
while ($row = mysql_fetch_assoc($slots)) {
     $row["preserved"];
}

mysql_free_result($slots);

Any help would be GREATLY appreciated.. if I need to add additional code please let me know. Thank you!

Hello everyone, i am working on a page that displays news topic and would like to have the page numbers at the bottom of the page as links. You know the usual prev (link) then list couple of pages and then next (link).

prev - 1 2 3 4 5... next

below is the code i have to count my records on my db and display them. but the problem with this is that it displays all of them. page 1 through 50.

Code: [Select]
$query2 = "SELECT COUNT(title) FROM news";
$result2 = mysql_query($query2);
$row = mysql_fetch_row($result2);
$total_records=$row[0];
$total_pages = ceil($total_records / 5);


for ($i=1; $i<=$total_pages; $i++)
{
if ($i!=1 and $i !=10) { print "<a href='newsevents.php?page={$i}'> " .$i. " </a>"; }
if ($i==$total_pages)
{
print"<p><a href='newsevents.php?page={$i}'> Last Page </a>";
}
if ($i==1)
{
print "<p class='floatleft'><a href='newsevents.php?page={$i}'> First Page </a>";
}


}



Can someone help?

Hope someone can help, I am trying to add up all the values of a variable in a PHP while loop and have tried several approaches but none seem to work. Hopefully someone can point out what the correct method is.

I've set up some code to pull the pay rate from a MySQL table, and then calculate that person's earnings based on the amount of time they spend on a particular job. That works fine:

           while ($row = $getrate->fetch_assoc()) {

              $staffrate = $row["Rate"];

              $earnings = ($staffrate/3600) * $jobeventtimeseconds;

              $earningsformatted = number_format($earnings, 2);

           }

However there may be a number of jobs for different people with different rates, so I want to add all of these up and output the total. So for example if I had values of 125.00, 35.50 and 22.75 I want to show 183.25 as the total.

So I tried a few things I found on forums on the subject:

$totalearnings = 0;

foreach($earningsformatted as $key => $value) {

   $totalearnings += $value;

}

echo $totalearnings;

That didn't work so I tried another method that someone suggested:

$total=array($earningsformatted);

echo array_sum($total);

The 2nd method outputted just the last individual value, the 1st method didn't work at all. Does anyone have a working method that can be used to do this?

Thanks

Hi I have currently written some code which uses of the Twitter API and extracts the information required to display my most current tweet on my website. This is all working perfectly but at the minute it is only displaying one tweet and I would like it to display as many as the variable $limit is set to.

I have tried numerous count with while loops but just cannot seem to get my head around the logic of it.

Here is the code im currently using which displays one tweet.


            <?php

$username = "my_twitter_username";
$limit = "2";
$twitter_url = "http://twitter.com/statuses/user_timeline/$username.xml?count=$limit";

$buffer = file_get_contents($twitter_url);
$xml = new SimpleXMLElement($buffer);

$status_item = $xml -> status;
$status_id = $xml -> status -> id;
$user_item = $xml -> status -> user;
$user_id = $xml -> status -> user -> screen_name;
$description =  $status_item -> text;
$status_time =  $status_item -> created_at;
$status_img = $user_item -> profile_image_url;

$description = preg_replace("#(^|[\n ])([\w]+?://[\w]+[^ \"\n\r\t< ]*)#", "\\1<a href=\"\\2\" target=\"_blank\">\\2</a>", $description);
        $description = preg_replace("#(^|[\n ])((www|ftp)\.[^ \"\t\n\r< ]*)#", "\\1<a href=\"http://\\2\" target=\"_blank\">\\2</a>", $description);
        $description = preg_replace("/@(\w+)/", "<a href=\"http://www.twitter.com/\\1\" target=\"_blank\">@\\1</a>", $description);
        $description = preg_replace("/#(\w+)/", "<a href=\"http://search.twitter.com/search?q=%23\\1\" target=\"_blank\">#\\1</a>", $description);

echo "
<div class='tweet-wrapper'>
<div class='tweet-img'>
<a href='http://www.twitter.com/la__academia' target='_BLANK'><img src='$status_img' alt='La Academia Twitter' style='width:30px height:30px;' /></a>
</div><!-- tweet-img -->
<div class='tweet-text'>
<p class='tweet-p'>$description</p>
<p class='tweet-time'>$status_time . <a href='http://twitter.com/?status=@$user_id%20&in_reply_to_status_id=$status_id&in_reply_to=$user_id' target='_BLANK' class='tweet-reply'>Reply</a></p>
</div><!-- tweet-text -->
<div class='cleaner'></div>
</div><!-- tweet-wrapper -->
";

?>

Thanks for any help.

I am trying to get info from a table, add rows in that table, and put the added value back into the table in another field...I want to add field1 and field2 of every row and put the total in the total row.
Heres what the echo gives me

Susan 14

Mary 18

Bob 13

Sam 21

heres the database
mysql> SELECT total_val FROM table;

+-----------+
| total_val |
+-----------+
|        21 |
|        21 |
|        21 |
|        21 |
+-----------+



heres the code....


<?php

require("connection.php");


mysql_select_db("database", $connection);
echo "<br />";

$result = mysql_query("SELECT * FROM table");

while($row = mysql_fetch_array($result))
  {
   
     $values = ($row['field1'] + $row['field2']);
    
    
   
   
   $sql=mysql_query("UPDATE table SET total = '$values'");
   
      
  echo $row['user_name'] . " " . $values;
  echo "<br />";
   
  }

?>

also note that if I put a INT in place of $values - the echo changes to match...why??

PLEASE help...I have been working on this for 2 entire days....

Hi all,

I'm trying to write a function to return an array. But it keeps returning an empty array with NULL values ....

This is my code.


   function ShowUserData ($uid)
   {
      $con = mysql_connect("localhost","user","pass");
      if (!$con)
       {
          die('Oops !! something went wrong with the DB connection, Server said ' . mysql_error());
      }

      mysql_select_db("db", $con);
      
      $password = md5($password);
      
      $query = mysql_query("SELECT * FROM `table` WHERE `uid` = '".$uid."'");
      $num = mysql_num_rows($query);
      
      while ($row = mysql_fetch_array($query, MYSQL_NUM)) {
          $outArray = array('uid' =>$row['uid'], 'email' => $row['email'], 'name' => $row['name']); 
      }
      return $outArray;      
   }

what am i doing wrong?

mysql_query("update pupils set record='running' where pid !='$testing[0]'