PHP - Need Php / Mysql Blog Help Urgent

 

Hey I have this blog http://www.nikita-andrews.com/ingrid/?page_id=34 ... Im trying to remove the prettyphoto enlargement on posts to this page ... and not sure how to go about it.

The code for thumbnail.php is
Code: [Select]
<?php if (has_post_thumbnail()) { 
$data = get_post_meta( $post->ID, 'key', true );
if ($data[ 'project_link' ]) { ?>
<a class="externalLink tooltip" title="View Live Site" target="_blank" href="<?php echo $data[ 'project_link' ]; ?>">&infin;</a>
<?php } ?>

<?php $large_image_url = wp_get_attachment_image_src( get_post_thumbnail_id(), 'large');
if ($data[ 'video_link' ]) { ?>
<a class="thumbLink video" rel="prettyPhoto" href="<?php echo $data[ 'video_link' ]; ?>">
<?php } else { 
echo '<a class="thumbLink" href="' . $large_image_url[0] . '" title="' . the_title_attribute('echo=0') . '" >'; 
}
the_post_thumbnail(); 
echo '</a>';
} ?>
I want the thumbnails to still show but just not enlarge. Infact itd be even better if they just linked directly to the post itself.

Any help would be much appreciated!

So I started a blog project just to help me out with learning php.
This is my post form

<form action="insert.php" method="post">
Title: <input type="text" name="title">
<br>
Post: <input type="text" name="post">
<br>
Author: <input type="text" name="author">
<br>
<input type="submit">
</form>

Insert.php

<?php
$con = mysqli_connect("localhost","test","","test");
// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

// escape variables for security
$title = mysqli_real_escape_string($con, $_POST['title']);
$content = mysqli_real_escape_string($con, $_POST['post']);
$author = mysqli_real_escape_string($con, $_POST['author']);

$sql="INSERT INTO article (title, content, author)
VALUES ('$title', '$content', '$author')";

if (!mysqli_query($con,$sql)) {
  die('Error: ' . mysqli_error($con));
}
echo "1 record added";

mysqli_close($con);
?>

But when I try to display that information he

<h1>Title: </h1> <?php echo $title; ?>
<h2>Content: </h1> <?php echo $content; ?>
<h3>Posted by: </h1> <?php echo $author; ?>

It doesn't work and I get this:

( ! ) Notice: Undefined variable: title in C:\wamp\www\test\index.php on line 33
Call Stack
#    Time    Memory    Function    Location
1    0.0000    239144    {main}( )    ..\index.php:0
Content:

( ! ) Notice: Undefined variable: content in C:\wamp\www\test\index.php on line 34
Call Stack
#    Time    Memory    Function    Location
1    0.0000    239144    {main}( )    ..\index.php:0
Posted by:

( ! ) Notice: Undefined variable: author in C:\wamp\www\test\index.php on line 35
Call Stack
#    Time    Memory    Function    Location
1    0.0000    239144    {main}( )    ..\index.php:0

The form works because when I looked at the database, the information was there. The problem is getting that information and displaying it in the right place, how can i fix that?

Just in case, this is my index:

<?php
include ('connect.php');
include ('header.php');

?>
<div id="container">
<div id="rightcol">

<form action="insert.php" method="post">
Title: <input type="text" name="title">
<br>
Post: <input type="text" name="post">
<br>
Author: <input type="text" name="author">
<br>
<input type="submit">
</form>

</div>


<div id="content">

<h1>Title: </h1> <?php echo $title; ?>
<h2>Content: </h1> <?php echo $content; ?>
<h3>Posted by: </h1> <?php echo $author; ?>

</div>
</div>

<?php
include "footer.php";

?>

</div>

 

(I am not an expert or even a begineer at PHP, so sorry if none of this makes sense)

Right ok,

I have an invitation form built and tested working correctly between a php page and a mysql database and got the mail function to work but now the mail function is throwing all emails into the junk mail folder of outlook.

The user of the invitation form has to enter a valid email address (the form has its own validation for each textbox and email has been set to required email address).

So I have been asked to set up a mailto instead of using the mail function (dont ask me why...) And I cant, for the life of me, figure out how to get this to work.

What I have thought of so far is:

Index.html (Invitation page)

V

sendinvitation.php (previously the page with the mail function) now includes a confirmation of the data being sent to the database and a button to go to the next php

V

sendmail.php (I want this to be able to get the data from the database and then open up the users email client and pre populate the email with the body text)

Is this even possible? If not, is there a reason why the email keeps getting thrown into the junk mail.

Please, any help would be most appreciated!

