PHP - Trying To Understand How To Create A Dynamic Page From A Mysql Link

 The result pages is supposed to have  pagination like google  help me please

 

Hi

I've got this database I created with fields

ProductId   ProductName  Image

I've managed to get it to list the ID,productname, and Image urls
in a list.

My next step is to have the image field actually display
an image and make it clickable:

heres what I've done so far:

Code: [Select]
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("productfeed", $con);

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

echo 
"<table border='0'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
<th>Image</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['ProductID'] . "</td>";
  echo "<td>" . $row['ProductName'] . "</td>";
  echo "<td>" . $row['ImageURL'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>
Heres what I want to do:

Code: [Select]
while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['ProductID'] . "</td>";
  echo "<td>" . $row['ProductName'] . "</td>";

 // my changes beneath
  echo "<td>" . <a href="<?php echo $row['ImageURL'];?>"> <img src="<?php echo $row['LinkURL']; ?>"> </a>. "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>
Can you guys point me in the right direction?

Many thanks

Hello everyone, I am working on a form that is similar to a shopping cart system and I am thinking of creating a button that submits the checked value and saves them to a $_SESSION variable. And also a link that links to a cart.html that takes the values of a $_SESSION variable. I am have trouble figuring what tag/attribute should I use in order to achieve that.   Right now my code attached below submits the checked values to cart.html directly. However I want my submit button to save the checked box to a $_SESSION variable and STAY on the same page. And then I will implement a <a> to link to the cart.php.   I researched a little bit about this subject and I know it's somewhat related to ajax/jquery. I just wanted to know more about it from you guys. I appreciate your attention for reading the post and Thanks!   Below is the form that I currently have:

<form name= "finalForm" method="POST" action="cart.php">
<input type="Submit" name="finalSelected"/>

<?php foreach($FinalName as $key => $item) {?>
<tr>
<td><input type="checkbox" name="fSelected[]" value="<?php echo htmlspecialchars($FinalID[$key])?>" />
<?php echo "$FinalID[$key] & $item";?>
</td>
</tr>
<?php } ;?>

Below is the code for cart.php

<?php
require ('connect_db.php');
if(isset($_POST['finalSelected']))
{
	if(!empty($_POST['fSelected']))
	{
		$chosen = $_POST['fSelected'];
		foreach ($chosen as $item)
			echo "aID selected: $item </br>";
		$delimit = implode(", ", $chosen);
		print_r($delimit);
	}

}
if(isset($delimit))
{
$cartSQL = "SELECT * from article where aID in ($delimit)";
$cartQuery = mysqli_query($dbc, $cartSQL) or die (mysqli_error($dbc));
while($row = mysqli_fetch_array($cartQuery, MYSQLI_BOTH))
{
	$aTitle[] = $row[ 'name' ];
}
}
?>

<table>
	
		<?php if(isset($delimit)) { 
		$c=0; foreach($aTitle as $item) {?>
		<tr>
		<td>
			<?php echo $aTitle[$c]; $c++;?>
		</td>
		</tr>
		<?php }}?>
</table>

i'm trying to achive this results layout: 

example:
                     catagory
                           comment
                           comment
                           comment
                     catagory
                     catagory
                     catagory
                           comment

what is being pulled now is if their is 2 comments two 1 catagory then 2 catagorys are being returned with the same id. what i want is to return one cataogry with many comments.

thanks in advance for your help.

Code: [Select]
<?php require_once('Connections/Del_Comments.php'); ?>
    <?php 
    $all_ids = array();
    $str_ids = "";
     
    // first parent query
    $maxRows_sourceType = 10;
    $pageNum_sourceType = 0;
    if (isset($_GET['pageNum_sourceType'])) {
      $pageNum_sourceType = $_GET['pageNum_sourceType'];
    }
    $startRow_sourceType = $pageNum_sourceType * $maxRows_sourceType;
     
    mysql_select_db($database_Del_Comments, $Del_Comments);
    $query_sourceType = "SELECT a.Id, a.Type, 
a.Dates, 
a.UIdFk, 
b.Id as Did, 
b.comment, 
b.dates as Day, 
b.sfk as Sfk ,
c.sfk as sfk1, 
d.Memo as memo
FROM 
asstatusupdate as a   
left join asstatusdata as b 
on a.id = b.sfk 
left join asmanystatusupdate as c
on b.sfk = c.sfk
left join ascomments as d
on d.id = c.cfk
where a.uidfk='1'
 order by Dates asc";
    $query_limit_sourceType = sprintf("%s LIMIT %d, %d", $query_sourceType, $startRow_sourceType, $maxRows_sourceType);
    $sourceType = mysql_query($query_limit_sourceType, $Del_Comments) or die(mysql_error());
    $row_sourceType = mysql_fetch_assoc($sourceType);
     
    if (isset($_GET['totalRows_sourceType'])) {
      $totalRows_sourceType = $_GET['totalRows_sourceType'];
    } else {
      $all_sourceType = mysql_query($query_sourceType);
      $totalRows_sourceType = mysql_num_rows($all_sourceType);
    }
    $totalPages_sourceType = ceil($totalRows_sourceType/$maxRows_sourceType)-1;
     
    // add the array
    while ($row_source = mysql_fetch_assoc($sourceType)) {
     
        $all_ids[] = $row_source['Sfk'];
     
        $str_ids .= $row_source['Sfk'].',';
     
     }
     
            // remove the array
         $str_ids = (substr($str_ids,-1) == ',') ? substr($str_ids, 0, -1) : $str_ids;
    
echo $str_ids;
    //echo $all_ids;

//second child query
        $maxRows_sourceComments = 10;
    $pageNum_sourceComments = 0;
    if (isset($_GET['pageNum_sourceComments'])) {
      $pageNum_sourceComments = $_GET['pageNum_sourceComments'];
    }
    $startRow_sourceComments = $pageNum_sourceComments * $maxRows_sourceComments;
     
    mysql_select_db($database_Del_Comments, $Del_Comments);
    $query_sourceComments = "SELECT 
c.sfk as sfk1,
d.Memo as memo
FROM 
asmanystatusupdate as c
left join ascomments as d
on d.id = c.cfk
where c.uidfk0='1' and c.sfk in ($str_ids)";
    $query_limit_sourceComments = sprintf("%s LIMIT %d, %d", $query_sourceComments, $startRow_sourceComments, $maxRows_sourceComments);
    $sourceComments = mysql_query($query_limit_sourceComments, $Del_Comments) or die(mysql_error());
    $row_sourceComments = mysql_fetch_assoc($sourceComments);
     
    if (isset($_GET['totalRows_sourceComments'])) {
      $totalRows_sourceComments = $_GET['totalRows_sourceComments'];
    } else {
      $all_sourceComments = mysql_query($query_sourceComments);
      $totalRows_sourceComments = mysql_num_rows($all_sourceComments);
    }
    $totalPages_sourceComments = ceil($totalRows_sourceComments/$maxRows_sourceComments)-1;
     
     
     
    $resultComments = @mysql_query($query_sourceComments, $Del_Comments);
    $numComments = @mysql_num_rows($resultComments);
     
     
    $result = @mysql_query($query_sourceType, $Del_Comments);
     
    $num = @mysql_num_rows($result);
     
    // column count for parent
        $thumbcols = 1;
     
            // column count for parent query
        $thumbrows = 1+ round($num / $thumbcols);
     
                // column count for child query    $thumbrowsComments = 1+ round($numComments/$thumbcols);
     
                // header
                print '<br />';
                print '<table align="center" width="500" border="3" cellpadding="0" cellspacing="0">';
     
                if (!empty($num)) {
                    print '<tr><td colspan="3" align="center"><strong>Returned Num of Record Sets: ' .$num. ' and comments count' .$numComments. '</strong></td></tr>';    
     
                }
     
        // table layout for parent query        

function display_table() {
     
    // global variables
    global $num, $result, $thumbrows, $thumbcols, $resultComments, $numComments, $thumbrowsComments ;
     
    // row count for parent
     for ($r=1; $r<=$thumbrows; $r++) {
     
         // print table row
             print '<tr>';
     
    //format the columns
    for ($c=1; $c<=$thumbcols; $c++) {
     
    print '<td align="center" valign="top">';
     
        $row = @mysql_fetch_array($result);
$row1 = @mysql_fetch_array($resultComments);
     
        $Id = $row['Id'];
        $Type = $row['Type'];
        $Dates = $row['Dates'];
$Comment = $row['Comment'];
$Sfk1 = $row['sfk1'];
$Memo = $row['memo'];


    // test if not empty show record sets            
        if (!empty($Id)) {
     
                                // print output from parent query
     
                       
                                        // grab type dates comment and format for there column
     
                                        echo '<td valign="top" align="center">'; 
                                        echo "$Type"; echo '&nbsp;&nbsp;'; echo "$Dates"; echo '<br />';echo '<br />';echo '<br />';
                                        echo "$Comment"; echo '</td>';
                                        echo '<td>'; echo "$Id"; echo '</td>';
                                        echo '<td>'; echo "$str_ids"; echo '</td>';

                             echo '<tr>';
echo '<td>'; echo "$Sfk1"; echo '</td>';
echo '<td>'; echo "$Memo"; echo '</td>';
echo '</tr>';

} // closing the $id loop
     


                                                    else {
                                                            print '&nbsp;&nbsp;';
                                                        }
                                print '</td>'; //closing the table data
                            } //closing the rows
                                print '</tr>';
                 } // closing the outter loop
                //} //closing fk id loop
                                print '</td>'; //closing the table data
                    } //closing the rows
                                print '</tr>';    
              
        //} // closing the main loop
     
                    // call the main table
                display_table() ;
                    print '</table>';
     
     
    ?>
     
     
     <?php
var_dump(substr('a', 1)); // bool(false)
?>

I've searched and found numerous examples for creating dynamic forms using PHP and MySQL; however, each seems to be different and I have been unsuccessful with all of them. What I get is an empty pulldown menu instead of the contents from the MySQL table. I've worked this till I'm blue in the face and am now turning to the forums for help.  I'm developing/testing code in NetBeans 8.0.2. Here is my code (name of file is 'domains.php':

<body>
<form method="post" action="">
<select id="domain" name="domain">

<?php

// define connection variables
$DBServer = "localhost"; // server name or IP address
$DBUser = "xxxxxxxxx";
$DBPass = "xxxxxxxxx";
$DBName = "country";
$DBPort = "3306";        // I include the port because I have two instances of MySQL - the other is 3309

// create a connection to mysql
$conn = mysqli_connect ($DBServer, $DBUser, $DBPass, $DBName, $DBPort);

// check to see if a connection was made and, if yes, proceed
if (mysqli_connect_errno()) { // connection failed
     echo "Database connection failed: " . mysqli_connect_error();
}

// the domain query to get all domain names
$domainQuery = "select domains from domains_subdomains_cop";

// run the query -- this works elsewhere to display the contents of a table
$resultD = mysqli_query($conn, $domainQuery) or die ("Query to get data from domain failed: " . mysql_error());

// with the exception of a pulldown menu, the while loop works well to display all records, etc.
// I've seen examples with MYSQLI_ASSOC and without and I've tried both without success - I use it because I // haven't had any issues elsewhere in my program
while ($row=mysql_fetch_array($resultD, MYSQLI_ASSOC)) {
     $domainName=$row[DOMAINS]; // DOMAINS is the table attribute I'm trying to pull
     echo "<option>
          $domainName  // I accidentely put a ';' here once and that did show up in the pulldown menu
     </option>";
}

?>

</select>
</form>
</body>

In advance, thank you for any help/insight you can provide!!!

Nick.

I have a form that inserts information into a mysql, the only prolem is I need to add different surrounding html to the information when entering it into the database depending what the value is...(essentially I want to store font color around different levels)

How would I define the same variable with different information depending on the value?

The information is called using:

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$editLEVEL=$_POST['level'];


I want it so if 'Level1' is the posted value then $editLEVEL would be '<color=1>$editLEVEL</color>'
but if 'Level2' is the posted value the $editLEVEL would be '<color=2>$editLEVEL</color>'

If you dont understand just let me know I'll try explain best I can.

Hi all, here's my code:

Code: [Select]
<?php
foreach ($_SESSION['topping'] as $value) {
    echo "<tr><td width='30%'>Topping</td><td width='50%'>$value</td><td width='20%'><select name='notopping'>";
foreach ($_SESSION['cupcake'] as $number) { '<option name="notoppings[]" value="'.$number.'">".$number."</option>'; }
echo "</select></td></tr>";
}
?>

$_SESSION['cupcake'] is a value from either 6, 12, 24 or 36.  What I want to do is put them into a drop down box (second foreach) as the value and the displayed value - counting up from 1 (so 1,2,3,4,5,6 or up to 12,24 etc).

Also by creating this as an array, does this mean than for each topping (say Vanilla and Chocolate) the value dynamically created can be used on the next page by using $_POST['notoppings'] to display each type (two different numbers - one for Vanilla and one for Chocolate).  Does that make sense?

Thanks!

Jason

I got a question  regarding a news website content that i want to make ! my question is how do i   call my contents without using a lot of page?   i explain   let's say i got 10 news how do i put this 10 news in different pages without using 10 pages ? ex: you can see some links having a number like this http://bbc.uk/news/murder_case-12 then the next page got http://bbc.uk/news/finance-13 the title and the number id change but the page news doesnt change    thanks for your answer.

Hi guys,

Here is what I have so far:
http://www.autoshopgarage.com/new-era/generate.php

What I am trying to do is instead of having Line 1 and Line 2, I want to just have one big textarea so I don't have to limit the user so much.  I did it this way because I want to have two versions of text, the light version and the bold version. 

Is it possible to have two different fonts with just one textarea of text?  Right now I have two functions:
Quote

ImageTTFText($image, $fontSize, $fontRotation, 435, 80, $color, $font1, wordwrap($first, 18, "\n", true));
ImageTTFText($image, $fontSize, $fontRotation, 485,120, $color_black, $font2, wordwrap($last, 18, "\n", true));


So I would limit that to just 1, and it would automatically wordwrap but what would I put for the $font variable?  Is this even possible?  I was thinking of just using BBCode so they could type in [b*]Bold Text[/b*] and it would use the Bold version of the font if it sees that.

Any help is appreciated.

Thanks!

Here is the full code:
Quote

<?php
$first = $_GET['first'];
$last = $_GET['last'];
$font_color = $_GET['color'];

header("Content-type: image/png");
$image = imagecreatefrompng ( "banner_blank.png" );
$color_black = imagecolorallocate($image, 0, 0, 0);
$color_red = imagecolorallocate($image, 255, 0, 0);

if($font_color == "Red") {
   $color = $color_red;
}
elseif($font_color == "Black") {
   $color = $color_black;
}

$font1 = 'HelveticaNeueLTStd-BdEx.ttf';
$font2 = 'HelveticaNeueLTStd-LtEx.ttf';
$fontSize = "21";
ImageTTFText($image, $fontSize, $fontRotation, 435, 80, $color, $font1, wordwrap($first, 18, "\n", true));
ImageTTFText($image, $fontSize, $fontRotation, 485,120, $color_black, $font2, wordwrap($last, 18, "\n", true));
imagepng ( $image );
imagedestroy ( $image );
?>

Hi all

I haven't used PHP for a while so I'm stuck on something that seems simple.

I have a list of nav links created in a while loop, I want to add an id="selected" to the <a> link that is selected.

I can check that it's selected with

Code: [Select]
if( $row[1] == $pageName['words']){
     id=''selected"
}

How can I use this to set the id

[code]
<ul>
         <?php
             while($row = mysql_fetch_array($result1)){ 
                //if($row[1] != $pageName['words']){// this will take out the gallery that is showing form the list
                   ?>
                  <li><a href="gallery.php?photo_id=<?php echo $row[0]?>" id=""><?php echo $row[1];?></a></li>
            <?php            
                //}
             }
          ?>
       </ul>
[/code]

This topic has been moved to mod_rewrite.

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

Im rebuilding my website and have decided to make the dynamic images for my main photography gallery be layed out using div tags and css.

I can get the images to load in and layout correctly but for some reason the links on the images only works on the last loaded in image. I check the code on the page and all the links are there but only the last one is active.

The code worked when it was all wrapped in table tags. Is this a PHP or css issue stopping all the links expect for the last to be active.

This is the css code I am using.

#maincontent{width:1000px;margin:0 auto;padding:0 20px}

#maingallery{height:382px;position:relative;width:1000px;text-align:center;margin-top:15px}
#maingallery #text{position:absolute;top:50px}
.gallery_item {float:left; margin: 20px 0 0 0; width: 200px; height: 67; padding: 0 10px 0 10px}
.gallery_item .p {padding: 10px; font-size:12px}
.gallery_item a:hover, a:active { display : block; border : none; }

Any help would be greatly appreciated. Not sure if there would be any thing conflicting the links being active in either php or css.

Thanks

Matt

Hi,

Just looking how to create a link to download a file located on the server, it will be files like .doc etc.

Cant seem to find anything on the net so i think i need php but may be html.

Can anyone point me in the right direction?

Thanks

p.s. it will be used for more than one file so im looking for a small ish amount of code.