Learn VBA & Macros in 1 Week!

PHP - Need Help Printing Array

Full Excel VBA Course - Beginner to Expert

Need Help Printing Array	View Content

Here is my code...

<?php

    $to = "email@email.com"; //obviously not real
    $from = "noreply@domain.com";  //obviously not real
    $firstName = $_REQUEST['firstName'];
    $headers = "From: $from";
    $subject = "Product Sheet Request";

    /*
    $fields = array();
    $fields{"firstName"} = "firstName";
    $fields{"lastName"} = "lastName";
    $fields{"email"} = "email";
    $fields{"phone"} = "phone";
    $fields{"affiliation"} = "affiliation";
    $fields{"interest"} = "interest";
    $fields{"productSheets"} = "productSheets";
    $fields{"referredBy"} = "referredBy";
    $fields{"additional"} = "additional";
    */
    
    $firstName = $_REQUEST['firstName'];
    $lastName = $_REQUEST['lastName'];
    $email = $_REQUEST['email'];
    $phone = $_REQUEST['phone'];
    $affiliation = $_REQUEST['affiliation'];
    $interest = $_REQUEST['interest'];
    if($interest == 'inclusion'){
        $interest = 'Evaluating for inclusion in product';
    } elseif($interest == 'general'){
        $interest = 'Interested in the technology generally';
    } elseif($interest == 'research'){
        $interest = 'Performing market research';
    } elseif($interest == 'solutions'){
        $interest = 'Looking for competitive solutions';
    }
    $referredBy = $_REQUEST['referredBy'];
    $additional = $_REQUEST['additional'];
    $productSheets[] = $_REQUEST['productSheets'];
    $sheets = print_r($productSheets);
    

    /*
    $body = "A user has requested product sheet(s). Please review their information and respond:\n\n"; foreach($fields as $a => $b){   $body .= sprintf("%20s: %s\n",$b,$_REQUEST[$a]); }
    */
    
    $body = "A user has requested product sheet(s). Please review their information and respond:\n
    
    First Name: ".$firstName."\r
    Last Name: ".$lastName."\r
    Email: ".$email."\r
    Phone Number: ".$phone."\r
    Affiliation: ".$affiliation."\r
    Reason for Interest: ".$interest."\r
    Referred By: ".$referredBy."\r
    Additional Questions/Comments: ".$additional."\r
    Product Sheet(s) Requested: ".$sheets."\n
    ";
    
    
    $send = mail($to, $subject, $body, $headers);

?>

I'm not quite sure how to display the values of the $productSheets array in the email message. Everytime it either outputs "Array" or "1". The $productSheets array is from a checkbox on a form. Everything else is working as expected.

Full Excel VBA Course - Beginner to Expert

Printing Elements Of An Array

Similar Tutorials

View Content

Hi,

I'm a PHP novice and trying to print out elements of what appears to be a multi-dimensional array, but I can't figure it out. I'm able to use print_r() to dump the array.

This output was produced using print_r($array);

I'm trying to access our contacts using the vendor's PHP API, but I'm not much of a PHP programmer. The array is stored in $contacts, using the vendor's getList() function. I believe I'm able to download the whole list of contacts in an array, but I can't iterate through it. I'd like to print out the elements of the array in CSV format.

This looks like some complicated multidimensional array.

I also have no idea what the array keys are ('isPublished', etc).

$contacts = $contactApi->getList($searchFilter, $start, $limit, $orderBy, $orderByDir, $publishedOnly, $minimal);
foreach ($contacts as $var) {
echo "\n", $var['isPublished'], "\t\t", $var['value'];
}

I've also tried something like this:

foreach ($contacts as $contact) {
echo "\n", $contacts[$contact['isPublished']];
}

Other ideas greatly appreciated.

Printing A Specific Number From An Array

Similar Tutorials

View Content

Hello, i retrieve an array from the database that looks something like this:

$var=a:1:{s:2:"cc";a:1:{i:22;s:11:"TESTING";}};