EDIT:

Let me explain a bit more, just re-read over and its very brief (this probably will be too)

I want to invitation form to submit the users data to my database in mysql, then when the form as been submitted, to be able to then grab the data and pre populate an email using variables that are in the php linked to the database (Im guess the php would go from POST to GET?)

I am creating a member site and I need help with coding the database. Here go the code

Code: [Select]
<?php
function connect(){
$DB_USER =  "root";
$DB_PASSWORD = "";
$DB_HOST = "localhost";
$dbc = mysql_connect ($DB_HOST, $DB_USER, $DB_PASSWORD) or $error = mysql_error();
mysql_select_db("membership") or $error = mysql_error();
mysql_query("SET NAMES `utf8`") or $error = mysql_error();

if($error){echo "<!-- $error -->";}}

function disconnect_data(){
@mysql_close($dbc);
@mysql_close();
}
?>I am suppose to fill it in with my database info but idk what to fill in! help me please! where do i enter the info!

<?php

$possibles[];
$alreadychosen[];
 
for ($i = 0; $i<20;$i++) $possibles =i+1;

for (int $i = 0; $i<8; $i++)
{
   $boolean= false;
   $randIndex=0;
   
   do
   {
      $randIndex = rand(1,20);
      for ($j = 0; $j< $i && !$hasInt; $j++)
      {
         if ($possibles[$randIndex] == $alreadyChosen[$j])
         {
            $hasInt = true;
         }
      }
   } while ($hasInt);
   {
   $alreadyChosen = $possibles[randIndex];
   echo($alreadyChosen);
    }
   
for ($i = 0; $i<8;$i++)
{
if($alreadyChosen<10)
{
echo ('<a href="/mp/info130'+$i+'.htm"><img src="/mp/p130'+$i+'-1.jpg"  height=180 width=120 align=left hspace=0 vspace=2 border=0 class=TopImages></a>');
}
else if($alreadyChosen>10)
{
echo ('<a href="/mp/info13'+$i+'.htm"><img src="/mp/p13'+$i+'-1.jpg"  height=180 width=120 align=left hspace=0 vspace=2 border=0 class=TopImages></a>');











it should select 8 images out of 20 but don't repeat please

hI for all
Am developping a script that allow to each user (seperatly ) upload or download his files and list all files in categories (such music or photos...) but i can 't achieve that the main problem is to upload files to server and store them in data base also i have to list for each user his files seperatly when he log in
any idea please
 

Please help me with this:
with this code i have only fetched out the subjects and i need to fetch out value for the following too from the database
1. GRADE
2. Contious Assessment:
3. Exam Scores:
4. Exam Scores
5. Weighted Average:
6. Last Term Cummulative:
7. Cumulative  (c+d)/2:
8. Comment:
but now i can only get the foreach work for subject alone..


$l=mysql_query("SELECT * FROM result WHERE school_id='$id' AND student_reg_id='$st'") or die (mysql_error());

if (mysql_num_rows($l) > 0)
         {
         while ($row = mysql_fetch_array($l))
               {//
               $pwrlist[$row['ajax_result_id']]=$row['subject'];
               //$
               }
         $numpwr = count($pwrlist);
         $thresh = 3;
         $maxcols = 18;
         $cols = min($maxcols, (ceil(count($pwrlist)/$thresh)));
         $percol = ceil(count($pwrlist)/$cols);
         $powerchk = '';
         $i = 0;
         foreach ($pwrlist as $id => $pwr)
                  {
                  if (($i>0) && ($i%$percol == 0))
                        {
                $powerchk .= "</td>\n<td valign='top'>";//echo "<br>";
                        }
                        
                        
                  $powerchk .= " <table width='280px' class='hovertable'>
                  
                <tr>
                  <td width='251px' height='34' align='left' valign='middle' bgcolor='#D6DFEB'><span class='style19'><font size=2px>$pwr</font></span></td>
                  <td width='19px' align='left' valign='middle' bgcolor='#D6DFEB'><span class='style1'>GRADE:</span></td>
                  <td width='20px' align='left' valign='middle' bgcolor='#FFFFFF'><span class='style13'>B3</span></td>
                </tr>
                <tr>
                  <td height='34' colspan='3' align='left' valign='top' bgcolor='#FFFFFF'><span class='style20'>&raquo; (a) Contious Assessment: 80<br />
                    &raquo; (b) Exam Scores: 90<br />
                    &raquo; (c) Weighted Average: 168<br />
                    &raquo; (d) Last Term Cummulative: 78<br />
                    &raquo; (e) Cumulative  (c+d)/2: 123 </span></td>
                </tr>
                <tr>
                  <td height='20' colspan='3' align='left' valign='top' bgcolor='#FFFFFF'><span class='style17'>Comment: His is a responsible boy</span></td>
                </tr>
            </table><br>\n";
                  $i++;
                  }
      
         }

Hi guys,

Am having trouble with my OO php blog.  i can add, delete and search for messages but cannot update them as i get the folowing eror message (see below)
Quote

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM messages WHERE id = NULL' at line 1'


Have checked that when i hover over the link i do get an id number and it is pointing to the correct cmd i.e. blogAmend.

Any ideas as to where i am going wrong, files attatched for further info.

Hi am in the middle of making a blog but am having problems with one page am working on if anyone can help me please.
What is am looking for is to post username and avatar instead of just the username.
I have already paid some guy to work on this but he didnt get back to me and  ihave no more cash to give for the code to be finished so
i would really appreciate if someone could help to finish this off please thanks.

this is the where the username and text shows which i would like avatar to show as well.
Code: [Select]
<?php
    $query = yasDB_select("SELECT * FROM user WHERE username = '$user'");
$row = $avatarfile;
$query = yasDB_select("SELECT * FROM topic WHERE userid = '$id' ORDER BY id DESC LIMIT 5");
    if($query->num_rows == 0) { ?>
<div id="memberstext">This topic has no comments, be the first to add one!</div>
<?php 
} 
else { 
while($row = $query->fetch_array(MYSQLI_ASSOC)) {
$text = $row['comment'];
$text = str_replace(':D','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/biggrin.gif" title="biggrin" alt="biggrin" />',$text);
$text = str_replace(':?','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/confused.gif" title="confused" alt="confused" />',$text);
$text = str_replace('8)','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/cool.gif" title="cool" alt="cool" />',$text);
$text = str_replace(':cry:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/cry.gif" title="cry" alt="cry" />',$text);
$text = str_replace(':shock:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/eek.gif" title="eek" alt="eek" />',$text);
$text = str_replace(':evil:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/evil.gif" title="evil" alt="evil" />',$text);
$text = str_replace(':lol:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/lol.gif" title="lol" alt="lol" />',$text);
$text = str_replace(':x','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/mad.gif" title="mad" alt="mad" />',$text);
$text = str_replace(':P','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/stlyes/images/smileys/razz.gif" title="razz" alt="razz" />',$text);
$text = str_replace(':oops:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/redface.gif" title="redface" alt="redface" />',$text);
$text = str_replace(':roll:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/rolleyes.gif" title="rolleyes" alt="rolleyes" />',$text);
$text = str_replace(':(','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/sad.gif" title="sad" alt="sad" />',$text);
$text = str_replace(':)','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/smile.gif" title="smile" alt="smile" />',$text);
$text = str_replace(':o','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/surprised.gif" title="surprised" alt="surprised" />',$text);
$text = str_replace(':twisted:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/twisted.gif" title="twisted" alt="twisted" />',$text);
$text = str_replace(':wink:','<img src="' . $siteurl . 'templates/' . $setting['theme'] . '/styles/images/smileys/wink.gif" title="wink" alt="wink" />',$text);
            if ( $row['useavatar'] == '1' ) {
        $avatarimage = $siteurl . 'avatars/' . $row['avatarfile'];
            }
            else { 
        $avatarimage = $siteurl . 'avatars/useruploads/noavatar.gif';
            } ?>
<div id="box">
<div class="name"><img src="<?php echo $avatarimage;?>" height="40" width="40" align="left"><br /><?php echo $row['name'];?></div>
<div class="comment_text"><?php echo $text;?></div></div>
This is the form part of it to add the text
Code: [Select]
<div id="box2">
<form name="addcomment" method="post" action="">
<strong>Message:</strong><br />
<textarea name="comment" rows="3" cols="40" id="comment_message"></textarea><br />
<input name="userid" type="hidden" value="<?php echo $id;?>" />
<input type="hidden" name="timestamp" id="timestamp" value="<?php echo time(); ?>" />
</center>
<!-- start of smiles -->
<div id="smiles"><center>
<a href="javascript:addsmilie(' :D ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/biggrin.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :? ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/confused.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' 8) ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/cool.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :cry: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/cry.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :shock: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/eek.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :evil: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/evil.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :lol: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/lol.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :x ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/mad.gif';?>" border="0"  /></a><br />
<a href="javascript:addsmilie(' :P ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/razz.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :oops: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/redface.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :roll: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/rolleyes.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :( ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/sad.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :) ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/smile.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :o ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/surprised.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :twisted: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/twisted.gif';?>" border="0"  /></a>
<a href="javascript:addsmilie(' :wink: ')"><img src="<?php echo $siteurl.'templates/'.$theme.'/styles/images/smileys/wink.gif';?>" border="0"  /></a>
</center></div>
<input name="name" type="hidden" value="<?php echo $_SESSION['user'];?>" /><br />
    <input name="addcomment" type="submit" value="Add Comment" style="border: 1px solid #000; margin-top: 2px;" />
    </form></div>

Hi all,

I am trying to implement a search of a blog, using Object Oriented PHP, a concept which seems a little alien to me.
I have had an attempt at it but it doesn't seem to work, but am not really sure why.

I think that i have told the search on post to refer to the command BlogSearch and then within that command look for the titles of the blogs that are the same as the search and display them.

Any help greatly appreciated.



<?php
/*views/index.php*/

require_once("ViewHelper.php");

ViewHelper::DisplayHeader("Blog index");?>

<h1>Blog index</h1>

<p>You can <a href="index.php?cmd=BlogAddForm">add messages</a> !</p>

<form action="index.php?cmd=BlogSearch" method="post">
 Search: <input name="search"> 
 <input type="submit" value="Search!"> 
</form>

<?
 foreach($data as $message)
 echo("<div class=\"message\">
 <h2>{$message['title']}</h2>
 <p>{$message['message']}</p>
 <a href=\"index.php?cmd=BlogDelete&id={$message['id']}\">Delete this message</a>
 </div>");
?>

<?ViewHelper::DisplayFooter();?>

<?php


require_once("ViewHelper.php");

ViewHelper::DisplayHeader("Blog index");?>
<?
 foreach($title as $search)
 echo("<div class=\"message\">
 <h2>{$message['title']}</h2>
 <p>{$message['message']}</p>

 </div>");
?>

<?ViewHelper::DisplayFooter();?>


?>

hello, i have been trying to find scripts or write a custom php script so i can have a feedback/comment type blog on my website. im trying to go for the same type of design layout and function as the blog on this site: http://www.jessicaswift.com/treasuring/ I have found a few scripts but they are on sites that want me to pay for the scripts and coding, but im not sure if its legit or even what im looking for cause they dont have full demos of them. if anyone could help me out by pointing me in the right direction with a website or tutorial for what im trying to do. Im not sure if javascript would be better for what im trying to do. cause i dont want to have a full out blog like from wordpress or blogger.com my site im building for my sister is www.jessicadurrant.com if you go to the blog page you will see its a wordpress blog, which i dont want to use. i would like to set up something like the blog that is on the first website link i posted about. Again any help would be greatly appreciated.

Hello
Im trying to figure out how to use flat textfiles to my blogproject but cant get the grip on it. It has to be filebased. I can't find any descent tutorial on the web either and it starts really getting on my nerves...

1. How do i save new blogposts in a textfile so they can be easily read? Should i use only one file with append and write all blogposts to it one after another? or save a new textfile for each new blogpost/entry? If so, how do i name them so they don't write over each other accidentally. I need to save (date+writer+title+blogpost).

2. How do i read the files so i can sort them by date/time , latest entry up/oldest entry down? they should appear on my blog startside in the middle one after another. Should i read each blogpost into an array so i can sort them or what? If so how do i do that?

3. I need a list of links connected to each blogpost so when you click link the correct blogpost is shown in the middle of the page same side as the links. the links should be sorted so all posts from oktober is shown under "oktober" and so on...
 
I have ripped half my hair off by now so any general advice how i should do would be appreciated...

I am building a blog server with dreamweaver and phpMyAdmin so I have an wpindex.php page showing the topics and a topic page, wptopic.php showing only that topic. I need to create a link from the wpindex.php to wptopic.php.
The link is:
Code: [Select]
wptopic.php?ID=<?php echo $row_Recordset1['ID']; ?>
*Recordset1 is a query of the blog post table*
However, when I tested it, all post's link are  'wptopic.php?ID=1'.
How can I fix it?

Also, in the wptopic.php page, there is a place to show comments.
However, when there is no comment, there is still a 'says' word in the page. how can I make the 'says:' disappear when there is no comments?
The Code:
Code: [Select]
<p>Comment:</p>
            <p align="right"><?php echo $row_Recordset2['comment_author']; ?>says:</p>
            <p align="right"><?php echo $row_Recordset2['comment_content']; ?>*Recordset2 is a query of the blog reply table*

Thks!