PHP - Is It Okay To Use A Function To Output Html?

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'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 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 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>

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;

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!

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, 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 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!

Well I have a script that executes a scan on a system set to run infinitely, and I need it to echo out a message each time it loops through, but I don't want it to echo out the message with the next loop message below it, and the next one below that etc... I've tried using the flush(); function and been messing around with that with no luck. For security reasons I don't want to release any of the processing code, but here is the basic construction of the script:

<?PHP
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
$RepeatIt = -1;
for($g=1; $g!=$RepeatIt+1; $g++)
{
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***

$ScanMessage = ":.:.: SCANNING THE HITLIST FOR MOBSTER: ".$MobName." (SCAN #$g) :.:.:"."<br/><br/>";
echo $ScanMessage;

***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
}
?>

At the moment it's returning:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #1) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #2) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #3) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #4) :.:.:

So what I want it to do is just delete the scanning message and replace it with the next scan message so while running this script you would see just the number increment on the same line.

Any suggestions?

Thanks.

I've got a few hours in this, read the manual on return (and it appears my print_r should be working!).. And I am unable to get print_r() to output the contents of my function array.

What am I doing wrong?

function getStateName()
{
$stateName = array("Alabama","Florida","Nevada");
return $stateName;
}

echo "<pre>";
echo print_r($stateName);
echo "</pre>";

been messing with this for half a hour cant find the right format for adding this $_GET in the action part of this form

Code: [Select]
<?php echo '<form name="newmessage" method="post" action='"send_message.php?goauld=".($_GET['goauld'])."";? >