PHP - Link Tables

I am trying to write some data from multiple SQL tables to a page. In the first table is a list of places. I then have more tables that are named after the different places. For example, say my first place in the list is called Place1. I have a table named Place1 with data that corresponds to place1. The data contained in the table named Place1 is a list of things to do in this place. It has 21 columns and each one is something to do in the morning, afternoon, and at night for each day of the week in the place Place1. What I am trying to do is display a sort of weekly calendar as a table on a webpage that lists all of the places in one column and then lists seven days of the week as 7 more columns. Then in each data cell I would want to list the things to do in the morning, afternoon and at night for the certain day of the week and for the place. The problem is that I am creating a CMS to allow other users with no coding knowledge to update events for other places, so I have to display data that could have been altered.

The only solution I know of is to do a while loop that gets all of the place names and while there are still place names, write the place names to the page and set a variable equal to the place name. Inside the while loop I would create another while loop that each time the first while loop is executed uses the variable set in the first while loop to know which table to reference and then make a call to that table pulling out the 21 columns and writing them to the page. Each time the outer while loop executes, it would (hopefully) write the place name, and then set the variable as the current place name so that the inner while loop uses the variable to write the rest of the information about that place.

I don't know if that would even work and if it did, I know it cannot be the best way to do this. I am pretty stuck here and don't really have a good solution so if anyone proposes a solution that is radically different to anything I have done, I am open to everything. Thank you!

Hello. I have a bit of a problem. When I fetch the link field from the database.i don't see an actual link on the page.  One more thing, what type of field should I use to store the link in the database? Probably there is where I went wrong. All help is 

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

Hi Support,

I have a form, where it collects user description input. I can collect the inputs and store it with newline. The issue is - how to collect the http link to actual hyperlink ref during display.  The following is my code:

<textarea name="description" cols="50" rows="10" id="description"><?php echo str_replace("<br>", "\n", $description);?></textarea></td>

For example, User input:

Hi, Check it out - http://www.google.com/

I would like to display google link as href so that Viewers can click the link and go to the page. Right now, it is not href and user need to copy the link to new tabs or pages and then it can come.

Thanks for your help.
Regards,
Ahsan

hi hope you all are fine.

i have been working on a Email Form (like user fills up the form which send the information to our email)
but i was having problem with (URL field i created)

