PHP - Dynamic/ Live Text Via Php Mysql And Refresh Without Reload

Folks,

I need help (Php code ) to generate a Dynamic Text on a Base Image. What i want to do is, to make this Image as header on my Site and to make this Header Specific to a Site, i want to Add the Domain Name on the Lower Left of the Image.

Got the Idea?

Here is the Image link:

Quote

http://img27.imageshack.us/i/shoppingheader1.jpg/


PHP Variable that holds the Domain name is:  $domain 

All i need the Dynamic PHP Codes that i can put on all my sites to generate this Text on Image (Header) Dynamically...

May Anyone Help me with this Please?

Cheers
Natasha T.

Hi

So I have successfully set up a website and database where a user can create a listing and view listings on a listing details page. The viewing can only be done, however, only from either from either running a search query from the search form or from clicking one of the listings from the listing table. The listings are not being indexed from the search engines from the direct page, instead from the listing table which is about 3,000 listings, not very user friendly to land on this page and have to go through the table or use the table filter.  Here's what I am trying to accomplish:

A web page that has a dynamic presence / URL like a Wordpress page: http://www.mysite.com/listing_title/ The title of the page has the listing information in it: This page is about a $listing_title $listing_item listing number $listing_number that is online! Each individual Listing / page is indexed on the search engines and has a direct link to it
I am familiar with PHP and have created this site but I am far from an expert! Please give me a code example or link to one because if you just say "do this to this and that" you will totally loose me.
Thank you so much for any help.

So I'm trying to put a user selected date into a mysql query, but it seems like no matter what I do I get 0 results even though I already know there's quite a few. The way I have it now 'echo $query;' puts out the expected results, but I'm guessing it's because I'm trying to match a date to a string.  I tried strtotime but I'm not sure if I was doing it right.. I also tried sprintf() just in case, but that doesn't seem to have a date feature.  The variable $realdate is just to show how I was attempting to use strtotime, it's not an actualy part of the script at this time...



$searchdate = $_GET['searchdate'];
//$realdate = strtotime($searchdate)


//connects to db
dbconnect();


$query="SELECT `name`, `date`, SUM(`amount`) as `total_money`, SUM(`bricks`) as `total_bricks` FROM Aces_Donations WHERE `date`= $searchdate ORDER BY `total_money`";

echo $query;

$result=mysql_query($query); 

//Opens the table
echo "<table border = '3' width = 40% bgcolor=#A85045><caption><center>Rankings - ".$searchdate.'</center></caption>';

//Loop to run until eof

while($row = mysql_fetch_array($result)){

echo "<tr><td>".$rank."</td> <td>".$row['name']. "</td><td>". $row['total_money']."</td><td>".$row['total_bricks'].'</td></tr>';
$rank++;

}
echo '</table>';

Hello all.

I have an ID Messaging system where the user puts in the ID of the user they want to contact and it sends a message to their Inbox - Great.

What I need is a feature where the user puts in the ID and onblur another textbox populates with the users Name from the MySQL Database without having to reload the page so they know they have the right person.

I am pretty new to this so have no idea where to start with this population feature.  Here's my form code.  Hope someone can help.

<table width="450" border="0">
        <tr>
          <td> <form name="messages" method="post" action="inbox_messages_send.php" onsubmit="return checkform(this);">
              <table width="411" height="227" border="0">
           <tr>
                  <td align="right" bgcolor="#EAEAEA"><font size="2" face="Arial, Helvetica, sans-serif">From:</font></td>
                  <td bgcolor="#EAEAEA"><input type="hidden" name="sentBy" size="3" maxlength="3" align="absmiddle" value="<?php echo $_SESSION['member_ID']; ?>">
              <input type="hidden" name="fname" value="<?php print email('name'); ?>"><input type="hidden" name="lname" value="<?php print email('lname'); ?>">
                    <font size="1" face="Arial, Helvetica, sans-serif">(Your ID
                    is automatically attached)</font></td>
                </tr>
                <tr>
                  <td align="right" bgcolor="#EAEAEA"><font size="2" face="Arial, Helvetica, sans-serif">To:</font></td>
                  <td bgcolor="#EAEAEA"><input type="text" name="L_ID" size="3" maxlength="3" align="absmiddle">
                    <font size="1" face="Arial, Helvetica, sans-serif">(Member's
                    ID)</font></td>
                </tr>
            <tr>
                  <td align="right" bgcolor="#EAEAEA"><font size="2" face="Arial, Helvetica, sans-serif">Subject:</font></td>
                  <td bgcolor="#EAEAEA"><input type="text" name="subject"></td>
                </tr>
                <tr>
                  <td align="right" bgcolor="#EAEAEA"><font size="2" face="Arial, Helvetica, sans-serif">Message:</font></td>
                  <td bgcolor="#EAEAEA"><textarea cols="35" rows="5" name="email_message"></textarea></td>
                </tr>
               
            <tr>
                  <td align="right">&nbsp;</td>
                  <td><input type="submit" name="message" value="Send Message"></td>
                </tr>
              </table>
            </form></td>
        </tr>
      </table>

