PHP - $data $array - The Print Result Mashes All The Numbers Together

I have a cards array, and I have this function which will shuffle the cards for me. How can I edit this to 'deal' 12cards (6 & 6) until all the cards are a specific 6 & 6 I pick out?

Code: [Select]
   function ShuffleCards(&$cardsArray, $times)
   {
    // Randomizes where to split within center (-3 to +3 from dead center)
(MINIMUM 10 CARDS IN DECK)
    // Splits into two array. Randomizes how many cards from left and how
many cards from right (between 1 and 3)
    // Alternates sides. Continues until both arrays are empty.
    $arraySize = count($cardsArray);

    if($arraySize<10)
     return;

    $deadCenter = $arraySize/2;

    for($i=0;$i<$times;$i++)
    {
     reset($cardsArray);

     $cutVariant = rand(-3, 3);
     $cutLocation = $deadCenter+$cutVariant;

     $firstArray = array();
     $secondArray = array();

     for($z=0;$z<$arraySize;$z++)
     {
      if($z<$cutLocation)
       array_push($firstArray, $cardsArray[$z]);
      else
       array_push($secondArray, $cardsArray[$z]);
     }

     $bottomFirst = rand(0, 1);
     $cardsArray = array();

     while(count($firstArray) && count($secondArray))
     {
      $leftNewCards = array();
      $rightNewCards = array();

      $leftVariant = rand(1, 3);
      if($leftVariant>count($firstArray))
       $leftVariant = count($firstArray);

      $rightVariant = rand(1, 3);
      if($rightVariant>count($secondArray))
       $rightVariant = count($secondArray);


      for($x=0;$x<$leftVariant;$x++)
      {
       array_push($leftNewCards, array_shift($firstArray));
      }

      for($y=0;$y<$rightVariant;$y++)
      {
       array_push($rightNewCards, array_shift($secondArray));
      }

      if($bottomFirst==0)
      {
       $newCardsArray = array_merge($leftNewCards, $rightNewCards);
       $bottomFirst = 1;
      }
      else
      {
       $newCardsArray = array_merge($rightNewCards, $leftNewCards);
       $bottomFirst = 0;
      }

      reset($newCardsArray);

      while(count($newCardsArray))
      {
       array_push($cardsArray, array_shift($newCardsArray));
      }
     }

     if(count($firstArray))
     {
      while(count($firstArray))
       array_push($cardsArray, array_shift($firstArray));
     }
     if(count($secondArray))
     {
      while(count($secondArray))
       array_push($cardsArray, array_shift($secondArray));
     }
    }
   }

Hi I would like to use regex in php for this array :

    $strings = array("words", "test" ,"1=1");

words and test is ok , but I want set 1=1 like $i=$i for any value (just numbers)

2=2 or 10=10 and ....

So I already have this below...

$state = array (
    1 => 'Sectional',
    2 => 'Regional',
    3 => 'Semi-state',
    4 => 'State'
);

Can those numbers be a range -- 1-16, 17-32, 33-48 and 49-64 -- without just listing them all?

 

 

Hello all, I am newbie to php programming, any suggestions or advance greatly appreciated.

I can't figure out how to output two array random numbers in ascending order.

<?php

$l_numbers = array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27,
 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47);
 
$mega = range(1, 27);


for($i = 0; $i <= 4; $i++)  {


 $random1 = array_rand($l_numbers);
  echo "$random1 \n" ;
}
for($e = 1; $e <= 1; $e++) {

 $random2 = array_rand($mega);
  echo "<p> Mega number is $random2 </p>";
}

echo "Winning numbers are $random1 and mega $random2";

?>

example: Winning numbers are 3,5,10,17,39 and mega 5.

so here the code that i am confusing the whole month , how can i get it to print out the filtered data

$sql="SELECT COUNT(*) as conflicts
        FROM rental
        WHERE Dispatch < :dropoff AND Dropoff > :dispatch";
