PHP - Output Html Files

Hi guys I am new here

I have had a search around and can't really find out how to do this. Its quite difficult for me to explain and I am really new to PHP / mySQL - just starting out really. I hope to learn from doing small projects like this and seeing how it gets done.

So I have a mySQL DB with two different tables - one is called "notesnew" the other is called "users".

I have modified a common tutorial on how to make a "to do list" for what I am doing here.

Basically users can login and post messages on this list as them self. Each user's post appears as a list item, showing their username, the time they posted the message and the message content. The message content, time and owner of the message is stored in the "notesnew" table.

The list of user's, their passwords and their "avatar/profile" image URL location is stored in the "users" table.

Now I am having trouble getting each user's avatar image from being output next to each of their posts. The part that is confusing me is being able to match up the username's post with their content that is display - because I am posting the user's name along with their post, based on the logged in "session name" as their username. So basically, all the content being listed is being displayed from the "notesnew" table. I need to somehow figure out what each user's profile image is based on what is stored against their entry in the "users" table.

Here is the code I have so far. It is not working properly - it displays all content etc, but displays the avatar / image of the last user that has registered. Can anyone help me out here with some code that works, or pointers to try follow? I know the $finduserprofile part is incorrect in the way it goes through all user's and finds their profileimg, and that the image displayed next to each post is therefore incorrect (as it displays the last member to have registered's avatar, but its just that I don't know how else to do what I am trying to do.

Code: [Select]
<?php
//Connect to the database
$connection = mysql_connect('localhost', 'zzzz' , 'zzzzzzz');
$selection = mysql_select_db('zzzzz', $connection);

$username = $_COOKIE['ID_my_site'];

//Was the form submitted?
if($_POST['submit']){

//Map the content that was sent by the form a variable. Not necessary but it keeps things tidy.
$content = $_POST['content'];

//Insert the content into database
$ins = mysql_query("INSERT INTO `notesnew` (content, owner, dp_time) VALUES ('$content', '$username', NOW())");

//Redirect the user back to the members or index page
header("Location:index.php");
}

/*Doesn't matter if the form has been posted or not, show the latest posts*/

//Find all the notes in the database and order them in a descending order (latest post first).
$find = mysql_query("SELECT * FROM `notesnew` ORDER BY id DESC");
$finduserprofile = mysql_query("SELECT * FROM `users` ORDER BY id DESC");

//Setup the un-ordered list
echo '<ul>';

while($row = mysql_fetch_array($finduserprofile))
{
$imagelocation = $row['profileimg'];
//Continue looping through all of them
while($row = mysql_fetch_array($find))
        {

$owner = $row['owner'];
//For each one, echo a list item giving a link to the delete page with it's id.
echo '<li>' . '<img src ="' . $imagelocation . '">' . $row['owner'] . ' said at ' . $row['dp_time'] . ': ' . $row['content'] . ' <a id="' . $row['id'] . '" href="delete.php?id=' . $row['id'] . '"><img src="delete.png" alt="Delete?" /></a></li>';

}
}

//End the un-ordered list
echo '</ul>';

?>

I am trying to make PHP output a file in html and using the following code.
Code: [Select]
<?php
                                        readfile("./1/index.html"); 
                                ?>
... but it isn't working. How would I get PHP to output a file as HTML?

i'm trying to get a php database to output/display on a html webpage
and have no results from cutting and pasting code from online tutorials
i'm saving to a file with a htm extension
i believe i have the connection data right:

$db_host = 'server';
$db_user = 'username';
$db_pwd = 'password';

$database = 'database';
$table = 'table';

if (!mysql_connect($server,$username,$password))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");


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


Can someone please help me?  send code? tell me what i'm doing wrong?  Thanks

I'm trying to display my BLOB images in PHP and I've looked around in Google searches but everyone's examples seem to work for their specific code.

My table is called 'identification'.
Here's my SQL:
Code: [Select]
== Table structure for table identification

|------
|Field|Type|Null|Default
|------
|//**id**//|int(11)|No|
|image|blob|No|
|image_width|char(220)|No|
|image_height|char(220)|No|
|image_type|enum('jpeg', 'pjpeg', 'png', 'gif')|No|
|stickID|int(11)|Yes|NULL