Hi there,   I have a table in a MySQL database where I keep a list of user privileges. I am trying to create variables where the name of variable matches the privileges in the table.   This is also known as variable variables (I think).   EDIT (17/07/2014 04:02 PM): This might be a better way to describe what I'd like, so if the value from the table is admin_panel I'd like to dynamically create a variable with that name.   I have created a code so far, but all I seem to be getting is a list of Notice errors telling me that the variable is undefined. (I have supplied a list of errors a bit further down the post).   Here is the code:

<?php
$host = "localhost";
$account = "***";
$password = "****";
$dbname = "****";

$connect = mysql_connect($host,$account,$password) or die("Unable To Connect");
$db = mysql_select_db($dbname,$connect) or die("Unable To Select DB");

$perm_query = "SELECT * FROM `privileges`";
$permission_query = mysql_query($perm_query);

while($row = mysql_fetch_array($permission_query))
{
$rows[] = $row;
}

foreach($rows as $row)
{
${$row['privilege']};
}
?>

The list of errors:   Notice: Undefined variable: admin_panel in C:\xampp\htdocs\DynamicVariables.php on line 20
Notice: Undefined variable: create_user in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: edit_user in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: delete_user in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: create_group in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: edit_group in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: delete_group in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: view_log in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: log_settings in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: password_change in C:\xampp\htdocs\DynamicVariables.php on line 20   Thanks
Edited by chrisrulez001, 17 July 2014 - 10:05 AM.

The page that I'm currently working on has a form which allows, through a series of check boxes and text entry fields, a dynamic mysql query to be created. The php code constructs the query based on which fields the user updated in order to find a specific user in the database. Everything was working fine until I started to only display part of the result set. In order to display a message similar to "Displaying 12-25 of 65 results." I ran the query twice. Once to get the total number of results, and once to only get the specified set.

The code for the section producing the error is included below. The elseif statement works as desired, as does the initial query of the if statement.
if (isset($sql) && $sql !=""){
$sql = "SELECT DISTINCT users.StudentID FROM users lEFT JOIN events ON users.StudentID=events.StudentID WHERE" . $sql;
$stmt = $mysqli->prepare($sql);
call_user_func_array(array(&$stmt, 'bind_param'), $array_of_params);
$stmt->execute();
$stmt->store_result();
$total= $stmt->num_rows;
$stmt->close();
$sql = "SELECT DISTINCT users.StudentID,users.FirstName,users.LastName,users.Email,users.Phone,users.Texting,users.Admin,users.HDHS,users.Sex,users.Confirmation FROM users lEFT JOIN events ON users.StudentID=events.StudentID WHERE" . $sql . " ORDER BY LastName,FirstName LIMIT " . $_GET['start'] . ",12";
$stmt = $mysqli->prepare($sql);
call_user_func_array(array(&$stmt, 'bind_param'), $array_of_params);
$stmt->bind_result($row['StudentID'],$row['FirstName'],$row['LastName'],$row['Email'],$row['Phone'],$row['Texting'],$row['Admin'],$row['HDHS'],$row['Gender'],$row['Confirmation']);

}
elseif(isset($_GET['submit']) || isset($_GET['earlier']) || isset($_GET['later'])){
$stmt = $mysqli->prepare("SELECT StudentID,FirstName,LastName,Email,Phone,Texting,Admin,HDHS,Sex,Confirmation FROM users ORDER BY LastName,FirstName");
$stmt->bind_result($row['StudentID'],$row['FirstName'],$row['LastName'],$row['Email'],$row['Phone'],$row['Texting'],$row['Admin'],$row['HDHS'],$row['Gender'],$row['Confirmation']);
$stmt->execute();
$stmt->store_result();
$total= $stmt->num_rows;
$stmt = $mysqli->prepare("SELECT StudentID,FirstName,LastName,Email,Phone,Texting,Admin,HDHS,Sex,Confirmation FROM users ORDER BY LastName,FirstName LIMIT " . $_GET['start'] . ",12");
$stmt->bind_result($row['StudentID'],$row['FirstName'],$row['LastName'],$row['Email'],$row['Phone'],$row['Texting'],$row['Admin'],$row['HDHS'],$row['Gender'],$row['Confirmation']);
$stmt->execute();
}