$stmt = $pdo->prepare($sql);
$stmt->execute( [ 
                   'dropoff'  => $Dropoff,
                   'dispatch' => $Dispatch
                ]);

im so frustrated on myself that cant do anything

Hi guys,

I have a little problem here. I have stored the data in firstname column of mysql database. I am trying to achieve by print the data from the mysql and input the data on my php page, but the page is blank.

Here it is the code:


<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'myusername');
    define('DB_PASSWORD', 'mypassword');
    define('DB_DATABASE', 'mydatabasename');
       
    $errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {
  die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
  
    $login = clean($_GET['user']);
    $password = clean($_GET['pass']);
    if($login == '') {
  $errmsg_arr[] = 'Login ID missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD ID missing';
  $errflag = true;
    }

    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
  $qry="SELECT * FROM members WHERE login='$login' AND passwd='$password'";

  $result=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());


if(mysql_num_rows($result) > 0) {

  $row = mysql_fetch_row($result);
    $firstname = htmlspecialchars($author['firstname']);
    echo("$firstname <br>");
      }
else {


echo 'Username and/or Password not found.';
}
}
?>


Do you know why the php page is blank as I effort to get the data from mysql??

Any idea??

Hi all,

This has just been bugging me forever, I actually just hardcoded the line it in years ago to just be done with it.  But when I use the while loop to pull up the data for this table, it prints out every row but the last one.  I've wracked my brain for years trying to fix it, and just cannot find the solution.  Below is the entire page code I'm using and you can see at the bottom what I have sadly hardcoded in to make the last row display.  That's the row that will not show up.  If you want to see the actual live page it's he

https://www.lakerstats.com/numerical-roster/

The UNK line at the end if the one that never prints out that I hardcoded.

Page code as mentioned above. Appreciate any help!

[php]
$db = mysql_connect("localhost", "xxxx", "xxxx");

mysql_select_db("lakerstats",$db);
echo "<table class=numeric WIDTH=100% cellpadding=0 cellspacing=0 border=0>

<tr><td class=left colspan=\"2\" height=10><font size=\"2\" color=#000000>Current players are listed in ALL CAPS.<br />Retired uniforms are listed in <b><font color=\"#FF0000\">red</font></b>.<br /></font></td></tr><tr>";

$uniforms = "SELECT p.fname, p.lname, p.playerid, u.number, p.current_roster, u.retired, u.retired_player, p.profile_name, p.uniform_1, p.uniform_2 FROM player p, uniforms u WHERE u.number = p.uniform_1 or u.number = p.uniform_2 or u.number = p.uniform_3 or u.number = p.uniform_4 ORDER BY u.number+0, p.years, p.lname, p.fname";

$uniresult = mysql_query($uniforms) or die ("Query failed");
$numofrows = mysql_num_rows($uniresult);

//let's get the number of rows in our result so we can use it in a for loop

$temp = "0";
$sHTMLTemp = "";
while ($unirow = mysql_fetch_array($uniresult)) // Where $result is your result set
{
if ($temp != $unirow['number'])
  {
    $temp = $unirow['number'];
    if ($unirow['number'] == "100") {
    $unirow['number'] = "0";
    } else if ($unirow['number'] == "101") {
    $unirow['number'] = sprintf("%02d", 0);
    } else if ($unirow['number'] == "102") {
    $unirow['number'] = "UNK";
    } else {    
    $unirow['number'] = $unirow['number'];
    }

    $sHTMLTemp = preg_replace("/(.+),/","\\1",$sHTMLTemp);
    print $sHTMLTemp ;
    print "</tr>";

     $sHTMLTemp = "";


 if ($unirow[retired] == "yes") {
    echo "<tr><td class=left height=10><font size=\"2\" color=\"#FF0000\"><b>#" . $unirow[number] . "</b></font><font size=\"2\"> - ";
} else {
    echo "<tr><td class=left height=10><font size=\"2\" color=\"#000000\">#" . $unirow[number] . "</font><font size=\"2\"> - ";
}

}

 if ($unirow[current_roster] == "yes") {
$unirow[fname] = strtoupper($unirow[fname]);
$unirow[lname] = strtoupper($unirow[lname]);
} else {
$unirow[fname] = $unirow[fname];
$unirow[lname] = $unirow[lname];
}

 if ($unirow[retired_player] == $unirow[playerid]) {
$sHTMLTemp .= "<b><a href=\"/player-stats-bio/?pname=".$unirow['profile_name']."\"><font color=\"#FF0000\">" . $unirow['fname'] . " " . $unirow['lname'] . "</font></a></b>, ";
} else {
$sHTMLTemp .= "<a href=\"/player-stats-bio/?pname=".$unirow['profile_name']."\">" . $unirow['fname'] . " " . $unirow['lname'] . "</a>, ";
}

}


