PHP - Onblur To Mysql Dynamic Validation

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...

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.

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!

I am not very advanced in web programming  I need help..    I am using an API and my sql database. I would to implement live/ dynamic updates in the text field where user will input their text, and the web should first check the database then the api live. I would also like to retrieve the user input without refreshing the page, so the retrieved information regarding the inputted text should be automatically loaded without refreshing the page.   please help .

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>

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.

Hi, I'm trying to make a dynamic html table to contain the mysql data that is generated via php. I'm trying to display a user's friends in a table of two columns and however many rows, but can't seem to figure out what is needed to make this work.

Here's my code as it stands:
Code: [Select]
<?php
//Begin mysql query
$sql = "SELECT * FROM friends WHERE username = '{$_GET['username']}' AND status = 'Active' ORDER BY friends_with ASC";
$result = mysql_query($sql);
$count = mysql_num_rows($result);

$sql_2 = "SELECT * FROM friends WHERE friends_with = '{$_GET['username']}' AND status = 'Active' ORDER BY username ASC";
$result_2 = mysql_query($sql_2);
$count_2 = mysql_num_rows($result_2);

while ($row = mysql_fetch_array($result)) {
                                                          echo $row["friendswith"] . "<br>";
                                                }
while ($row_2 = mysql_fetch_array($result_2)) {
                                                          echo $row_2["username"] . "<br>";
                                                }
?>

The above simply outputs all records of a user's friends (their usernames) in alphabetical order. The question of how I'd generate a new row each time a certain amount of columns have been met, however, is beyond me. Anyone know of any helpful resources that may solve my problem? Thanks in advance =)

I'm trying to use js function to: upon entering "paidamt" change the "amtdue",
"prevbal",auto-insert the current date(datepaid), change"pd", and increment
the "checkno". I had this working at one time but memory precludes the use of the
onblur. The following code displays all values for selected record from database
and only updates "paidamt". Any help?
 

echo "<tr>
<td><input type='text' readonly size=15 name='acctno' value='" . $row['acctno'] . "' ></td>
<td><input type='text' readonly size=25 name='bname' value='" . $row['bname'] . "'></td>
<td><input type='text' readonly size=25 name='purpose' value='" . $row['purpose'] . "'></td>
<td><input type='text' size=7 id='paidamt' name='paidamt' value='" . $row['paidamt'] ."'
onBlur='calculate_paid(this)'></td>
<td><input type='text' size=5 name='amtdue' value='" . $row['amtdue'] . "' ></td>
<td><input type='text' size=5 name='prevbal' value='" . $row['prevbal'] . "' ></td>
<td><input type='text' size=5 name='datepaid' value='" . $row['datepaid'] . "' ></td>
<td><input type='text' size=5 name='pd' value='" . $row['pd'] . "' ></td>
<td><input type='text' size=5 name='checkno' value='" . $row['checkno'] . "' ></td>
</tr>";

function $_(IDS) { return document.getElementById(IDS); }
function calculate_paid()
  {
   var recur = parseInt(document.getElementById("recur").value;
   var pd = parseInt(document.getElementById("pd").value;   
   var shipamt = parseFloat(document.getElementById("shipamt").value;
   var paidamt = parseFloat(document.getElementById("paidamt").value;
   var prevbal = parseFloat(document.getElementById("prevbal").value;
   var amtdue = parseFloat(document.getElementById("amtdue").value;
   var checkno = parseInt(document.getElementById("checkno").value;
   var datepaid = parseFloat(document.getElementById("datepaid").value;
   var dateNow = new Date();
   var dayNow = dateNow.getDate();
   var datePaid = (dateNow.getMonth()+1)+"/"+dateNow.getDate()+"/"+dateNow.getFullYear();
      datepaid.value = datePaid;
prevbal.value = parseFloat(amtdue.value) + parseFloat(shipamt.value) - parseFloat(paidamt.value);
amtdue.value = parseFloat(amtdue.value) + parseFloat(shipamt.value) - parseFloat(paidamt.value);
checkno.value = parseInt(checkno.value) + "1";
   if(recur.value=="N")
      {prevbal.value= amtdue.value;}
   if(prevbal.value=="0.00")
      {pd="P";}
   if(amtdue.value=="0.00")
      {pd="P";}

 

Hi,

I have a website where users can log on and edit their profile pic, name, biography etc.
I was wondering about the correct way to:-
Add data to the database through forms (Register.php) Display the data on a page Using mysql escape sting, however, the way I am currently using will display a '\' before any ' symbol. So it's >> it\'s ...

Here is a snippet of the code I am using...

Code: [Select]
//insert data
$about1 = mysql_real_escape_string($_POST['about']);

//get
$query = mysql_query("SELECT * FROM `staff` WHERE username='$username'");
$row = mysql_fetch_array($query);
$about = $row['about'];
echo $about;

Hey guys, I'm new here so hello... but I'll get right to the point:

I have a table named POSTS, where I store user posts. In this table, I have a row named "Popularity". Now I would like the value of "Popularity" to be a function of the number of Likes, Dislikes, Views and Date posted, all of which are stored in respective tables (linked by Primary and Secondary keys).

I was wondering if it actually is possible to have the value of "Popularity" adjust automatically when a change in "Likes", "Dislikes" or "Views" occurs. And if not, what alternatives I have.

The ultimate reason I need to have this value stored in a table and up to date is that I wish to sort posts by "Popularity".

Many thanks !!!

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 all

I need to combine these two scripts:

Firstly, the following decides which out of the following list is selected based on its value in the mySQL table:

<select name="pack_choice">
<option value="Meters / Pack"<?php echo (($result['pack_choice']=="Meters / Pack") ? ' selected="selected"':'') ?>>Meters / Pack (m2)</option>
<option value="m3"<?php echo (($result['pack_choice']=="m3") ? ' selected="selected"':'') ?>>Meters / Pack (m3)</option>
<option value="Quantity"<?php echo (($result['pack_choice']=="Quantity") ? ' selected="selected"':'') ?>>Quantity</option>
</select>

Although this works OK, I need it also to show dynamic values like this:

select name="category">
<?php
$listCategories=mysql_query("SELECT * FROM `product_categories` ORDER BY id ASC");
while($categoryReturned=mysql_fetch_array($listCategories)) {
echo "<option value=\"".$categoryReturned['name']."\">".$categoryReturned['name']."</option>";
}
?>
</select>

I'm not sure if this is possible?

Many thanks for your help.

Pete

create table mimi (mimiId int(11) not null, mimiBody varchar(255) );
<?php
//connecting to database
include_once ('conn.php');
$sql ="SELECT mimiId, mimiBody FROM mimi";

$result = mysqli_query($conn, $sql );

$mimi = mysqli_fetch_assoc($result);

$mimiId ='<span>No: '.$mimi['mimiId'].'</span>';

$mimiBody ='<p class="leading text-justify">'.$mimi['mimiBody'].'</p>';
?>
//what is next?

i want to download pdf or text document after clicking button or link how to do that