If anyone would be willing to help me out here it would be greatly appreciated. If you need more information let me know. Thank you!

Dear Support,

Here is my code:

<?php 
    if ( strtolower($_SERVER['REQUEST_METHOD']) === 'post' ) {
        $name = isset($_POST['name]) ? htmlspecialchars($_POST['name']) : "";
$area = isset($_POST['area']) ? htmlspecialchars($_POST['area']) : "";
                $choice = isset($_POST['choice ']) ? htmlspecialchars($_POST['choice ']) : "";

          //Do Others  
          }
?> 

<form class="customersForm" method="post">
        <div class="">
  <p>Name<br />
       <select style="width:120px;" name="name">
          <?php
                               $sql = "select * from `name_info` order by `name`";
                               $query = mysql_query($sql);
                       $dd = '<option>Name</option>';  
                               while($row = mysql_fetch_object($query)) {
                                    $dd .= '<option>'.$row->name.'</option>';
                               }
               echo $dd;              
          ?>
      </select>
     </p>
  </div>

             <div class="">
  <p>Area<br />
       <select style="width:120px;" area="area">
          <?php
                               $sql = "select * from `area_info` order by `area`";
                               $query = mysql_query($sql);
                       $dd = '<option>Area</option>';  
                               while($row = mysql_fetch_object($query)) {
                                    $dd .= '<option>'.$row->area.'</option>';
                               }
               echo $dd;              
          ?>
      </select>
     </p>
  </div>


            <div class="">
  <p>Choice<br />
       <select style="width:120px;" choice="choice">
          <?php
                               $sql = "select * from `choice_info` where `name`='".$name."' and `area`='".$area."' order by `choice`";
                               $query = mysql_query($sql);
                       $dd = '<option>Choice</option>';  
                               while($row = mysql_fetch_object($query)) {
                                    $dd .= '<option>'.$row->choice.'</option>';
                               }
               echo $dd;              
          ?>
      </select>
     </p>
  </div>

......//Others input fields ...some text fields ...

</ form>


I have the above code, where I would like to show the choice Drop-down box, depends on $name and $area match of the choice_info table. $name field and $area field needs to have any dependency and straight from the MySQL table. But, choice needs to depend on $name & $area. How can I do it without much using Javacript? I do not mind to use JavaScript, but prefer to minimal.

By the way, I will have some other input fields too. It's an input form but, one drop-down box will be depends on two others choice.

Thanks for your help.

I'm using some code to create a select menu of a fieldname of data  I have in a mysql database :
Code: [Select]
<?php
mysql_connect('localhost' , 'dbname', 'password');
mysql_select_db('dbname');
$result=mysql_query("SELECT * FROM Persons");
if(mysql_num_rows($result)>0)
{
?>
<select name="Persons">
<?php
while($rows=mysql_fetch_array($result)){
?>
<option value="<?php echo $rows['id']; ?>"> <?php echo $rows['FirstName']; ?></option>
<?php
}
?>
</select>

What I would like to do is to elevate this into a jump menu form so that if the user selects an item from my form they are taken to a results page showing the full row of data from the database. Basically a search form containing items from the database they can choose to see more details on.

eg. In my example you select a persons name and then you are taken to a results page which displays the details of that person from the database.

Problem is I don't know how to do this and have been trawling around for a couple of days to find a solution (sorry I'm new to php). I would appreciate some help or a working example would be great of :

1/ A working dynamic jump menu
2/ The page that would process the form
3/ The results page displaying the data I have selected.


Thank you for your time...

im making a game and i need to show a users money but i dont know how help?

Hi All,

i am trying to Generate a image dynamically.
Up to here i am able to do it .
But when i give any echo statement with this its not working..
Here is my code pls help me in this

<?php
// Create a 55x30 image
$im = imagecreatetruecolor(79, 79);
$unknow = imagecolorallocate($im, 0, 255, 255);
$white = imagecolorallocate($im, 255, 255, 255);

// Draw a white rectangle
imagefilledrectangle($im, 4, 4, 75, 25, $unknow);
imagefilledrectangle($im, 4, 29, 75, 50, $unknow);
imagefilledrectangle($im, 4, 54, 75, 75, $unknow);

// Save the image

echo 'hi hello';
header("Content-type: image/png");
//imagepng($im, './imagefilledrectangle.png');
imagepng($im);

imagedestroy($im);
?>


Thanks in advance.

Hi guys.. 1st post here.  I'm pretty new to php.. just a few weeks in.  I've gotten pretty decent at making mysql connections and extracting data, but now I'm wanting to take one of my urls that I echo to my page and create a new page.  Hoping someone can help...  Here's the pictu

MY MySQL Setup:
I have 1 table called table1. It has 2 columns which a 'Title' & 'Description'

My Index.php Page:
I connect to mysql. I pull the 'Title' from MySQL and loop it to produce 100 rows of data that fill my index page, as expected.

My Problem:
I now want to be able to click one of those rows and dynamically create a new page (description.php) that includes the 'Title' & 'Description'.

My Progress:
I've managed to click a row and create a hyperlink to mysite.com/$title (where 'title' is pulling the 'title' from the mysql db) but I all I get is page not found.

My Question:
How do I tell description.php to pull the 'Title' and 'Description' and link to it from index.php?

My Gratitude:
Thanks in advance!

In brief, I'm attempting to capture the form data from a dynamic form to a mysql database.

From he

To He

The post data looks like this from the form -
DATA SUBMITTED:

Array(

...
[petlist] => [{"Pet Name":"Hal","Pet Type":"Dog","Breed":"Lab","DOB":"02/10/2013","Gender":"Male","Special Needs":"No"},
{"Pet Name":"Bill","Pet Type":"Dog","Breed":"Golden","DOB":"03/20/2015","Gender":"Male","Special Needs":"No"}]
...

)

PHP CODE:

...
$_POST['petlist'];
...

As a non-php or mysql developer, I'm learning on the fly.  This is a section of the php file that I was using to post the form data to mySQL.  This worked great up to the point I added the dynamic form widget.

<?php
// This function will run within each post array including multi-dimensional arrays
function ExtendedAddslash(&$params)
{
        foreach ($params as &$var) {
            // check if $var is an array. If yes, it will start another ExtendedAddslash() function to loop to each key inside.
            is_array($var) ? ExtendedAddslash($var) : $var=addslashes($var);
            unset($var);
        }
}

// Initialize ExtendedAddslash() function for every $_POST variable
ExtendedAddslash($_POST);     

$submission_id = $_POST['submission_id'];
$formID =$_POST['formID'];
$ip =$_POST['ip'];
$fname =$_POST['fname'];
$lname =$_POST['lname'];
$spousename =$_POST['spousename'];
$address =$_POST['address'][0]." ".$_POST['address'][1]." ".$_POST['address'][2]." ".$_POST['address'][3]." ".$_POST['address'][4]." ".$_POST['address'][5];
... 

$db_host = 'localhost';
$db_username = 'xxxxx';
$db_password = 'xxxxx';
$db_name = 'xxxxx';

mysql_connect( $db_host, $db_username, $db_password) or die(mysql_error());
mysql_select_db($db_name);

// search submission ID

$query = "SELECT * FROM `tableName` WHERE `submission_id` = '$submission_id'";
$sqlsearch = mysql_query($query);
$resultcount = mysql_numrows($sqlsearch);

if ($resultcount > 0) {
 
    mysql_query("UPDATE `tableName` SET
                                `fname` = '$fname',
                                `lname` = '$lname',
                                `spousename` = '$spousename',
                                `address` = '$address',
                                 
                                 WHERE `submission_id` = '$submission_id'")
     or die(mysql_error());
   
} else {

    mysql_query("INSERT INTO `tableName` (submission_id, formID, IP, fname, lname, spousename, address)
                               VALUES ('$submission_id', '$formID', '$ip', '$fname', '$lname', '$spousename', '$address') ")
    or die(mysql_error()); 

}
?>

It has been suggested that I explore using the PHP Explode() function.  It's possible that may work, but can't get my head around how to apply the function to the PETLIST Array.

Looking for suggestions or direction to find a solution for this challenge.  Looking forward to any replies.

I can not get the values from the javascript add row to go dynamically as a row into MySql only the form values show up as the form below as one row. I made it as an array, but no such luck, I have tried this code around a multitude of ways. I don't know what I am doing wrong, kindly write out the correct way.      <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR...ransitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml">
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 <title>Dynamic Fields js/php to MySql need to submit dynamically to the database</title>
 <?php
 require ('database.php');
 ?>
  <script type="text/javascript">
  var counter     =     1;
  var collector     =     "";
 
  function addfields(indx)
  {
   var tbl = document.getElementById('table_id');
   var newtr = document.createElement('tr');
   counter = counter + indx;
 
   newtr.setAttribute('id','tr'+counter);
 
   newtr.innerHTML = '<td><input type="checkbox" name="checkb'+counter+'" id="checkb'+counter+'" value="'+counter+'" onclick="checkme('+counter+')"></td><td><input type="text" name="text1[]"></td><td><textarea name="textarea1[]"></textarea></td>';
 
   tbl.appendChild(newtr);
  }
 
  function checkme(dx)
 {
    collector += dx+",";
 }
 
  function deletetherow(indx)
  {
   var col = collector.split(",");
 
   for (var i = 0; i < col.length; i++)
   {
    var remvelem = document.getElementById('tr'+col[i]);
    var chckbx = document.getElementById("checkb"+col[i]);
    if(remvelem && chckbx.checked)
    {
     var tbl = document.getElementById('table_id');
    tbl.removeChild(remvelem);
   }
   }
  }
 </script>
 </head>
 <body>
 <form enctype="multipart/form-data" id="1" style="background-color:#ffffff;" action="<?php echo $_SERVER['PHP_SELF']; ?>"></form>
 <table id="table_id" >
   <tr id="tr1" class="trmain">
   <td>
   </td>
    <td>
    <input type="text" name="text1[]">
  </td>
    <td>
   <textarea name="textarea1[]"></textarea>
     </td> 
   </tr>
  </table>
 <input type="button" value="Add" onClick="addfields(1);" />&nbsp;
 <input type="button" value="Delete" onClick="deletetherow()" />
 <input type="submit" value="Send" id="submit"  name="submit"/>
 
 <?php
 if(isset($_POST['submit'])) {
 for ($i=0; $i < count($_POST['text1']); $i++ )
 {
 $ced = stripslashes($_POST['text1'][$i]);
 $erg = stripslashes($_POST['textarea1'][$i]);
 }
 
 
 $bnt = mysql_query("INSERT INTO tablename (first, second) VALUES ('$ced', '$erg')")or die('Error: '. mysql_error() );
 $result = mysql_query($bnt);
 }
 
 ?>
 
 </body>
 </html>

Hello,

I'm working on a dynamic text form (I guess thats what its called). Basically, I have a html page that echos in some PHP code. What the PHP code does is show different strings of text depending on a variable:

Code: [Select]
<PHP?
$brief1_info = "brief info goes here";
$brief1 = 0;

if (isset($_POST['brief1Go'])) {
$brief1 = $brief1 + 1;
}
else if (isset($_POST['brief1Back'])) {
$brief1 = $brief1 - 1;
}


$breif1Controller = "
<form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">
<input type=\"submit\" name=\"brief1Back\" id=\"brief1Back\" value=\"BACK\" />
</form>

<form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">
<input type=\"submit\" name=\"brief1Go\" id=\"brief1Go\" value=\"CONTINUE\" />
</form>";



if($brief1 == 0){
$brief1_info = "<b>Welcome Commander,</b> you are currently viewing the Mission Control Brief page, here you can view all your missions that you need to complete in order to advance through your prestiges. You will need to follow your briefs carefully in order to succeed. <br /><br />

";
}
else if($brief1 == 1){
$brief1_info = "Okay, let me show you around the place ...";
}
else if($brief1 == 2){
$brief1_info = "brief is on 2";
}


?>
The problem is, the BACK and CONTINUE buttons don't work. If $brief1 equals 0, and the user presses continue, the is should go to 1, and the brief1_info string is changed (so some different text shows in my html). It actually works when brief1 is on '0', but when its on 1 and the user pressed continue, the brief1 is changed to 1, but because the submit button refreshes the page, the variable is re-read again, and thus is reset back to 0.

Is there a way around this? Or is there a better method than what I'm doing?

Thanks