echo "<a href=\"/player-stats-bio/?pname=jim_fritsche\">Jim Fritsche</a>, <a href=\"/player-stats-bio/?pname=bobby_watson\">Bobby Watson</a>";

echo "</font></td></tr>";

echo "</font></td></tr></table>";

mysql_close($db);
[/php]

 

Edited September 14, 2020 by ban5150

Hello I would like to know how to print data generated by PHP into a bond paper? is there a php function that i can use?

Hi,

What I'm trying to do is create a script that generates a random list of cars whenever it is run. I have a list of available cars in a MySQL database. I'm just not sure how to get php to generate a list of, say, 20 cars, that are randomly picked from the cars in the database. I may also want to add other statistics like MPG (also already in the database). Can anyone show me how to do this? And is it possible to format the returned data in a table or div format?

Thanks in advance
Unk

so this is my code


Code: [Select]

<?
$b=$_GET['b'];
$m=$_GET['m'];
$y=$_GET['y'];

if  ($b <> '' && $m <> '' && $y <> '') {

$branch=$b;
$leavemonth=$m;
$leaveyear=$y;
}
else
{
$branch=$_POST['branch'];
$leavemonth=$_POST['leavemonth'];
$leaveyear=$_POST['leaveyear'];
}



$connection=mysql_connect("$server", "$username", "$password")
or die("Could not establish connection");
mysql_select_db($database_name, $connection)
or die ("Could not select database");


   
    $query="SELECT * from tblworkgroup";
    $result=mysql_query($query);?>


        &nbsp;&nbsp;Branch&nbsp;
        <select name="branch" >
<option value="all">ALL Branches</option>       
        <? while($row=mysql_fetch_array($result)) { ?>       
    <option value= "<?=$row['WorkGroupID']?>" <? if ($branch==$row['WorkGroupID']){ echo 'selected'; } ?> ><?=$row['WorkGroupName']?></option>
     <? } ?>
        </select>
           </td>
          </tr>
       <br><br><br>
  &nbsp;&nbsp;Month &nbsp;&nbsp;
<select name="leavemonth" >
<option value = "1" <? if ($leavemonth==1){ echo 'selected'; } ?>>January</option>
<option value = "2" <? if ($leavemonth==2){ echo 'selected'; } ?>>February</option>
<option value = "3" <? if ($leavemonth==3){ echo 'selected'; } ?>>March</option>
<option value = "4" <? if ($leavemonth==4){ echo 'selected'; } ?>>April</option>
<option value = "5" <? if ($leavemonth==5){ echo 'selected'; } ?>>May</option>
<option value = "6" <? if ($leavemonth==6){ echo 'selected'; } ?>>June</option>
<option value = "7" <? if ($leavemonth==7){ echo 'selected'; } ?>>July</option>
<option value = "8" <? if ($leavemonth==8){ echo 'selected'; } ?>>August</option>
<option value = "9" <? if ($leavemonth==9){ echo 'selected'; } ?>>September</option>
<option value = "10" <? if ($leavemonth==10){ echo 'selected'; } ?>>October</option>
<option value = "11" <? if ($leavemonth==11){ echo 'selected'; } ?>>November</option>
<option value = "12" <? if ($leavemonth==12){ echo 'selected'; } ?>>December</option>
</select>