I found this site: http://www.wallpaperama.com/forums/how-to-save-html-output-code-from-php-script-t6898.html
it demonstrates how to save html output code from php script. here is an example: http://ads4agents.com/date.php

I cant get it to work on my site...where is the correct place ad these:
ob_start();

$HtmlCode= ob_get_contents();
ob_end_flush();


How can I get this to work in my php?

view_ad.php

<html>
<body>
<center>
<br/>
<h1>Apartment Reference #: <?php
echo $_POST["reference"]; ?><br /></h1>
<br/>
<?php echo $_POST["application"]; ?>, <?php echo $_POST["deposit"]; ?><br />
<?php echo $_POST["pets"]; ?><br />
<br/>
<?php echo $_POST["community"]; ?><br />
<?php echo $_POST["interior"]; ?><br />
<?php echo $_POST["amenities"]; ?><br />
<br/>
<?php echo $_POST["contact"]; ?><br />
<a href="<?php
echo $_POST['website'] ?>"><?php echo $_POST['website'];?></a><br/>
<br/>
<br/>
<br/>
</body>
</html>

Hello! Im new here and want to start my new php carreer 
Well, I'm already working quite hard, but now I don't know what to do

I've got it so far:

<?php echo html::chars($message->text); ?>

Is there any way I could modify the output, so it just displays the first 20 characters or so?


Thank you all very much!

I have noticed that today that some of the content that is saved from my form is printing random characters and crap.

I am using htmlentities on the form input and it seems to be adding more rubbish.

I am using the UTF-8 charset as a meta tag.

Is this the correct way of using htmlentities?

htmlentities($string,  ENT_QUOTES, 'UTF-8')

Also i noticed the other day with a problem I had that using htmlentities was replacing " with &amp;&quot; when i thought it should have just been &quot;

Hi,

Ok so I have the youtube url input working and it shows the video fine have a look at
Code: [Select]
http://www.cyberhost.me/test

But now what I need is for the script to display the embed code needed for the user.

This is the script:

Code: [Select]
<?php
 $text = $_POST["text"];
 if (!isset($_POST['submit'])) { // if page is not submitted to itself echo the form
 ?>
 <html>
 <head>
 <title>Youtube code generator</title>
 </head>
 <body>
 <p>Copy and paste this url for example: http://www.youtube.com/watch?v=YdDIsImNfBY&feature</p><br/><br/>
 <form method="post" action="<?php echo $PHP_SELF;?>">
 Youtube URL:<input type="text" size="50" maxlength="50" name="text"><br />
 <input type="submit" value="submit" name="submit">
 </form>
 <?php
 } else {
 
 
//space anything that would get included in a link, add the space
$text = str_ireplace(array("<br />","\n","\r"),array(" <br /> "," \n "," \r "),$text);
$text = str_replace("  ", " ", $text);
//explode the text by spaces
$text_explode = explode(" ",$text);
//loop replacing youtube links with embed codes, if not youtube embed return text
foreach($text_explode as $words){
if (preg_match('~(?:youtube\.com/(?:[^/]+/.+/|(?:v|e(?:mbed)?)/|.*[?&]v=)|youtu\.be/)([^"&?/ ]{11})~i', $words, $match)) {
$vidid = $match[1];//the id
$link = "http://youtu.be/$vidid";//short link to video

//grab the title
$visit_url = "http://gdata.youtube.com/feeds/api/videos/".$vidid;
$doc = new DOMDocument;
 @$doc->load($visit_url);
$link_title = $doc->getElementsByTagName("title")->item(0)->nodeValue;
if($link_title == ""){
$link_title = "Click to watch video.";
}
//display a link
echo "<h3><a href='$link' TARGET='_blank'>$link_title</a></h3>";
//embed the video
echo "<div>";
echo "<object style='height: 390px; width: 640px'>
<param name='movie' value='http://www.youtube.com/v/$vidid&fs=1'>
<param name='allowFullScreen' value='true'>
<param name='allowScriptAccess' value='always'>
<embed src='http://www.youtube.com/v/$vidid&fs=1' type='application/x-shockwave-flash' allowfullscreen='true' allowScriptAccess='always' width='640' height='390'></object>";
echo "</div><br />";
} else {
//keep the original words
echo " $words ";
}
}
 }
?>

The code I need displayed below is