I need to retrieve the number corresponding to the character i: and print it(11 in the first case).
For example ,
If,
$var=a:1:{s:2:"cc";a:1:{i:15;s:11:"TESTING";}};
I would need to print 15.
$var=a:1:{s:2:"cc";a:1:{i:3;s:11:"TESTING";}};
I would need to print 3.

Thanks in advance.

Sorting Then Printing Multidimension Array

Similar Tutorials

View Content

<?php

$menu = array(                  '22' => array (

                                    'title'=>'Businesses'

                                    ,'busstype'=>array(

                                                   5=>'Printers'

                                                   ,2=>'Bookshops'

                                                   ,6=>'Publishers'

                                                   ,8=>'Uniform Distributors'

                                                  )

                                    )

                           ,21 => array (

                                    'title'=>'Academic'

                                    ,'busstype'=>array (

                                                   5=>'Academy'

                                                   ,6=>'Primary'

                                                   ,7=>'Polytechnic'

                                                   ,11=>'University'

                                                  )

                                 )

                           ,'Events' => array (

                                    'title'=>'Events'

                                    ,'busstype'=>array (

                                                   3=>'Music'

                                                   ,4=>'Road shows'

                                                   ,6=>'Sports'

                                                   ,6=>'Yoga'

                                                  )

                                 )

) ;

I have a dynamically created menu as above. How would i sort on the 'busstype' homogenously and print it while maintaing the key.

Results should be like

<a href="search.php?listing=21&busstype=5">Academy</a>

<a href="search.php?listing=22&busstype=2">Bookshops</a>

.......

<a href="search.php?listing=Events&busstype=6">Yoga</a>

?>

Looping Through Array And Printing Html Blocks

Similar Tutorials

View Content

Hi all, I'm trying to set up a situation where a function loops through a multidimensional array and echos an html block for each item in the $skus['skunum'] array and also increments $i each time . ( Each is a product on the site)
The catch is that I'm trying to have a function within that one that goes through the $skus['sizes'] and echoes an option if the substring (shirt size) exists.

The idea being that I can manage products by adding 4 elements, Skunum, name, price and size.

And well, I'm failing miserably.

At this point it won't even work because of the variable scope, I'm getting Notice: Undefined variable: skus
from the functions, but am not sure of the right way to get that information.

Am I going about doing this entirely wrong or am I on the right track?

Code: [Select]
<?php $BANDNAME="Apocalypse";
$BANDCAPS="APOCALYPSE";
$BANDLOWER="apocalypse";
$SKUCAPS="FGD";
$skus = array
  (
  "skunum"=>array
  (
  "101",
  "102",
  "103",
  "104",
  "105",
  "106",
  "107",
  "108",
  "109",
  "110",
  "111",
  "112"
  ),
  "name"=>array
  (
  "RIDDICK /TSHIRT",
  "MAFIA / TSHIRT",
  "ORACLES / TSHIRT",
  "AGONY / TSHIRT",
  "BLOODY VIOLINIST / TSHIRT",
  "THE VIOLATION / TSHIRT",
  "AGONY-TOUR DATES / TSHIRT",
  "BAND PHOTO / TSHIRT",
  "SILVER AGONY LOGO / TSHIRT",
  "PHOENIX-TOUR DATES / TSHIRT",
  "PHOENIX / TSHIRT",
  "BLOODY VIOLINIST / ZIP HOOD"
  ),
  "price"=>array
  (
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "42.95"
  ),
  "sizes"=>array
  (
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X"
  )

  );