&nbsp;&nbsp;
Year &nbsp;&nbsp;
<select name="leaveyear" >
<option value = "2010" <? if ($leaveyear==2010) { echo 'selected';} ?>>2010</option>
<option value = "2011" <? if ($leaveyear==2011) { echo 'selected';} ?>>2011</option>
<option value = "2012" <? if ($leaveyear==2012) { echo 'selected';} ?>>2012</option>
<option value = "2013" <? if ($leaveyear==2013) { echo 'selected';} ?>>2013</option>
<option value = "2014" <? if ($leaveyear==2014) { echo 'selected';} ?>>2014</option>
<option value = "2015" <? if ($leaveyear==2015) { echo 'selected';} ?>>2015</option>
<option value = "2016" <? if ($leaveyear==2016) { echo 'selected';} ?>>2016</option>
<option value = "2017" <? if ($leaveyear==2017) { echo 'selected';} ?>>2017</option>

</select>


  &nbsp;&nbsp;

<input type='submit' name='submit' value='Preview' Class="button" onclick='return validate()'>
   
   </div>

</form>


<br /><br />

<div id="box" valign="top">
                <h3>&nbsp;<strong>Leave Application Details</strong>&nbsp;&nbsp</h3>
<br><br>
<FORM name="printbutton" method="post" align="left" action="report_print.php" target="_blank">
<input type="hidden" name="leavemonth" value="<?php echo $leavemonth; ?>">
<input type="hidden" name="leaveyear" value="<?php echo $leaveyear; ?>">
<input type="hidden" name="branch" value="<?php echo $branch;?>">
<Input type = "Submit" Name = "Submit1" Class="button" VALUE = "Print Leave Details">
</form>
                <table width="80%" align="center" >
<thead>
<tr>
<th width="700px" align="left">Name</a></th>
                           
<th width="500px" align="center"></a>Application Date</th>

<th width="500px" align="center"></a> </th>
                           
<th width="500x" align="right"></a>Reason</th>
</tr>
</thead>
<tbody>
<?
/*echo "branch:".$branch.'<br />';
echo "leavemonth:".$leavemonth.'<br />';
echo "leaveyear:".$leaveyear.'<br />';*/
//--------------------------------------------------
if ($leavemonth =='' ||  $leaveyear =='' || $branch == '') {
// one value missing, so don't display
}
else
{
// start display data
$branchtracker = '';

if ($branch=='all'){
$branch = '%';
}

$rs = mysql_query( " call vwleavereport('$leavemonth', '$leaveyear', $branch, 0);");
$query="SELECT *,
MONTH(tblleaveapplication.DateFrom) as DFMonth,
MONTH(tblleaveapplication.DateTo) as DTMonth,
YEAR(tblleaveapplication.DateFrom) as DFYear
FROM `tblleaveapplication`
LEFT JOIN `tblemployee`
ON tblleaveapplication.employeeid = tblemployee.id
WHERE WorkGroupID LIKE '".$branch."'
AND (
(MONTH(tblleaveapplication.DateFrom)=".$leavemonth." AND YEAR(tblleaveapplication.DateFrom)=".$leaveyear.")
OR
(MONTH(tblleaveapplication.DateTo)=".$leavemonth." AND YEAR(tblleaveapplication.DateFrom)=".$leaveyear.")
)
ORDER BY WorkGroupID
";

$result = mysql_query($query);
while($row=mysql_fetch_array($result))
{
if ($branchtracker<>$row['WorkGroupID']){
echo '<tr><td colspan=4 style="background-color: #e8e8e8; font-weight: bold;">'.$row['WorkGroupID'].'</td></tr>';
$branchtracker = $row['WorkGroupID'];
}
echo '<tr>';
echo '<td>'.$row['EmployeeName'].'</td>';
echo '<td>'.$row['DateFrom'].'</td>';
echo '<td>'.$row['DateTo'].'</td>';
echo '<td>'.$row['Purpose'].'</td>';
echo '</tr>';
}

}
?>