link of form is (http://services.shadowaura.com/allquotations/static.php)
field which is not working is "Inspirational Website:"

when i submit the form it says (Forbidden

You don't have permission to access /allquotations/staticworking.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.)

Can some one help me out ?????????????

code behind this form is:

Code: [Select]
<?php

/* Email Variables */

$emailSubject = 'Shadow Aura Contact Info!';
$webMaster = '*****@shadowaura.com';


/* Data Variables */

$Name = $_POST['Name'];
$email = $_POST['email'];
$Cell = $_POST['Cell'];
$Phone = $_POST['Phone'];
$CompanyName = $_POST['CompanyName'];
$TypeOfBusiness = $_POST['TypeOfBusiness'];
$Address = $_POST['Address'];
$YourBudget = $_POST['YourBudget'];
$HaveDomain = $_POST['HaveDomain'];
$RunningWeb = $_POST['RunningWeb'];
$WebLink = $_POST['WebLink'];
$Inspiration1 = $_POST['Inspiration1'];
$Inspiration2 = $_POST['Inspiration2'];
$NumberPages = $_POST['NumberPages'];
$UseFlash = $_POST['UseFlash'];
$TimeFrame = $_POST['TimeFrame'];
$Provided = $_POST['Provided'];
$Comments = $_POST['Comments'];


$body = <<<EOD

<h1> Static Website Quotation </h1> <br>
<b>Name of Client:</b>$Name<br>
<b>Your Email:</b>$email<br>
<b>Cell Number:</b>$Cell<br>
<b>Line Phone Number:</b>$Phone<br>
<b>Company Name:</b>$CompanyName<br>
<b>Type of Business:</b>$TypeOfBusiness<br>
<b>Address:</b>$Address<br>
<b>Your Budget:</b>$YourBudget <br>
<b>Do you have Domain:</b>$HaveDomain<br>
<b>Your Site is Running:</b>$RunningWeb <br>
<b>Website Link:</b><a href="$WebLink">$WebLink</a><br>
<b>Inspiration:</b>$Inspiration1<br>
<b>2nd Inspiration:</b>$Inspiration2<br>
<b>Number of Pages:</b>$NumberPages<br>
<b>Use Flash:</b>$UseFlash <br>
<b>Time Frame:</b>$TimeFrame<br>
<b>You will provide:</b>$Provided<br>
<b>Comments:</b>$Comments<br>



EOD;

$headers = "From: $email\r\n";
$headers .= "Content-type: text/html\r\n";
$success = mail($webMaster, $emailSubject, $body,
$headers);


/* Results rendered as HTML */

$theResults = <<<EOD
<html>
<head>
<title>sent message</title>
<meta http-equiv="refresh" content="3;URL=http://services.shadowaura.com/">
<style type="text/css">
<!--
body {
background-color: #8CC640;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 20px;
font-style: normal;
line-height: normal;
font-weight: normal;
color: #fec001;
text-decoration: none;
padding-top: 200px;
margin-left: 150px;
width: 800px;
}

-->
</style>
</head>
<div align="center">Your email will be answered soon as possible!
You will return to <b>Shadow Aura Services</b> in a few seconds !</div>
</div>
</body>
</html>
EOD;
echo "$theResults";
?>

here's my code that i've used to send an email.

Code: [Select]
$link = "<a href=\"http://www.example.com/" . $num . "\">" . $num . "</a>";

$query = "SELECT content FROM emails";
$result = mysql_query($query) or die();
$email_content = mysql_result($result, 0);
$email = sprintf($email_content, $first, $name, $from, $link, $record, $rec, $inc, $max);
$email_body = stripslashes(htmlentities($email, ENT_QUOTES, 'UTF-8'));

// this is sent to another php script via post....

$subject = $_POST['subject'];
$message = nl2br(html_entity_decode($_POST['email_body']));
$to = "me@whatever.com";
$charset='UTF-8';
$encoded_subject="=?$charset?B?" . base64_encode($subject) . "?=\n";
$headers="From: " . $userEmail . "\n"
. "Content-Type: text/html; charset=$charset; format=flowed\n"
. "MIME-Version: 1.0\n"
. "Content-Transfer-Encoding: 8bit\n"
. "X-Mailer: PHP\n";
mail($to,$encoded_subject,$message,$headers);
   

in the db, emails.content is of the text type and contains several lines of text with %4$s which inserts the value of $link into the body.  when the email arrives, there is a link and it appears fine, with the value of $num hyperlinked.  however when you click on it it doesn't go anywhere.  when copying the link location from the email it gives me

x-msg://87/%22http://www.example.com/16

what is x-msg?  how can i get this to work properly?

I have a line like this it prints text link but I prefer image link how should i edit it I would appreciate some feedback
Code: [Select]
$templates['etiket'] = array('name' => t('ETİKET'), 'module' => 'uc_invoice_pdf', 'path' => $templates_uc_invoice_pdf_path, 'pdf_settings' => $pdf_settings);

Hi guys,

I'm using a twitter script that grabs the title and publishings it like so:

"Title - Read More at..."

I was wondering how i would be able to post the direct link into twitter.. like news.php?id=1 for example.

Code: [Select]
$tweet->post('statuses/update', array('status' => ''.$_POST[title].' - more at MY URL'));

This part is in the script to publish automatically when the users adds to the news database.

How am i able to get the ID just after the posting of the news?

Thanks!

hi everyone,

Whats the best way to put my displayed php into my table?

I already have gotten to the point where it is displayed, but it looks basic, so i want it to look like the table below it.... i just havent quite figured out how to "space" the data out so it looks better?

Is it just a case of printing out what i want where in the table? or is it something more complex?

http://www.removalspace.com/indextwo.php

This is more than a question than anything else:

I am looking for a tutorial or something that will allow me to make tables with php and mysql

for example what I need is:

mysql data:

table = links

lid = 1
lname = Page 1
linkid = page.php
lid = 2
lname = Page 2
linkid = page2.php

etc

and i am try to get it so if there is 2 pages then the table would do

Page 1   Page 2

if 3

Page 1  Page 2
Page 3

so there are 2 lname(s)s per row and 1 in each column and it would keep building the table and rows as more lname(s) are added.

Does anybody know where to find a tutorial on doing something like this.

Thanks in advance

Hi everyone... I have a thumbnail page that is putting out tables that are skewed and I am not able to use CSS properly because of that. Is there anyways I can change the PHP output? This is my code... I think the highlighted area is responsible for my tables? But it is mismatching the <tr> and <td> tags....

I really want it to show a structured table..  like
<table>
<tr>
<td>

</td>
</tr>
</table>



 // Thumbnail Listing

else if( $cid && empty( $pid ) )

{

  $number_of_thumbs_in_row = 4;

// If current page number, use it 

  // if not, set one! 

  if(!isset($_GET['page'])){ 

      $page = 1; 

  } else { 

      $page = $_GET['page']; 

  } 

// Define the number of results per page 

  $max_results = 400; 



// Figure out the limit for the query based 

// on the current page number. 

  $from = (($page * $max_results) - $max_results); 

  $result = mysql_query("
    SELECT 
          photo_id
        , photo_caption
        , photo_filename 
        , photo_category
    FROM 
        gallery_photos 
    WHERE 
        photo_category='".addslashes($cid)."' 
    LIMIT 
        $from, $max_results
    "); 

  $nr = mysql_num_rows( $result );

  if( empty( $nr ) )

  {

   $result_final = "\t<tr><td>No Photos found</td></tr>\n";

  }

   else

  {

   while( $row = mysql_fetch_array( $result ) )

   {

    $result_array[]= "<a href='viewgallery.php?cid=$cid&pid=".$row[0]."'><img 

    src='".$images_dir."/tb_".$row[2]."' border='0' alt='".$row[1]."' class='img'/></a>";

   }



    $result = mysql_query( "SELECT category_name FROM gallery_category WHERE category_id='".addslashes($cid)."'" ); 

    list($category_name) = mysql_fetch_array( $result ); 

    mysql_free_result( $result );     


    $result_final = "<tr>\n\t<td> 

                        <span class='navlinks'><a href=viewgallery.php>Albums</a></span><font color=#ff0000> &gt;&gt </font>

                        <span class='navlinks'><a href=viewgallery.php?cid=$cid>$category_name</a></span><br><br/><br/><br/></td>\n</tr>\n";


   foreach($result_array as $thumbnail_link)

   {

    if($counter == $number_of_thumbs_in_row)

    { 

     $counter = 1;

     [b][size=24pt][size=18pt][b]$result_final .= "\n</tr>\n<tr>\n";[/b][/size][/size][/b]



    }

    else

    $counter++;

   [b][size=18pt] $result_final .= "\t<td>".$thumbnail_link."</td>\n";[/size][/b]

    
   }

   if($counter)

   {



And my HTML output shows the tables like this...

Code: [Select]
<body>

<table width='100%' border='0' align='center' style='width: 80%;'>

<tr>
    <td>

                        <span class='navlinks'><a href=viewgallery.php>Albums</a></span><font color=#ff0000> &gt;&gt </font>

                        <span class='navlinks'><a href=viewgallery.php?cid=1>Abstract</a></span><br><br/><br/><br/></td>
</tr>
    <td><a href='viewgallery.php?cid=1&pid=240'><img

    src='photos/tb_240.jpg' border='0' alt='End Of Day' class='img'/></a></td>
    <td><a href='viewgallery.php?cid=1&pid=239'><img

    src='photos/tb_239.jpg' border='0' alt='A Photographer's Dream' class='img'/></a></td>

    <td><a href='viewgallery.php?cid=1&pid=238'><img

    src='photos/tb_238.jpg' border='0' alt='Heaven's View' class='img'/></a></td>
    <td><a href='viewgallery.php?cid=1&pid=237'><img

    src='photos/tb_237.jpg' border='0' alt='Colorful World ' class='img'/></a></td>

</tr>
<tr>
    <td><a href='viewgallery.php?cid=1&pid=241'><img

    src='photos/tb_241.jpg' border='0' alt='' class='img'/></a></td>
    <td><a href='viewgallery.php?cid=1&pid=242'><img

    src='photos/tb_242.jpg' border='0' alt='' class='img'/></a></td>
    <td><a href='viewgallery.php?cid=1&pid=243'><img

    src='photos/tb_243.jpg' border='0' alt='' class='img'/></a></td>
    <td><a href='viewgallery.php?cid=1&pid=244'><img

    src='photos/tb_244.jpg' border='0' alt='' class='img'/></a></td>

</tr>

<tr>
    <td><a href='viewgallery.php?cid=1&pid=245'><img

    src='photos/tb_245.jpg' border='0' alt='' class='img'/></a></td>
    <td><a href='viewgallery.php?cid=1&pid=246'><img

    src='photos/tb_246.jpg' border='0' alt='' class='img'/></a></td>
    <td><a href='viewgallery.php?cid=1&pid=247'><img

    src='photos/tb_247.jpg' border='0' alt='' class='img'/></a></td>
    <td><a href='viewgallery.php?cid=1&pid=248'><img

    src='photos/tb_248.jpg' border='0' alt='' class='img'/></a></td>

</tr>
<tr>
    <td><a href='viewgallery.php?cid=1&pid=249'><img

    src='photos/tb_249.jpg' border='0' alt='' class='img'/></a></td>
    <td><a href='viewgallery.php?cid=1&pid=250'><img

    src='photos/tb_250.jpg' border='0' alt='' class='img'/></a></td>
    <td><a href='viewgallery.php?cid=1&pid=251'><img

    src='photos/tb_251.jpg' border='0' alt='' class='img'/></a></td>

    <td><a href='viewgallery.php?cid=1&pid=252'><img

    src='photos/tb_252.jpg' border='0' alt='' class='img'/></a></td>

</tr>
<tr>
    <td><a href='viewgallery.php?cid=1&pid=253'><img

    src='photos/tb_253.jpg' border='0' alt='' class='img'/></a></td>
    <td><a href='viewgallery.php?cid=1&pid=254'><img

    src='photos/tb_254.jpg' border='0' alt='' class='img'/></a></td>
    <td><a href='viewgallery.php?cid=1&pid=255'><img

    src='photos/tb_255.jpg' border='0' alt='' class='img'/></a></td>

     

</table>

</body>

Hi everyone!

I am trying to figure out how to put echoed php results from mySQL database into a table ready for styling to look how i want it too.

So far i have got to the point where the results are echoed out but they are not in a good table layout. (under "latest removalspace user's)

I want it more structured in my table. I have found out how to create the table but just not been able to work out how to fit the echo's in without snytax errors???

the "new" table that i want to use is near the end of the script.

Code: [Select]
<?php 
// Make a MySQL Connection 
mysql_connect("***", "***", "***") or die(mysql_error()); 
mysql_select_db("***") or die(mysql_error()); 
 
// Retrieve all the data from the "example" table 
$result = mysql_query("SELECT company_name, location, postcode, basicpackage_description, premiumuser_description, upload FROM Companies") 
or die(mysql_error());   
 
// store the records into $row array and loop through 
while ( $row = mysql_fetch_array( $result, MYSQL_ASSOC ) ) { 
 
// Print out the contents of the entry  

echo "Name:\r".$row['company_name']; 
echo "\r\rLocation:\r".$row['location']; 
echo "\r\rPostcode:\r".$row['postcode']; 
echo "\r\nBasic Users:\r".$row['basicpackage_description']; 
echo "\r\nPremium Users:\r".$row['premiumuser_description']; 
echo "\r\nlogo:\r".$row['upload']; 
echo "<img src=\"http://www.removalspace.com/images/COMPANIES" . $row['upload'] . "\" alt=\"logo\" />";


echo "<table>
<tr><th>Comppany Name</th><th>Location</th><th>Postcode</th><th>Basic Members</th><th>Upgraded Users</th><th>Company Logo</th></tr>
<tr><td></td><td></td><td></td><td></td><td></td><td></td></tr>";
} 

?>

I want to read records from the database and print out in this table and I need help with the code.
Code: [Select]
<?php
mysql_connect(localhost,root,"");
mysql_select_db(oodb) or die( "Unable to select database");
$query=" SELECT * FROM oocust";
$result=mysql_query($query);
$num=mysql_numrows($result);
?>
<HTML><HEAD>
<script type="text/javascript">
var monthNames = [ "January","February","March","April","May","June","July",
                   "August","September","October","November","December"     ];
var today = new Date(); 
var mmyy = monthNames[today.getMonth()] + " / " + today.getFullYear();
</script>
</HEAD><BODY  bgcolor="#CCCC99" background="oldorchard.jpg"><b><center>
<font size=+2><b> Old Orchard Invoice </font>Date:
<script type="text/javascript">document.write(mmyy);</script></center>

echo "<TABLE BORDER="0" CELLPADDING="5" CELLSPACING="5" background="oldorchard.jpg">
<TD>
<TABLE BORDER="0" CELLPADDING="10" CELLSPACING="10" background="oldorchard.jpg">
<TD>
<TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" background="oldorchard.jpg">
    <TD>
<input type=text size=25 value="Old Orchard Plumbing"><br>
<input type=text size=25 value="2210 E. Hogan Hollow Road"><br>
<input type=text size=25 value="Margate, Fl  33063"><br></TD>
      <TR>
   <td>
<input type=text size=3 value="Bill To:"><br>
<input type=text size=25 value="$bname"><br>
<input type=text size=25 value="$bstreet:">><br>
<input type=text size=25 value="$bcity"><br>
<input type=text size=25 value="$contact"><br></TD>
      <tr>
   <td>
<input type=text size=5 value="Ship To:"><br>
<input type=text size=25 value="$sname:"><br>
<input type=text size=25 value="$street"><br>
<input type=text size=25 value="$scity"></td>
</TR>
      </TABLE>
      </TD>
     <TD>
<input type=text size=25 value="Invoice No: $invnum"><br>
<input type=text size=25 value="Date: $mm/dd/yyyy"><br>
<input type=text size=25 value="Terms: $terms"><br>
<input type=text size=25 value="Due Date: $duedate"><br>
<input type=text size=25 value="Order No: $ordernum"><br>
<input type=text size=25 value="Territory:"><br>
<input type=text size=25 value="Salesperson:"><br>
</TD>
</TABLE>
</TD>
<TD align=center><img src="dave pic.jpg" width=250 height=350></td>
</TABLE>

echo "</tr>";
<hr>
echo "</table>";mysql_close();
?>
</b></BODY></HTML>

hi, i have the code below where it shows the images in connection with a reference. in my img table i only have two rows but the code below keeps showing it 7 times

can you please help me?

      <table width=200>
        <div id="wrapper">



                        <!-- Content area -->
                        <div id="content">

                                <!-- We will be working inside these tags -->
                                <div id="gallery">


                                <?php

                                $images=mysql_query("SELECT img.id, img.refimage, img.image, img.thumb, users.users_id FROM img, users WHERE img.refimage='$ref' AND users_id='$user_id'");
echo '<table width="40">';
while($row = mysql_fetch_array($images))
{
$image=$row['image'];
$thumb=$row['thumb'];
echo '<div class="image_container">';
              echo "<a href='$image' rel='lightbox[roadtrip]'><img src= '$thumb' width='60' height='40' alt='$title'>";
                echo '</a></div>';
                }

?>

                                </div>
                                <!-- We will be working inside these tags -->
                        </div>



                </div>
    </table></td>

I know your going to say google it, and I did but I couldn't find a ENGLISH definition lol for someone who's clueless with how encryption work.

What are rainbow tables, and what is salting.

Also, how does salting prevent rainbow table attacks?