PHP - Is There A Way To Display A Certain Amount Of Text?

Hi,

Wonder if someone could help with the problem below. Got a main page that includes a header, footer and a link to a database. I can get the two Includes to work but can't seem to display the database fields in the body of the page. What has me baffled is that it appears to be connecting to the database, (Opening the connection to the database server The connection worked. The link is: Resource id #3) but no text (see below for database text) is appearing on the screen. Yet I'm not getting a "page_not_found" message. I can go to the database in MYSQL console and query it successfully. Read and (hopefully) applied the section Debugging: A Beginner's Guide, but still can't see the problem. Any help greatly appreciated.

Bren

--------------------CODE FOR MAIN PAGE START-------------------


<?php

  $page_name = $_REQUEST['name'];
  /*http://localhost/exemples/page.php?name=about_us*/
 
// Get the body of the page
  mysql_connect("localhost","root","") or die(mysql_error());
  mysql_select_db("test") or die(mysql_error());
  $sql = "SELECT * from pages WHERE name='$page_name'";
 
 print "Opening the connection to the database server<br>";
  $link = mysql_connect("localhost","root", "");
  print "The connection worked. The link is: $link <br>";
 
 /*
 --------------What is being selected from the database--------------
+----------+------------------------------------------------------------------------+
| name | body
|
+----------+------------------------------------------------------------------------+
| about_us | <h1>About Us</h1> ACME Toys has been established in 1850 to provide toys
| to children all over the world
+----------+------------------------------------------------------------------------+
1 row in set (0.00 sec)
----------------------------------------------------------------------
*/
  $result = mysql_query($sql) or die(mysql_error() );
  // If the page is not found, redirect to a static page
  if(mysql_num_rows($result) == 0 ) {
     header("Location: page_not_found.html");
  }
  $row = mysql_fetch_assoc( $result );
  $body = stripslashes( $row["body"] );
 
   
  // Include the header
 include("c:/wamp/www/exemples/header.php");
  // Print the body of the page
 echo $body;
  // Include the footer
  include("c:/wamp/www/exemples/footer.php");

?>


--------------------CODE FOR MAIN PAGE END-------------------

Hi all

I have a MySQL data base that is saving information from a form. One the form a user can add a business name which is text and a logo if they have one.

Now on my web page I want to beabe to display the picture if present if not I would like it to display the business name. How do I do this please. I know how to conect to DB etc just having problems getting my head around this problem.

Hi,

I have the following code in a WordPress theme which displays a companies website, Twitter and Facebook links.

What I am trying to do is display the text "Useful Links:" if one of the links exists, and hide the text if all are not present.

<p>Useful Links:</p>
<?php if ( $website = get_the_company_website() ) : ?>

                            <a class="company-website" href="<?php echo esc_url( $website ); ?>" itemprop="url" target="_blank" rel="nofollow"><?php _e('Website', 'jobseek'); ?></a>

                        <?php endif; ?>

                        <?php if ( get_the_company_twitter() ) : ?>

                            <a class="company-twitter" href="http://twitter.com/<?php echo get_the_company_twitter(); ?>"  target="_blank"><?php _e('Twitter', 'jobseek'); ?></a>

                        <?php endif; ?>

                        <?php
                        $facebook_link = get_post_meta( get_the_ID(), '_facebook_link', true );
                        if ( ! empty($facebook_link) ) : ?>
                            <a class="company-facebook" href="<?php echo $facebook_link; ?>"  target="_blank">Facebook</a>
   <?php endif; ?>

What would be the best way to show/hide the text depending on if the items are present or not?

Thanks

Hi there,

I am trying to write a simple piece of code that will display a little text phrase on every Friday 13th in any year.

How would I best go about doing this?

Thank you.

hey guys so im trying to display data into text boxes that are fetched from database according to checkbox with value id.

processing is located before <!DOCTYPE html>:

