PHP - Problem With Displaying ' In Textbox

Hey, I have written a script for a very simple PHP wall and comment system. This works fine but the problem I have is displaying the comments. It seems to display the comments associated with the post as well as the comments on the posts above it. I have checked the database and the  post ID's are correct.

Here is my code:

Code: [Select]
<?php
$wallDisplay = '';
$commentDisplay = '';

$wallDisplaySql = mysql_query("SELECT * FROM wall WHERE to_id='$id' ORDER BY datetime DESC") or die (mysql_error());

while($row = mysql_fetch_array($wallDisplaySql)){
$wallPostId = $row["id"];
$to_id = $row["to_id"];
$from_id = $row["from_id"];
$message = $row["message"];
$dateTime = $row["datetime"];


$getFromData = mysql_query("SELECT username FROM members WHERE id='$from_id'") or die (mysql_error());

while($row2 = mysql_fetch_array($getFromData)){
$wallUsername = $row2['username'];
}

$displayComments = mysql_query("SELECT * FROM wallComments WHERE wallPostId='$wallPostId' ORDER BY datetime DESC");


while($row3 = mysql_fetch_array($displayComments)){
$wallComment = $row3['comment'];
$commentFrom = $row3['from_id'];
$commentDate = $row3['datetime'];


$getUsername = mysql_query("SELECT username FROM members WHERE id='$commentFrom'");

while($row4 = mysql_fetch_array($getUsername)){
$commentUsername = $row4['username'];
}

$cheersCheck_pic = "members/$commentFrom/pic1.jpg";
$cheersDefault_pic = "members/0/defaultMemberPic.jpg";
if (file_exists($cheersCheck_pic)) {
    $cheers_pic = "<img src=\"$cheersCheck_pic?$cacheBuster\" width=\"40px\" />"; 
} else {
$cheers_pic = "<img src=\"$cheersDefault_pic\" width=\"40px\" />"; 
}

$commentDisplay .= '<table width="500px" align="right" cellpadding="4" bgcolor="#FFF">
        <tr>
          <td width="10%" bgcolor="#FFFFFF"><a href="member_profile.php?id=' . $commentFrom . '">' . $cheers_pic . '</a><br />
          </td>
          <td width="90%" bgcolor="#DBE4FD"><a href="member_profile.php?id=' . $commentFrom . '"><span class="blackText">' . $commentUsername . '</span></a> &bull; <span class="blackTetx">' . $commentDate . '<br /><font size="1"></font></span><br />
          <span class="blackText">' . $wallComment . '</span></td>
        </tr>
      </table>';
}

$cheersCheck_pic = "members/$from_id/pic1.jpg";
$cheersDefault_pic = "members/0/defaultMemberPic.jpg";
if (file_exists($cheersCheck_pic)) {
    $cheers_pic = "<img src=\"$cheersCheck_pic?$cacheBuster\" width=\"40px\" />"; 
} else {
$cheers_pic = "<img src=\"$cheersDefault_pic\" width=\"40px\" />"; 
}

$wallDisplay .= '<table width="100%" align="center" cellpadding="4" bgcolor="#FFF">
        <tr>
          <td width="7%" bgcolor="#FFFFFF"><a href="member_profile.php?id=' . $from_id . '">' . $cheers_pic . '</a><br />
          </td>
          <td width="93%" bgcolor="#DBE4FD"><a href="member_profile.php?id=' . $from_id . '"><span class="blackText">' . $wallUsername . '</span></a> &bull; <span class="blackTetx">' . $dateTime . '<br /><font size="1"></font></span><br />
          <span class="blackText">' . $message . '</span></td>
        </tr>
      </table>
  <div id="commentList">' . $commentDisplay . '</div>
  <div id="comment" align="right">
<form id="comment" name="comment" method="post" action="member_profile.php?id=' .$id. '">
<textarea name="comment" id="comment" rows="1" cols="35"></textarea>
<input type="hidden" name="wallPostId" id="wallPostId" value="'. $wallPostId .'" />
<input type="hidden" name="commentFrom" id="commentFrom" value="'. $_SESSION['id'] .'" />
<input type="submit" name="submitComment" id="submitComment" />
</form>
</div><br />
';
}
?>

I have been looking at it for ages but can think why this is happening.

Thanks in advance for any help

I'm using mcrypt to encrypt a field and decrypt it.  That works OK.  But when I insert the encrypted field into a mySQL table, select it, decrypt it and try to display it, I get garbage.

What am I missing?  Thanks for any suggestions.

Here's the code:


echo "The encrypt and decrypt example...<br/>";

// Designate string to be encrypted
$string = "Ed O'Reilly";