Code: [Select]
<p> <img height="350" width="425" class="fw_media_youtube fw-parse" alt="YouTube-CODE PLACED HERE" src="http://thumbs.webs.com/Platform/mediaPreview.jsp?type=YouTube&amp;id=CODE PLACED HERE"/></p>

Where you see "CODE PLACED HERE" is where i need the video id placed and then for it to be displayed.

Any idea how I would do this?

Thanks in advance

Hi there,    My friend asked me to help him perform a task today and I was completely stumped as to how I should complete it. Being someone who is reasonably experienced with PHP programming I didn't think I would find it absolutely impossible to complete, maybe hard, but not impossible. So I wondered if someone would now be able to explain to me in order to assist me in expanding my knowledge how to complete this task.    https://www.dropbox....B8M6cr_z7a?dl=0   Here is a link to the files he sent me, please ignore the C++ section.   If anyone could help / begin to give an explanation please fire away. I feel so bad about myself for NOT knowing that I'm now motivated to learn more!   Many thanks!

hi there, the code below is suppose to display something like the attachement "code2" but instead it displays something like attachement "code1" please assist in find what is wrong with my echo lines.

<?php 
                        $counter = 2;
			$sqlq="select * from state WHERE status = 0 ";
			$categorysqlq = mysql_query($sqlq);
			$varq = mysql_num_rows($categorysqlq);

			while($catfetchq = mysql_fetch_array($categorysqlq))
			{
 $cnty =  $catfetchq[0];

		 $sqllq="select * from vehicle WHERE country = '$cnty' ";
			$categorysqllq = mysql_query($sqllq);
		
			
			$numsql = "select * from branchaddr WHERE state = '$cnty' ";
			$numquery = mysql_query($numsql);
$varqa = mysql_num_rows($numquery);
$cntyfetchq= mysql_fetch_array($numquery);	
if($varq != 0){
					if($counter == 2){
                                            	echo "<tr><td><a href=\"transport2.php?id=".$cntyfetchq['state'].">".$catfetchq[1]."(<span style=\"color:red\">".$varqa."</span>)</a></td>";                                                                              
						$counter--;
					}
					else{						
						echo "<td><a href=\"transport2.php?id=".$cntyfetchq['state'].">".$catfetchq[1]."(<span style=\"color:red\">".$varqa."</span>)</a></td></tr>";                                          
						$counter = 2;
					}
				}
			}	
?>

Attached Files  code1.png   12.65KB   0 downloads  code2.png   25.34KB   0 downloads

Hi im using ftp_rawlist () to list files in my web hosting folder /public_html/

it works fine, but is there anyway to only show/list .php & html files?

I am trying to find out how to convert HTML code to ePub format dynamically, i know it can be done, but i was wondering if anyone had a tutorial i could follow or something, Thanks.

I need some help with this. I created an index.php page and I inserted an include statement that referred to a header.html page. It works when working it in MS Webmatrix but when I put it on my server I only get my index.php page. My include statement will not get the header.html page. What am I doing wrong?  I also tried changing all of my files to .php extensions also and still the same.

Here is my index.php file:
 

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Braswell Electric</title>
<link rel="stylesheet" href="braswellelectric.css">
</head>

<body>
<div>
<?php include('/includes/header.html');?>
<?php include('/includes/aside.html');?>

<article class="About">
<header class="AboutHeader">
<h2>About Us</h2>
</header>
<p><b>Braswell Electric</b> is a family business owned and operated by Jim and Joyce Braswell located in Sylacauga, Alabama. Braswell Electris has been in business in Sylacauga for 25 years and covers the greater Talladega County area. We do new homes, remodels, or any small electrical issues you may have. We are licensed and insured and we are here for your residential needs.</p>

<img src="pics/Coach Light.jpg" alt="Coach Light" >
<img src="pics/Outside Plug.jpg" alt="Outside Plug">
<img src="pics/Service.jpg" alt="Service">

</article>
</div>
</body>
</html>

Here is my header.html file

<!DOCTYPE html>

<html lang="en">
<head>
<meta charset="utf-8" />
<title></title>

</head>
<body>
<header class="Header">
<h1 style="display: none">Braswell Electric</h1>
<img src="pics/lightning1.jpg" alt="Header Pic">
</header>

</body>
</html>

Edited by Ch0cu3r, 27 August 2014 - 12:37 PM.