PHP - Php: Setting Limit To Html Text Output?

i have a php script:

$sql5 = "select *,count(*) from rc_language_type_assoc_table group by language_type_id";
$result5 = mysql_query($sql5);                                                 //not correct
$count5 = mysql_num_rows($result5);                                   //not correct

$myFile = "/home/rainbowcode/StatsFile.txt";
$fh = fopen($myFile, 'w') or die("can't open file");

fwrite($fh, $sql5."\n");



the above is not what i  want,   i want  the actual result set of the select to print in my StatsFile
how can i achieve this please???

I have a PHP script that does some work copying some files and parsing through the files.  Then it creates an Excel file and sends it to the browser to download.  So you user will see the standard popup asking to save or open the file.  Well, I am using ob_flush to try and output text to the browser while it is working so the user knows something is happening.  But whenever I add the ob_flush lines in, it just sends a bunch of garbage text to the browser instead of downloading the file.  Anyone know a way around this?
Thanks
Mike

Hi All, I have a form with a jquery autocomplete input field. Once the user has entered 2 characters, there is a list of values (people names) containing this string that appears. This works good. The values come from a database table with two fields (names and ids). The query that extracts the names also retreives the values in the id field. What would be the syntax to set the "value" attribut of the input tag to the id of a name when the user clicks on that name in the list?   The PHP part that builds the json is :

$data[] = array(
'label' => $row['name'],
'value' => $row['name'],
'id' => $row['id']
);
echo json_encode($data);

The JS begins as follows :

jQuery(document).ready(function(){
$('#input_id').autocomplete({source:'my_jquery_suggest.php',    select: function(event, ui) {
                $(event.target).val(ui.item.value);
                $('#form_id').submit();
                return false;
            },
minLength:2,delay: 1000}).focus(function () {
               
                window.pageIndex = 0;
                $(this).autocomplete("search");
            });
...

Thanks for your help.

I am trying to be true to the principle that logic and presentation should be kept separate.

However, the only way to generate dynamic content and output is using something like PHP, so there is somewhat of a conflict.

I just wrote this Function, and I am curious if it breaks the principle above...

/**
 * Returns Online Status Indicator Markup
 *
 * Takes User's Last Activity and determines the User's Online Status.
 * Returns HTML for appropriate Online Status Indicator.
 *
 * @param DateTime $lastActivity MySQL DateTime format (yyyy-mm-dd hh:mm:ss)
 * @return string
 */
function getOnlineStatus($lastActivity){
// strtotime() converts DateTime format (yyyy-mm-dd hh:mm:ss) into a Unix Timestamp (seconds).
// time() is current time measured in the # of seconds since Unix Epoch (January 1 1970 00:00:00 GMT).
$minutesOnline = (time() - strtotime($lastActivity))/60;

// Determine Online Status.
if ($minutesOnline < 15){
// Member Online
$indicator = '<img src="/images/Light_Green_10.png" width="10" alt="Member Online" /><br />';
}else if ($minutesOnline < 30){
// Member Idle
$indicator = '<img src="/images/Light_Yellow_10.png" width="10" alt="Member Idle" /><br />';
}else{
// Member Offline
$indicator = '<img src="/images/Light_Gray_10.png" width="10" alt="Member Offline" /><br />';
}

return $indicator;
}//End of getOnlineStatus


Thanks,


Debbie

I have the two files below and want to separate php and html. How do I output forum.html with forum_post.html in it? I want to post as many forum_post.html as mysql_num_rows() says.

Code: [Select]
forum.html
======
<div>
<form method="post">
<textarea name="text"></textarea>
<input type="submit" />
</form>
</div>
<div>
[b]???[/b]
</div>

Code: [Select]
forum_post.html
======
<div>
<h1>Title</h1>
<p>Text</p>
</div>

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

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

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