// Encryption/decryption key
$key = "arG4thaker2";

// Encryption Algorithm
$cipher_alg = MCRYPT_RIJNDAEL_128;

// Create the initialization vector for added security.
$iv = mcrypt_create_iv(mcrypt_get_iv_size($cipher_alg, 
MCRYPT_MODE_ECB), MCRYPT_RAND);

// Output original string
print "Original string: $string <p>";

// Encrypt $string
$encrypted_string = mcrypt_encrypt($cipher_alg, $key, 
$string, MCRYPT_MODE_CBC, $iv);

// Convert to hexadecimal and output to browser
print "The encrypted string: ".bin2hex($encrypted_string)."<p>";

$decrypted_string = mcrypt_decrypt($cipher_alg, $key, 
$encrypted_string, MCRYPT_MODE_CBC, $iv);

print "The decrypted string: ".rtrim($decrypted_string)."";

echo "<br/>testing db storing & retrieval for the encryption/decryption...<br/>";

# make connection (Game server connections are variable and are done later when needed)
if (!$cxnAdmin = mysqli_connect($hostAdmin, $userAdmin, $passwordAdmin, $dbnameAdmin))
{
die("Could not connect to MySQL server Admin (".mysqli_connect_error().")");
}

$sql="INSERT INTO testdb.nametable (
name,
email
)
VALUES (
'$encrypted_string',
'test@test.com'
)
;
";

$result = mysqli_query($cxnAdmin,$sql);
if($result == false)
{
echo "<h4>Error on nametable Insert: ".mysqli_error($cxnAdmin)."</h4>";
}

$sql="SELECT name
FROM testdb.nametable
WHERE email='test@test.com'";

if (!$result = mysqli_query($cxnAdmin,$sql))
{
echo "<h4>Error on nametable Select: ".mysqli_error($cxnAdmin)."</h4>";
}

$row = mysqli_fetch_assoc($result);
extract($row);

// Convert to hexadecimal and output to browser
print "The encrypted string from db: ".bin2hex($name)."<p>";

$decrypted_name = mcrypt_decrypt($cipher_alg, $key, 
$name, MCRYPT_MODE_CBC, $iv);

print "The decrypted string from db: ".rtrim($decrypted_name)."";


and here's the output:

The encrypt and decrypt example...
Original string: Ed O'Reilly

The encrypted string: 01bc70f5dc5a7ca204cb45bd2eeb0214

The decrypted string:Ed O'Reilly
testing db storing & retrieval for the encryption/decryption...
The encrypted string from db: 5938f7fc81961d2efc6db64607baf465

The decrypted string from db: <garbage characters I can't display here>

the script succesfuly insert image to the database bt, i cant be able to display it on my pages, any help i will appreciate Attached Files  saveimage.php   1.15KB   2 downloads  images_tbl.php   192bytes   3 downloads

I am querying my database to show the visit statistics for a particular week and it shows the number of visits for the countries, but does not display the country name. I have proved that the MySQL works by going into phpMyAdmin and pasting the query into SQL query tab, replacing the POST with 1, for week 1.   I can't see why it is not displying the country.   Here is the code:

<?php
include('connect_visits.php');
doDB7();

$WVisit_data="SELECT WeekNo15.WNo, WeekNo15.WCom, Countries.Country, Countries.CID, ctryvisits15.CVisits
        FROM ctryvisits15 
        LEFT JOIN Countries
            ON ctryvisits15.country = Countries.CID
        LEFT JOIN WeekNo15
            ON ctryvisits15.WNo = WeekNo15.WNo
        WHERE ctryvisits15.WNo = '{$_POST['WeekNo']}'
        ORDER BY ctryvisits15.CVisits DESC";

$WVisit_data_res = mysqli_query($mysqli, $WVisit_data) or die(mysqli_error($mysqli));
$display_block ="
<table width=\"20%\" cellpadding=\"3\" cellspacing=\"1\" border=\"1\" BGCOLOR=\"white\" >
<tr>
<th>Country</th>
<th>Visits</>
</tr>";
while ($WV_info = mysqli_fetch_array($WVisit_data_res)){
    $Ctry = $WV_info['country'];
    $Visits = $WV_info['CVisits'];
//add to display
$display_block .="
<tr>
<td width=\"10%\" valign=\"top\">".$Ctry."<br/></td>
<td width=\"5%\" valign=\"top\">".$Visits."<br/></td>
";
}
mysqli_free_result($WVisit_data_res);
mysqli_close($mysqli);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--
Design by Free CSS Templates
http://www.freecsstemplates.org
Released for free under a Creative Commons Attribution 2.5 License