the problem is i want the print button only appear when there is output..

Hi guys,

I have a problem of prints of the data from table1. I am checking out the data of username and password in the url to go through in members table and then checking the username in table1 to get matching data and select rows with the fields id of teststrings1, teststrings2 and teststrings3, then print out the data.


Here it is the code


<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'myusername');
    define('DB_PASSWORD', 'password');
    define('DB_DATABASE', 'mydatabasetable');
       
    $errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {
  die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
  
    $username = clean($_GET['user']);
    $password = clean($_GET['pass']);
    if($username == '') {
  $errmsg_arr[] = 'username ID missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD ID missing';
  $errflag = true;
    }

    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
  $qry="SELECT * FROM members WHERE username='$username' AND passwd='$password'";
  $result=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());


    if($result) { 
  $qrytable1="SELECT teststrings1, teststrings2, teststrings3 FROM table1 WHERE username='$username'";
  $result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());
  echo "<p id='teststrings1'>";
  echo $row['teststrings1'] . "</p>";
  echo "<p id='teststrings2'>";
  echo $row['teststrings2'] . "</p>";
  echo "<p id='teststrings3'>";
  echo $row['teststrings3'] . "</p>";
  }
 }
?>


When I am am checking the data of username and password through in members table and then checking the username in table1 before select the rows with the fields id of teststrings1, teststrings2 and teststrings3 to prints out, but it have print out as blank on php page.

Any idea?

The following code returns thousands of results separated by a semicolon;

Code: [Select]
while($getpostid_result=mysql_fetch_array($getpostid))
      {
         $postusername=$getpostid_result['username'];
         echo $postusername.";";
      }
the problem is it does not print everything in one row.it breaks into the nextline after if it encounters certain chatacters or some other reason.
I want it to able to print everything in one row irrespective of the number of results returned.

I'm creating a tool for building project proposals for clients, with pricing.

I have a database with two tables: services and clients.

The services table looks like this:

Code: [Select]
| code        | name        | cost |
+-------------+-------------+------+
| logo_design | Logo design | 10   |
| web_design  | Web design  | 20   |

The clients table looks like this:

Code: [Select]
| id | client  | logo_design | web_design |
+----+---------+-------------+------------+
| 1  | Walrus  | yes         | yes        |
| 2  | Narwhal | no      | yes        |

How would I link the results from these two tables so that I only pull out the services each person wants from the database?

Here is what I have so far:

Code: [Select]
<?
$sql = "SELECT * FROM services";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {

  echo $row{'name'} . ': $' . $row{'cost'} . '<br />';

} ?>

This, of course, displays all the services, with all the prices, like so:

Logo design: $10
Web design: $20

I want to add something here so that based on the selected client, we see only the services/prices they selected (ol' Narwhal's page would not show the "Logo Design" line). I've got the data from "clients" pulled in to this page as well, but don't know how to relate it to "services."

Thanks in advance! Let me know if I've left out any info that would help you to point me in the right direction.

Probably a simple solution, just one I'm not sure how to do it.

I need the array to print out like this

Code: [Select]
array(
   'name'=>'Store 1',
   'address'=>'LA1'
),

Right now, I got it to look like this

Thanks in advance
Code: [Select]
Array
(
    [name] => 'Albertville Farmers Market',
    [address] => '116 Main Street Albertville, Alabama 35950'
)
,
Array
(
    [name] => 'Alexander City Downtown Market',
    [address] => 'Braod Street Alexander City, Alabama 35010'
)
,

How can I go about accomplishing this?

Here is my code
Code: [Select]
$stores = array('name'=>"'$MktName',",'address'=>"'$address'");   
echo "<pre>";
print_r($stores);   
echo "</pre>";

I have a list of ID's returned from a table (even number). I always used a loop to get the next result, but I want to put these straight into a new table

INSERT INTO table VALUES ($ID1, $ID2);

This is recursive till there are no more ID's. How do I get the result then the next result without loops. ID1 and ID2 cannot be null. What is the best way?