if(isset($_POST['edit_event']) && isset($_POST['check']))
{
    require "connection.php";
    foreach ($_POST['check'] as $edit_id) 
    {
	$edit_id = intval($GET['event_id']); //i tried (int)$edit_id;
	$sqls = "SELECT event_name,start_date,start_time,end_date,end_time,event_venue FROM event WHERE event_id IN $edit_id ";
	$sqlsr = mysqli_query($con, $sqls);
	$z = mysqli_fetch_array($sqlsr);
     {
}

button and form opens:

<form method="post" action="event.php">
<input type="submit" name="edit_event" value="Edit Event">

this is the html where the data will be echoed:

<div id="doverlay" class="doverlay"></div>
<div id="ddialog" class="ddialog">
    <table class="cevent">
    <thead><tr><th>Update Event</th></tr></thead>
    <tbody>
        <tr>
            <td>
            <input type="text" name="en_" value="<?php echo $z['event_name']; ?>">
            </td>
        </tr>
        <tr>
            <td>
            <input type="text" name="dates_" value="<?php echo $z['start_date']; ?>">
            <input type="text" name="times_"  value="<?php echo $z['start_time']; ?>">
            </td>
        </tr>
        <tr>
            <td><input type="text" name="datee_" value="<?php echo $z['end_date']; ?>">
            <input type="text"  name="time_" value="<?php echo $z['end_time']; ?>">
            </td>
        </tr>
        <tr>
            <td><input type="text" name="ev_" value="<?php echo $z['event_venue']; ?>">
            </td>
        </tr>
        <tr>
            <td><input type="submit" name="update" value="Update Event" id="update">
            <input type="submit" id="cancelupdate" name="cancel" value="Cancel" >
            </td>
        </tr>
    </tbody>
    </table>
</div>

this is the part which is populated by data from database where isset($_POST['check']) gets the 'check' from:

echo 
    "<tr>
        <td><input type='checkbox' name='check[]' value='$id'>$name
      </td>
     </tr>";

</form> thanks in advance!
Edited by noobdood, 19 May 2014 - 10:42 PM.

I wonder if someone can advise me on how to best tackle this issue.

At the moment I am displaying a gallery of images pulled from the database. These are displayed as a thumbnail across my page, currently 4 in each row (then a new row is started dispalying the next 4 thumbnails). This works fine and does exactly what it should do.

Now however I would like to display the username of who uploaded the image underneath each thumbnail.
So it would go something like this:

Display first 4 thumbnails pulled from database - breakline - Display username under each thumbnail - repeat for remainder of images, e.g:

image    image   image   image
user       user      user     user

image    image   image   image
user       user      user     user

How would I go about this so it doesn't just display all the images in one vertical column, e.g:

Image
User
Image
User
Image
User

I hope this makes sense.

Any help would be greatly appreciated.

Hello.   I'm not sure whether this would come under PHP or HTML, but some sites display how many shares an article has had in a font, like this:   https://dl.dropboxus...0726.183853.png   What would the best way of doing this be?   Thanks.

I have a Php application that already has 2 buttons with input on the index page that perform some functions and output to different Php pages. Works good. How do I add a button with no input that would just perform a function and then just display a popup window showing the contents of a text file? I want to add several of these buttons for different functions and just display the contents of the resulting text files in popup windows. Any help would be greatly appreciated. Thanks in advance.

Error:
Code: [Select]
No error, Im have trouble Having This Loop Select Only 2 Uploads At a Time.
Code:
Code: [Select]
<?php

//porperties
$result = mysql_query("SELECT * FROM uploaded");
while($r=mysql_fetch_array($result))
{
   $link=$r["link"];
   $name=$r["name"];
   $type=$r["type"];
   $size=$r["size"];
   $date=$r["date"];
   $id=$r["id"];
echo "
The File $name Was Currently Updated<br>
Size: $size<br>
Type: $type<br>
Date Updated: $date<br>
Link: <a href='$link'>Download</a><br><br>
";
}
?> 
Couldn't Think of a Good name For this,Sorry

Code: [Select]
${$payment['amount']}
using the $ next to it doesn't work

I am using itinside double quotes, any way I can get that dollar sign right next to it? This for people buying stuff off my forum i want the amount to show right by the $ dollar sign

And im working inside double quotes only

If I knew what to call it I could have searched it.  So I will just explain.

I have a form that is pulling from a database to build the following.
echo <input name='$row[id]' type='text' id='$row[id]' size=2>;

This will build a page that has this
<input name='22' type='text' id='22' size=2>
<input name='54' type='text' id='54' size=2>

This part works great.  The problem is when I try to add it to the database.  How can I insert variables that I don't know the names of?  They will be something like $_POST[22]   $_POST[54] and so on.  I hope someone can understand my jibberish.

I am sure there is a WAY better way to do this.

Hey quick question on my homepage there is a featured content section, which is populated from my DB some of the posts are really long so I would like to limit the amount of text. how can I do this?  also is there a way to make sure if does not cut a word in half?

thanks

Okay, I have a healing spell that allows people to regain stats when it's cast. But, how do I limit it so that they can't go over their maxhp?

Here's what I have so far:


$db->execute("UPDATE `users` SET `hp`=?, `mp`=?, `energy`=? WHERE `id`=?", array($player->hp + $healspell, $player->mp - $spell['mp'], $player->energy - $spell['energy'], $player->id));


What do I need to do in this to tell it to limit it to the maxhp but never going over it? $healspell is a random number, so it is quite possible to go over the maxhp at the moment.

Thank you!

Hi All,

Im new to this forum but think its going to be a regular location for me for quite a while.

Im very very new to php and the guy that was doing code for me is not responding to emails, so i thought id have a go myself...lol
at the moment im going through the trial and error phase while learning.

I have edited some of the code he has put on the site to create a new look.
the original page: http://www.ridersguide.co.uk/county_accommodation.php?county=4;
the one im trying:http://www.ridersguide.co.uk/county_accommodation2.php?county=4;

The new bit is to add a preview of the text for the page.

echo $row[ad_text];
the code above brings up all the text but i only want to show the first 4 or 5 lines. Is this possible in php?

Any help appreciated

Neil

Hi, I have a database where I store times with the Now(); function.

What I want is:
When the viewer looks at the post, instead of it saying: Posted: 2010-11-14 19:08:14,
I want it to say posted: x hours ago, Posted: x days ago, etc.

Any help with this would be appreciated!