PHP - Empty Entry On Reload Page

Hello,

I am having issues with getting cookies to function how i'd like them to.  My goal is to be able to capture a cookie value from the url if a user comes to my site via something like adwords.  An example URL they could come to is http://www.mysite.com?kw=hello

I am trying to capture the word 'hello' and tie it to that visitor regardless of where they go on the site.  I need to use that value to pass through if they complete a form on my site so that i can track the keyword source.

I have included the following as the first line of code on every page of my site:
Code: [Select]
$kw = $_GET["kw"];
setcookie('kw',$kw);
Then, if i go to this url:  http://www.mysite.com?kw=hello and then later go to a url like this:  http://www.mysite.com/page1.html, i am able to echo out the cookie on page1.html using the following code which is contained in page1.html: 
Code: [Select]
echo $_COOKIE["kw"];
The problem is, if i then refresh page1.html i can no longer echo out the cookie--it disappears.  I need the cookie to stay with the user no matter what page they are on within the site and not matter how many different pages they visit. 

I hope i am explaining myself in a way someone can understand.  Perhaps cookies aren't the best way?  Should i use sessions instead?

Thanks in advance for your help

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=346243.0

Hi All,

I was wondering if there is any way that a PHP page can update itself when a row in a DB is added or updated?

I am trying to get a feed up and running and want it to update when a row is updated/inserted.

Thanks
Matt

Below is my code... it writes to the SQL database but does not show on the HTML page. Any advice?

Code: [Select]
<?php

$query = mysql_query("SELECT * FROM `entries`");
$query = mysql_query("SELECT *, UNIX_TIMESTAMP(`date`) as date FROM `entries` ORDER BY `date` DESC LIMIT");
?>
<table width="100%" cellpadding="0" cellspacing="0" border="0">

<tr>
<td valign="top">
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td valign="top" class="entrysmall" align="right">Posted on: <?php echo date("d/m/y g:i a", $row['date']); ?></td>
</tr>
<tr>
<td valign="top">
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td valign="top" style="padding-right: 10px;"><span class="entrytitle">Name:</span></td>
<td valign="bottom" width="100%"><?php echo htmlspecialchars(stripslashes($row['name'])); ?></td>
</tr>
<tr>
<td valign="top" style="padding-right: 10px;" nowrap="nowrap"><span class="entrytitle">E-Mail:</span></td>
<td valign="bottom" width="100%"><?php 
$email = explode('@',stripslashes($row['email']));
echo $email[0].' *at* '.$email[1];
 ?></td>
</tr>
<td valign="top" style="padding-right: 10px;"><span class="entrytitle">Hometown:</span></td>
<td valign="bottom" width="100%"><?php echo htmlspecialchars(stripslashes($row['hometown'])); ?></td>
<tr>
<td valign="top" style="padding: 5px 10px 0px 0px;" colspan="2"><span class="entrytitle">Message:</span></td>
</tr>
<tr>
<td valign="top" style="padding-right: 10px;" colspan="2"><?php echo smilies(htmlspecialchars(stripslashes($row['message']))); ?></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top" height="10"></td>
</tr>

</table>

Whenever I see a PHP website (and given ftp access) I often struggle to find the entry page.

Most I see don't have index.php in the public_html directory - or that isn't the main entry page.

Htaccess and adding Wordpress, shopping carts etc. also messes around with which file is the entry page.

Is there a quick checklist of what a simpleton should do to find the entry page?

E.g.
(1) Check .htaccess................ etc.

Alright,  wasn't quite sure how to summarize this in the title,  but I want to:

Check if a user status is "active" or not based on the UserName input.

I have a table witch holds:

Code: [Select]
VarChar Username      Var CharPassWord     int Active
 Ted                        TedsPW                1