function makeProducts() {
//Products Sizes
$sizes = $skus['sizes'][$i];
$S="S";$M="M";$L="L";$XL="1";$XXL="2";$XXXL="3";$XXXXL="4";

$small = strpos($sizes,$S);
$medium = strpos($sizes,$M);
$large = strpos($sizes,$L);
$xlarge = strpos($sizes,$XL);
$xxlarge = strpos($sizes,$XXL);
$xxxlarge = strpos($sizes,$XXXL);
$xxxxlarge = strpos($sizes,$XXXXL);

function sizeOptions () {
if($small === true) {
echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'S">S</OPTION>';
}
if($medium === true) {
echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'M">M</OPTION>';
}
if($large === true) {
echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'L">L</OPTION>';
}
if($xlarge === true) {
echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'X">XL</OPTION>';
}
if($xxlarge === true) {
echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'XX">XXL</OPTION>';
}
if($xxxlarge === true) {
echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'XXX">XXXL</OPTION>';
}
if($xxxxxlarge === true) {
echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'XXXX">XXXXL</OPTION>';
}
}

foreach ( $skus['skunum'] as $value){




   echo '
  <li class="product" >
<a href="product_files/large/'.$SKUCAPS.$skus['skunum'][$i].'jpg" rel="lightbox"><img src="product_files/'.$SKUCAPS.$skus['skunum'][$i].'.png"></a><br>
                            <strong>'.$skus['name'][$i].'</strong><br>('.$SKUCAPS.$skus['skunum'][$i].')<br>$'.$skus['price'][$i].'<br>
                            <form name="'.$SKUCAPS.$skus['skunum'][$i].'" method="GET" target="_blank" action="http://www.jsrdirect.com/cgi-bin/Make-a-Store.cgi">
                            <input type="hidden" name="band" value="'.$BANDCAPS.'"> <input type="hidden" name="back" value="http://www.jsrdirect.com/bands/'.$BANDLOWER.'/index.html">
                            <strong>Qty:</strong>
                            <input type="text" name="quantity" size="1" value="1" >
                            <strong>Size:</strong> 
                            <SELECT name="item">'
.sizeOptions();
'</SELECT>
                            <br><br>
                            <input type="image" src="images/addtocart.png" value="Add To Cart">
                            </form>
                        </li>
                ';
}

} // End Function

?>

Printing Opposite Results From The Same Query (or Printing Outside A While Loop?)

Similar Tutorials

View Content

I have 64 rows of players and want each User to be able to choose to bookmark an player, as well as unbookmark it too.

I have a bookmark table set up, and each time a User decides to bookmark(+) or unbookmark(-) an player a row is created in the data table. (Matching the player ID and User ID) That's working fine.

A query reads the most recent row for each player to determine if there is a + or - button next to each player. Testing the query and adding some dummy data, that part of it works too. However, the issue is the initial state, which I want to be a +. Once I go live, the table will be empty, nothing for the query to return/produce.

How do I create an initial state of a + with no rows and have it not used or swapped out when Users start clicking + or -?

  $query = "SELECT b.id, bookmark,playerID,userID,p.id 
                FROM a_player_bookmark b
                LEFT JOIN a_players p
                ON '". $id ."' = playerID
                WHERE userID = '". $userID ."'&&'". $id ."' = playerID
                ORDER BY b.id desc
                LIMIT 1
                ";

    $results = mysqli_query($con,$query);
    echo mysqli_error($con);
    while($row = mysqli_fetch_assoc($results)) {    

    echo $row['bookmark'];

        if($row['bookmark'] == 0) {
            echo '-'; // this is where a form goes to remove a bookmark
        }       
        else {
            echo '+'; // this is where a form goes to add a bookmark
        }

    }

I tried to get it with CASE, but I don't think that's the right path. I also looked at UNION. I was able to get it to produce an initial state of +, but it still printed the already made up sample data too (so I have three instances of ++ or +-).

(Players 2, 4 and 4)

Here is the what the UNION query looked like:

	$query = "(SELECT b.id, bookmark,playerID,userID,p.id 
				FROM a_player_bookmark b
				LEFT JOIN a_players p
				ON '". $id ."' = playerID
				
				WHERE userID = '". $userID ."'&&'". $id ."' = playerID
				ORDER BY b.id desc
				LIMIT 1)
			UNION
				(SELECT b.id, bookmark,playerID,userID,p.id 
				FROM a_player_bookmark b
				LEFT JOIN a_players p
				ON '". $id ."' = playerID
				
				WHERE userID = '". $userID ."'
				ORDER BY p.id desc
				LIMIT 1) 
				";

Not Printing A \n

Similar Tutorials

View Content