Name       : Yosemite  
Description: A two-column, fixed-width design with dark color scheme.
Version    : 1.0
Released   : 20091106

-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="keywords" content="" />
<meta name="description" content="" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>1066 Cards 4U - Stats for country</title>
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
<div id="wrapper">
<div id="menu">
		<ul>
			<li class="current_page_item"><a href="index.php">Home</a></li>
			<li><a href="Links.html">Links</a></li>
			<li><a href="Verse_Menu.html">Verses</a></li>
			<li><a href="Techniques.html">Techniques</a></li>
			<li><a href="blog.php">Blog</a></li>
			<li><a href="Gallery.html">Gallery</a></li>
			<li><a href="contact.html">Contact</a></li>
			<li><a href="AboutUs.html">About Us</a></li>
			<li><a href="stats1.html">Stats</a></li>
		</ul>
</div><!-- end #menu -->
<div id="header">
		<div id="logo">
			<h1><a href="http://www.1066cards4u.co.uk">1066 Cards 4U</a></h1>
</div><!-- end #wrapper -->
</div><!-- end #header -->
<div id="page">
<div id="page-bgtop">
<div id="page-bgbtm">
<div id="content">
<h3>Statistics for Week Commencing <? echo $WkCom; ?> in 2015</h3>

<div id="table">
<?php echo $display_block; ?></div>
</div><!-- end #content -->
</body>
</html>

Can you help please?
Edited by rocky48, 07 January 2015 - 07:33 AM.

hello guys,

i need a help from u. from past 1 week , i am searching for it. may be it is simple query for you .
in my project, i am uploading a file,  for example 5mb of audio file, while uploading i need to display a progress bar along with percentage of  how much it is uploaded to server ( as it works in google chrome browser). i tried several codes by searching in google . No code is working.
i can able to display only loader.gif image not the status bar with percentage.

so pls guys if you have these codes, pls share it .

Hi, im trying to echo some mysql data. What i want to do is under a category show the articles that is for the specific category

have a look at my attachment, the blue is where the categorys titles and below is supposed to show the different articles for the specific category.

Here is my code
Code: [Select]
<div class="NewsCateg">
<div class="NewsCategBG">
<?php 
$query = "SELECT * FROM tblnews_categories WHERE ShortId != 0 ORDER BY `ShortId`";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
{

?>
<div class="quartetin2">
<div id="HomeMoreNewsIMG2"><div id="HomeMoreNewsTitle2"><a href="summary.asp?catid=19167"><?php echo strtoupper($row['Name']);?></a></div></div>
<div id="HomeMoreNewsText">
<?php 
$query2 = "SELECT tblnews.Category, tblnews.Title, tblnews_categories.Id FROM tblnews LEFT JOIN tblnews_categories ON tblnews.Category = tblnews_categories.Id";
$result2 = mysql_query($query2);
while($row2 = mysql_fetch_assoc($result2)) {
?>
<tr>
<td id="HomeLatestNewsDate"><li><?php echo strtoupper($row2['Title']);?></li></td>

</tr>
<?php } ?>



</div>
</div>
<?php } ?>
    </div>
    </div>


Any help please?


Thank you

Hi...

I tried to use foreach in displaying my table header, but I encountered problem when I tried to display data on the first row , my query only display the last Sum for the last Comp.

here is my code:

<html>
<head>
<title>Half Shell</title>
<link rel="stylesheet" type="text/css" href="kanban.css" />
<?php
  error_reporting(E_ALL ^ E_NOTICE);
  date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);


?>

<body>
<form name="param" action="" method="post" onSubmit="return false">

<div id="fieldset_PS">
<?php
   echo "<table>";
   
   $sql = "SELECT DISTINCT s.Comp FROM sales_order s, param_settings p WHERE s.Comp = p.Compounds ORDER BY s.Comp";
   $res_comp = mysql_query($sql, $con); 
   while($row_comp = mysql_fetch_assoc($res_comp)){
        $Comp[] = $row_comp['Comp'];
   }
   echo "<th>&nbsp;</th>";
   foreach($Comp AS $Comp){
    echo "<th>$Comp</th>";
  }   

   echo "<tr>
   <td>Total Kg/Compound</td>";
      $sql_sec = "SELECT SUM(TotalKg) AS TotalKg FROM sales_order  WHERE Comp = '$Comp' ORDER BY Comp";
   $res_sec = mysql_query($sql_sec, $con);
   
   while($row_sec = mysql_fetch_assoc($res_sec)){
       $TotalKg[] = $row_sec['TotalKg'];

   }
   foreach($TotalKg AS $TotalKg){
    echo "<td>$TotalKg</td>
    </tr>";
  }   

   ?>