something like the above(assuming it formatted correctly.

In my php script I will want to input a variable for Username to check for:

inputUN in this example would be "Ted".

$UserNameToCheck = $_GET['inputUN'];

Then I want to check for that UserName in the database,  if it exists,  I want pull the value for the "Active" field for just that UserName and echo it.

Thanks for any help.
 

When there is a duplicate entry in my database, I would like it to go to the another page that indicates the error, rather than the "Error: Duplicate entry 'username' for key 1". It happens if someone is going to join and there is a duplicate entry. I would rather it show one of my customized php pages rather than a black page stating the error.

I've tried to catch the entry with some php code but it bypasses it and continues with the duplicate error.

I would appreciate any direction with this. Thanks!

Hello everybody,   I am new to php, I have a question for you guys. why I've got an empty page.   <?php

Hello, I've tried to get a dynamic table from an external page, and searching for entries in it, so i used a dynamic XLS file using php excel reader. I only exported the file, but i couldn't search for data. Can i get some help please ?

I am using php to upload a file to my server, and at the same time inserting the files name and url into my mysql database.

$sql = "UPDATE uploads SET name = '$name', url='$target_path'";
    $statement = $dbh->prepare($sql); 
    $statement->execute();

This is working, however, when I upload a new file, rather than making a new entry in my database, it just overwrites the first one.

I'm quite new at mysql so was wondering how I would make it add new entrys instead of overwriting the current one?

Man, I'm having a rough week with questions--if you're following at home.  Basically matching a Coach's first and last name to another table, which if matched will yield information about that coach's team. 

Code: [Select]
// or get user by username
$current_user = wp_get_current_user();
$current_first = $current_user->user_firstname;
$current_last = $current_user->user_lastname;
$current_id = $current_user->ID;


echo '<div class="contact_form">';

    echo  $current_first . ' ' . $current_last .' :: ';


$query = "SELECT * FROM schools WHERE coachFirst='".$current_first."' AND coachLast='".$current_last."'";
$result = mysql_query ($query);

if(!$result) {
echo 'There is not a match for your name.';
}
else
{
while($school= mysql_fetch_array($result)) {


echo $school['school'] . ' ' .  $school['id'];

include(ABSPATH ."wp-content/plugins/my-team/form.php");

}




echo '</div>';


echo '<div class="roster">';

include(ABSPATH ."wp-content/plugins/my-team/roster.php");

echo '</div>';
}

What I am looking for is that if any field in a database is empty, the form comes back and puts in the word "empty" into the web page, but not the database.


I got this right now, it shows the first part fine, but the second part it doesn't show the "Empty" comment... I don't understand why... as far as I can tell the code is fine...

Code: [Select]
<?php
            //Nonconformity, Disposition, Comments and Comments & Additional Details
            echo '<div id="box3">';
                if (!empty($row['Nonconformity']) || !empty($row['Disposition']) || !empty($row['Comments']) || !empty($row['CommentsAdditional_Details'])) {
                    echo '<div id="non"><span class="b">Nonconformity:&nbsp;&nbsp;</span><br />' . $row['Nonconformity'] . '</div>';
                    echo '<div id="dis"><span class="b">Disposition:&nbsp;&nbsp;</span><br />' . $row['Disposition'] . '</div>';
                    echo '<div id="comm"><span class="b">Comments:&nbsp;&nbsp;</span><br />' . $row['Comments'] . '</div>';
                    echo '<div id="comma"><span class="b">Comments and/or Additional Details:&nbsp;&nbsp;</span><br />' . $row['CommentsAdditional_Details'] . '</div>';}
                        else
                            if (empty($row['Nonconformity']) || empty($row['Disposition']) || empty($row['Comments']) || empty($row['CommentsAdditional_Details'])) {
                                echo '<div id="non"><span class="b">Nonconformity:&nbsp;&nbsp;</span><br />Empty</div>';
                                echo '<div id="dis"><span class="b">Disposition:&nbsp;&nbsp;<br /></span>Empty</div>';
                                echo '<div id="comm"><span class="b">Comments:&nbsp;&nbsp;<br /></span>Empty</div>';
                                echo '<div id="comma"><span class="b">Comments and/or Additional Details:&nbsp;&nbsp;</span><br />Empty</div>';}
            echo '</div>';
?>

I have a div that displays the contents of a mysql table. When the users adds to the table/presses a button I want it to fade out, reload, and fade back in with the new content there.


The current PHP code is in its own div called 'stream'...
 

<script>

function buttonFunction() {

 v=$("#txtstatus");
  $.post('../action/poststatus.php',{status:v.val()},function(d){
 $('div#stream').fadeOut('slow');
 $('div#stream').load;
 $('div#stream').fadeIn('slow');

  });

}

</script>

This fades out and back in but with nothing new loaded.   Please help. Thanks,  

Hi
is there any way we can prevent suppose <textarea></textarea> when page reload it refresh and set default text
i wanted to know is there any way to prevent certain things not to get refreshed  is there any method in php which prevent to reload  this !


<?php
echo  "<textarea > Enter your favorite quote!</textarea> \n" ;
Code: [Select]
if (isset($_GET['edit']) && $_GET['edit'] == 'textupdate'){
}
<a href= \"{$_SERVER['PHP_SELF']}?page=1&edit=textupdate \" >Click</a>?>