I have the following php script and get data from a database and prints in on a page however it does not print a carriage return. Why can this be?

The script:
<?php
include "database.inc";
mysql_select_db("php", $connection);
$result = mysql_query("SELECT * FROM orders", $connection);
while ($row = mysql_fetch_array($result, MYSQL_NUM))
{
foreach ($row as $attribute)
print "($attribute)";
print "\n";
}
?>

Printing With Php

Similar Tutorials

View Content

hello all,

i know that php is server side. if i have a printer attached to the server, can i have users press a button and have it print there?

Printing Php

Similar Tutorials

View Content

Hi there, I'm new in PHP, my output is in at table, I designed it already, now I want to print it..how can I do that ? do i need JS ?

Value Not Printing

Similar Tutorials

View Content

hi everyone

I have a small user & business Directory and for it, I use a .htaccess ReWrite.

My .htaccess file looks like

Code: [Select]
RewriteEngine On
RewriteRule ^([^/.]+)$ index.php?q=$1 [QSA,L]
so basically when I run

Code: [Select]
http://localhost/Johnsons/
then it treats that like

Code: [Select]
http://localhost/index.php?q=Johnsons
I then do a PHP Query to find the result, I use the following;

print "You looked up $_GET['q']";

$result = mysql_query("SELECT `name` FROM `directory` WHERE `name` = '".$_GET['q']."'");
while($row = mysql_fetch_array($result))
{
print $row['name'];
}

this all works fine.

The problem I now have is that I have been sent some new data in a SQL database import file and it contains entries such as

Dugāriy

T-ī-Corā

but when I try and run

http://localhost/Dugāriy/

or

http://localhost/T-ī-Corā/

it does not return the correct value and instead it either misses characters or it exchanges one character for another, (ā is swapped "a" as an example).

It seems this is due to a mix of Special Characters & Accents within words such as

ā

ū

ī

I have tried altering the META charset tag without any luck, I have also tried

print utf8_encode($_GET['q']);

print urlencode($_GET['q']);

but nothing seems to work.

Any idea on how I can solve this?

Thanks very much

J

Need Help Printing To Pdf

Similar Tutorials

View Content

I have a directory that I would like to allow users to print to PDF format for download.
How can I do this and where do I start?

Printing To 4x6 Labels

Similar Tutorials

View Content

Hi there!

I found this code to parse a MySQL query to PDF, but it's for small address labels and I was wondering how to make it for 4x6 labels?
<?php
define('FPDF_FONTPATH','/home/directory/public_html/sub/font/');
require_once('fpdf.php');
//Connect to your database
mysql_connect("localhost", "db_user","db_pw") or
    die ("Could not connect to database");
mysql_select_db("database_name") or
    die ("Could not select database");

$query  = "SELECT employee_name, street_address, City, state, zip_code FROM employees ORDER BY `employee_name` ";
$result = mysql_query($query) or die('Error, query failed');
$num_rows = mysql_num_rows($result);