I also attach the correct output that should be and the result from my code.

Thank you

<INPUT TYPE = "Text" VALUE ="0"
ID = "username2" NAME = "username2">

<?php
$value1 =  $_POST['username2'];
$nine=$value1;

$codx =$characters[$nine]->name;
?>

Im tring to get '0' in username2 inputbox

readit in php $nine

$codx =$characters[$nine]->name;

as you can see in my <?php code above
I cant get the 0 from this inputbox

It only works like this

<?php
$nine='0'
$codx =$characters[$nine]->name;
?>

What i need is to get the users
input. from a textbox on my page
called username2
they would enter between 0 and 8
as you can see its set to 0 on my
textbox, the 0 - 8 is the
character location
$characters[$nine]

the $nine will hold the number
between 0 - 8
My php code i cant read my texbox
input.

How do I read the user input
into my

my textbox post pulls the input

$nine =  $_POST['username2'];
$codx =$characters[$nine]->name;

i noticed it wouldn't work

it only works this way

$nine='0';
$codx =$characters[$nine]->name;

Let me know how to read in user input
from my username2 textbox.
Thanks in advance

sorry to repeat i needed to explain
so you can see my error.

Edited December 30, 2019 by Psycho
none

Hi all

i have been trying for 6 hours to write some code that will show a text box and the user puts in there id then it provides a link with the id in the middle of it

so say the id is 111555

the link is http://example.com.au/data/users/111555/2011/1/1 i want the user to insert their id and do if the id 343034 the link is
http://example.com.au/data/users/343034/2011/1/1

can any one give me the code to this i have gotten no where
from tutorials
               
please matt                                       

I am currently writing a script, well, attempting to write a script where the user is able to add an unlimited amount of text boxes via javascript:

Code: [Select]
var i = 1;

function AddTxtBox() {

new_textbox.innerHTML = new_textbox.innerHTML +"<br />Misc Item " + i + ": <input type='text' name='prod_misc[]' placeholder='Misc Product Info' />"
i++;
}

The js code works fine adding the text boxes. My first question is: in the "name" field; the name I have is "prod_misc[]" is that correct for adding the input into an array?

Second question:

I want to input that data from the "prod_misc[]" array into SQL, namely PostgreSQL. Should I use a "for()" loop to extract each key of data from the array "prod_misc[]"? If so, what syntax do I use to input an array of data like that into SQL?


Thanks so much in advance for this help... I am in great need and it's very appreciative.

I would appreciate if someone could figure this out or tell me the easiest way to do this. I need a count up counter that appears in a textbox so I can record the time a user is on a page. On a side note, I do have their Start and finish time timestamp recorded in myphpadmin database but I am looking for the easiest (or best) way to do this. Any advice or scripts would be very much appreciated.   Thanks in advanced.   I did find this counter that works but the numbers appear 0.0.1 if counting up. I don't want to confuse the user. I really want to display to the user how long they was on a certain page.

<script>
  $(document).ready(function() {
    var time = '00:00:00',
        parts = time.split(':'),
        hours = +parts[0],
        minutes = +parts[1],
        seconds = +parts[02],
        input = $('#timeInput');
 
    var timer = setInterval(function(){
        seconds++;
        if(seconds == 60) {
            seconds = 00;
            minutes++;
 
            if(minutes == 60) {
                minutes = 00;
                hours++;
            }
        }
        var newTime = hours + ":" + minutes + ":" + seconds;
        $('#timeInput').val(newTime);
    }, 1000);
 
});
</script>
 
<input type="text" name="time" id="timeInput"/>

I have a problem where I am unable to display a DB entry that for exampe says "John Doe".

The code I am using is:

Code: [Select]
<tr>
<td>Agent Full Name:</td>
<td><input type="text" name="fullname" value='.$agentdata['fullname'].'></td>
</tr>
The output shows "John" instead of "John Doe", have I missed something here 

Like Youtube; when submitting a video; You can insert words into a Textbox named Tags.

Each space you leave is considered the start of a new word.

How can I do this using PHP + MYSQL.

Thanks!

Hi,

I would like to know how to get The Value Of An Hidden TextBox From an External Website than Mine.

I'm Coding an Addons for CCBChurch.com (mychurch.ccbchurch.com/app/trx_submit_bp.php),

This is a donation website, They want me to code an addons so people can place it on their website and people can donate.

I made it in cURL with POST but they generate a TimeStamp and a TimeStamp encoded, The 2 are on mychurch.ccbchurch.com/app/trx_submit_bp.php on hidden textbox.

I would like to get the TS and TSH from the hidden textbox on the website, Is that possible ?

I would too like to put it in Variable $ts and $tsh...

Thanks !