function PrintAddressLabels($result){

  $pdf=new FPDF();

  $pdf->Open();
  $pdf->AddPage();
  $pdf->SetFont('Arial','B',14);
  $pdf->SetMargins(0,0);
  $pdf->SetAutoPageBreak(false);
  $x = 0;
  $y = 0;
  $i=0;

  while (TRUE) {

    if ($row=$result[$i]) {

      //positions set above
      $LabelText = sprintf("%s\n%s %s\n%s, %s, %s",
      $row['employee_name'],
      $row['street_address'],
      $row['City'],
      $row['state'],
      $row['zip_code']);

      Avery5160($x,$y,&$pdf,$LabelText);

      $y++; // next row
      if ($y == 10 ) { // end of page wrap to next column
        $x++;
        $y = 0;
        if ($x == 3 ) { // end of page
          $x = 0;
          $y = 0;
          $pdf->AddPage();
        }
      }
      $i++; //counter through result
    } else {
      // Error quit printing
      break;
    }

  {
  $pdf->Output('mailing_labels.pdf','D');
}
?>

Does anyone know where I can find some good resources/tutorials that covers how to use the PDF stuff with PHP or know how I can change this up to match for 4x6 at all?

Any help or info is greatly appreciated!

Thanks!

Printing Question

Similar Tutorials

View Content

is there a way to make a link or button that will print the current page, but only page 1, landscape with no headers or footers?

or print between two tags?

thanks

Help Printing An Image

Similar Tutorials

View Content

Hi, I want to echo an image depending on a value. This is the code I'm using
Code: [Select]
<?php if ($row_cliente_RS['estadofactura_titulo']) == 'yes'
echo '<img src="img/pagada.jpg" width="70" height="15">';
?>...but nothing echoes. What am I doing wrong?
Thanks

Printing Pdf In Php Using Fpdf

Similar Tutorials

View Content

Hello, I am trying to print the invoice in pdf, using fpdf. i am not getting how to do it. I am able to display line items , but its not in proper format. I tried changing X, Y positions, but its not going into my head . Also i want to display Logo and address in left side, invoice number and order date in right side. Here is the code i have done so far... Please please help me in this

<?php



require('includes/fpdf/fpdf.php');


//Connect to your database
include("connect/DB_Connect.php");
$id = $_GET['id'];

//Select the Products you want to show in your PDF file
$result=mysql_query("select invoice_no, order_no, order_date, completion_date, artwork, customer_po, order_quantity, comments, order_amount from invoice where invoice_no='".$id."' ") or die(mysql_error());


$number_of_products = mysql_numrows($result);


//Initialize the 3 columns and the total
$column_order_date = "";
$column_order_no = "";
$column_artwork = "";
$column_cpo = "";
$column_order_quantity = "";
$column_order_amount = "";
$column_comments = "";
$total = 0;


//For each row, add the field to the corresponding column
while($row = mysql_fetch_array($result))
{
$order_date = $row["order_date"];
$order_no = $row["order_no"];
$artwork = $row['artwork'];
$cpo = $row['customer_po'];
$oquantity = $row['order_quantity'];
$oamount = $row['order_amount'];
$comments = $row['comments'];
//$price_to_show = number_format($row["Price"],',','.','.');


$column_order_date = $column_order_date.$order_date."\n";
$column_order_no = $column_order_no.$order_no."\n";
$column_artwork = $column_artwork.$artwork."\n";
$column_cpo = $column_cpo.$cpo."\n";
$column_order_quantity = $column_order_quantity.$oquantity."\n";
$column_order_amount = $column_order_amount.$oamount."\n";
$column_comments = $column_comments.$comments."\n";


//Sum all the Prices (TOTAL)
$total = $total+$oamount;
}
mysql_close();




//Create a new PDF file
$pdf=new FPDF();
$pdf->AddPage();


//Fields Name position
$Y_Fields_Name_position = 20;
//Table position, under Fields Name
$Y_Table_Position = 26;


//First create each Field Name
//Gray color filling each Field Name box
$pdf->SetFillColor(232,232,232);
//Bold Font for Field Name
$pdf->SetFont('Arial','B',12);
$pdf->SetY($Y_Fields_Name_position);
$pdf->SetX(5);
$pdf->Cell(25,6,'Order Date',1,0,'L',1);


$pdf->SetX(30);
$pdf->Cell(50,6,'Graphixide Order No',1,0,'L',1);


$pdf->SetX(75);
$pdf->Cell(40,6,'Artwork',1,0,'L',1);


$pdf->SetX(110);
$pdf->Cell(20,6,'PO #',1,0,'L',1);


$pdf->SetX(130);
$pdf->Cell(20,6,'Quantity',1,0,'L',1);


$pdf->SetX(150);
$pdf->Cell(25,6,'Amount',1,0,'L',1);


$pdf->SetX(175);
$pdf->Cell(25,6,'Comments',1,0,'L',1);




//Now show the 3 columns
$pdf->SetFont('Arial','',12);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(5);
$pdf->MultiCell(25,6,$column_order_date,1);


$pdf->SetY($Y_Table_Position);
$pdf->SetX(30);
$pdf->MultiCell(80,6,$column_order_no,1);


$pdf->SetY($Y_Table_Position);
$pdf->SetX(75);
$pdf->MultiCell(40,6,$column_artwork,1);




$pdf->SetY($Y_Table_Position);
$pdf->SetX(110);
$pdf->MultiCell(20,9,$column_cpo,1);


$pdf->SetY($Y_Table_Position);
$pdf->SetX(130);
$pdf->MultiCell(20,6,$column_order_quantity,1);


$pdf->SetY($Y_Table_Position);
$pdf->SetX(150);
$pdf->MultiCell(75,6,$column_order_amount,1);


$pdf->SetY($Y_Table_Position);
$pdf->SetX(175);
$pdf->MultiCell(25,10,$column_comments,1);


$pdf->SetY($Y_Table_Position);
$pdf->SetX(150);
$pdf->MultiCell(130,6,'$ '.$total,1,'R');


//Create lines (boxes) for each ROW (Product)
//If you don't use the following code, you don't create the lines separating each row
$i = 0;




while ($i < $number_of_products)
{
$pdf->SetX(45);
$pdf->MultiCell(120,6,'',1);
$i = $i +1;
}
$pdf->Output();
?>

Here is the output of this code ss.PNG 32.3KB 7 downloads

Printing & In Php Variable

Similar Tutorials

View Content

Hello,
I need help with this issue, I am displaying <a href='index.php?cat=h & r'>text</a> when I do print $_GET['cat'] it only displays h, why ?
Thanks

Report Printing Help

Similar Tutorials

View Content

Hi All,

I am trying to generate a PDF report using the below code. the report is being generated perfectly. The problem that I face is that, while printing the report the browser disregards the "IF" condition that I have given in the code.

Explanation :
-----------------
It prints all the data in the MySQL database wherein I wanted the data to be printed only on a certain condition. How do I achieve this?

Quote

<?php
mysql_connect('localhost','user','pass');
mysql_select_db('vaccine');
$array = mysql_query("SELECT cattle_n FROM vactbl");
$num_rows = mysql_num_rows($array);
$array = mysql_query("SELECT * FROM vactbl");
$num_rows = mysql_num_rows($array);
while($info = mysql_fetch_array( $array ))
{
$mas_date = $info['masdt'];
$mas_time = strtotime($mas_date);
$two_week = strtotime("+2 week");
$rpt_date = abs($two_week - $mas_time);
if ($rpt_date >= 7776000)
{
require('mysql_table.php');

class PDF extends PDF_MySQL_Table
{
function Header()
{
//Title
$this->SetFont('Arial','B',40);
$this->Cell(0,6,'Cattle List',0,1,'C');
$this->Ln(10);
//Ensure table header is output
parent::Header();
}
}

//Connect to database
$pdf=new PDF();
$pdf->AddPage();
//First table: put all columns automatically
//$pdf->Table('select * from cattle_det order by no');
//$pdf->AddPage();
//Second table: specify 3 columns
$pdf->AddCol('cattle_n',20,'Cattle','C');
$pdf->AddCol('masdt',40,'Mastitis Date', 'C');
$pdf->AddCol('fmdt',40,'FM Date','C');
$pdf->AddCol('onedt',40,'Vaccine1 Date','C');
$pdf->AddCol('twodt',40,'Vaccine2 Date','C');
$prop=array('HeaderColor'=>array(255,150,100),
'color1'=>array(210,245,255),
'color2'=>array(255,255,210),
'padding'=>2);
$pdf->Table('select cattle_n, masdt, fmdt, onedt, twodt from vactbl order by cattle_n limit 0,10',$prop);
$pdf->Output();
}
else {}
}

?>

Printing Tables

Similar Tutorials

View Content

hi i have this code here and i was wondering how i could make it print out the values from my database using a drop down menu.
i no this is probably very basic but im a real novice at php and sql.

<?php
mysql_connect('localhost', 'root', '');
mysql_select_db('charity_data');
$result = mysql_query('select * from donations');
?>
<select name="selectname">
<?php
$i = 0;
while ($i < mysql_num_fields($result)){
$fieldname = mysql_field_name($result, $i);
echo '<option value="'.$fieldname.'">'.$fieldname.'</option>';
$i++;
}

?>

</select>

Printing Out In A Table

Similar Tutorials

View Content

I've got a database file from sqlite, there is a multidimensional array in it with 10 metals.
I just want two print out each element in a table

It won't get all the separate data inside a HEREDOC

foreach ($product_prices as $metal => $prices)

"<tr><td>$metal</td><td align = 'right'>".
round($prices[wire][28]*$l_conv*$w_conv,4).
"<tr><td>$metal</td><td align = 'right'>".
round($prices[wire][36]*$l_conv*$w_conv,4).
"<tr><td>$metal</td><td align = 'right'>".
round($prices[wire][45]*$l_conv*$w_conv,4).
"<tr><td>$metal</td><td align = 'right'>".
round($prices[dust][100]*$l_conv*$w_conv,4).
"<tr><td>$metal</td><td align = 'right'>".
round($prices[dust][10]*$l_conv*$w_conv,4).
"<tr><td>$metal</td><td align = 'right'>".
round($prices[dust][1]*$l_conv*$w_conv,4).
"</td></tr>";

Printing A Script

Similar Tutorials

View Content

Hi,

I really need to find a way to print the code below in php.

Code: [Select]
<script>
$(document).ready(function()
{
$.sticky('The page has loaded!');
});
</script>

i tried

Code: [Select]
print"<script>
$(document).ready(function()
{
$.sticky('The page has loaded!');
});";
</script>

any help would be great.

Printing Tables(sql) & Getting Values From Each Row

Similar Tutorials

View Content

Hey guys.

I have ran into a problem once again. I want to print a list of data I have in my database being monsters (ID, Name, HP, attack) I want to be able to print them fromt he database then get the "ID" of the monster being selected by a submit button to give the id of that row in some form (a POST?) so i can get the information for that monster in a SELECT when the button is hit.

I will try show you what im trying to do.

Code: [Select]

//Grt the id from the table print at the bottom.
$monster_id = $_POST["monsterid"];

//this is at the top to get stats on the monster the user has selected to fight
$query="SELECT * FROM monsters WHERE id='$monster_id'";
$result=mysql_query($query);
$result=mysql_fetch_array($result);
$monster_exp=$result["exp"];
$exp_dead = round(($monster_exp/100) * 10);
$monster_hp =$result["hp"];
$goldwon =$result["gold"];
$mindam =$result["mindam"];
$maxdam =$result["maxdam"];

// my battle code goes here using the stats I want above.
------------------------------------------------------------------------------

//This is where the user selects the monster they want to fight.

$query="SELECT * FROM monsters";
$result=mysql_query($query);

$num=mysql_numrows($result);
mysql_close();

$i=0;

<form action="training.php" method="post">
<table border='0' width="400" class="tablee">
<tr>
<th>Monster</th>
<th>Level</th>
<th>HP</th>
<th>Protection</th>
<th>Fight?</th>
</tr>
<?
$query="SELECT * FROM monsters";
$result=mysql_query($query);

$num=mysql_numrows($result);
mysql_close();

$i=0;

while ($i < $num) {

$id=mysql_result($result,$i,"id");
$name=mysql_result($result,$i,"name");
$level=mysql_result($result,$i,"lvl");
$hp=mysql_result($result,$i,"health");
$pro=mysql_result($result,$i,"pro");
?>
<tr>
<th><? echo $mon_name; ?> </th>
<th><? echo $mon_level; ?> </th>
<th><? echo $mon_hp; ?> </th>
<th><? echo $mon_pro; ?> </th>
<th><input type="hidden" value="<? echo $mon_id; ?>" name="monsterid" />
<input type="submit" value="Fight!" name="submit" /></th>
</tr>
<?
$i++;
}
?>
</table>
</form>

I hope this makes sense because I am really having problems. My gues is use an array but I could get it to work.

PS: I did a get and it sends ALL the IDs instead of the selected row.

Thanks for any help guys,
Ruddy