PHP - How To Insert Hidden Data Into Html Table And Extract It Later

Hi guys,
Im making an event booking/reservation site,
I have 5 tables (Malls, Events, Booking, Reservation and Users) which are all connected and doing fine.
I created a function which is this...

function select_all_events_by_mall_id($mall_id)
{

echo "<table id='event_table'>";
echo "<th>Event Name</th>";
echo "<th>Event Location</th>";
echo "<th>Number of Cars</th>";
echo "<th>Description</th>";
echo "<th>Booked</th>";
echo "<th>Reserved</th>";
echo "<th>Reserved Until</th>";
echo "<th>Vacant</th>";
$events_set = select_all_events($mall_id);


while($events = mysql_fetch_array($events_set))
{
echo "<tr>";
echo "<td>" . $events['event_name'] . "</td>";
echo "<td>" . $events['event_location'] . "</td>";
echo "<td>" . $events['number_of_cars'] . "</td>";
echo "<td>" . $events['description'] . "</td>";
// Booked
echo "<td>";
$booked_set = select_all_booking($events['id']);

while($booked = mysql_fetch_array($booked_set))
{

$user_set = select_all_user_booked($booked['users_id']);
while($user = mysql_fetch_array($user_set))
{
echo $user['company'] . ", " . $user['branch'] . "<br />";
}
}

echo "</td>";

// Reserved
echo "<td>";
echo "<ol>";
$reserved_set = select_all_reservation($events['id']);
while($reserved = mysql_fetch_array($reserved_set))
{
if(empty($reserved['events_id']))
{
echo "No Reservation's ";
}
else
{


$reserved_user = select_all_user_reserved($reserved['users_id']);
while($user_set = mysql_fetch_array($reserved_user))
{

echo "<li>" . $user_set['brand'] . ", " . $user_set['branch'] . "</li>";

}

}
}
echo "</ol>";
echo "</td>";

// Expiration Date
echo "<td>";
echo "<ol>";
$reserved_set = select_all_reservation($events['id']);
while($reserved = mysql_fetch_array($reserved_set))
{

$reserved_user = select_all_user_reserved($reserved['users_id']);
while($user_set = mysql_fetch_array($reserved_user))
{

$exp_date = select_all_expiration_date($user_set['id']);
while($date = mysql_fetch_array($exp_date))
{
echo "<li>" . $date['expiration_date'] . "</li>";
}
}


}
echo "</ol>";
echo "</td>";

//Vacant
echo "<td>";
$vacant_set = select_all_booking($events['id']);
$booking_count = mysql_num_rows($vacant_set);
$reserved_count = mysql_num_rows($reserved_set);
$total_count = $booking_count + $reserved_count;
$vacant = $events['number_of_cars'] - $total_count;
if($vacant < 0)
{
echo "This Event is fully booked";
}
else
{
echo $vacant;
}
echo"</td>";


echo "</tr>";
}
echo "</table>";


}

The function starts by receiving an id from picking a mall name from a select tag.
It works fine, it outputs the data on the page like i want it to, but my problem is that i need a way to
add a submit or any button to each generated row that will, when clicked will insert the event id and user id (who clicked it) to my booking/reservation table as a new row.
I tried adding a form inside my function and saving the event id every loop but when i click the submit button i think it doesn't work (or i made a mistake)..
Sorry if my coding sucks, I'm kinda new in php.
Sorry if its kinda confusing my head is spinning right now from thinking this stuff the whole day..
Thanks in advance for any comments and ideas.

HI first timer here so please forgive me if this is in the wrong section.

Anyway, here goes.

I have 2 tables

Table 1
Levels
LevelID
LevelName


Table 2
Members
MemberID
FirstName
LastName
Birthdate
LevelID


I have a form that has the LevelID populated from table 1 with a query.  When I enter all my data and hit submit the data gets written to the members table. However, the LevelID is written as 0 for each and everyone record that I have entered. So the question is what am I missing?

As mentioned I am very new at this so any help would be greatly appreciated. Please see below for my code.

Thanks in advance


<?php
require_once 'dblogin1.php';
$db_server = mysql_connect($db_hostname, $db_username, $db_password);
if (!$db_server) die("Unable to connect to MySQL: " . mysql_error());

mysql_select_db($db_database)
or die("Unable to select database: " . mysql_error());
$sql = "SELECT\n"
    . "levels.LevelID,\n"
    . "levels.LevelName\n"
    . "FROM\n"
    . "levels\n";

   $result = mysql_query($sql) or die(mysql_error());

$options="";

while($row = mysql_fetch_array($result)){
   
 $LevelId=$row["LevelID"];
 $LevelName=$row["LevelName"];
 $options.="<OPTION VALUE=\"$LevelID\">".$LevelName.'</option>';
}
?>
<style type="text/css">
<!--
body p {
   color: #F00;
}
-->
</style>



<table width="500" border="1" align="center" cellpadding="0" cellspacing="1" >
<tr>
<td>
<form name="form1" method="post" action="insert_ac.php">
<table width="100%" border="1" cellspacing="1" cellpadding="3">
<tr>
<td colspan="3"><div align="center">
  <p><strong>Myers Player Registration Form</strong></p>
</div></td>
</tr>
<tr>
<td>First Name</td>
<td><div align="center">:</div></td>
<td><input name="firstname" type="text" id="firstname"></td>
</tr>
<tr>
<td>Last Name</td>
<td><div align="center">:</div></td>
<td><input name="lastname" type="text" id="lastname"></td>
</tr>
<tr>
<td>Birthdate (yyyy-mm-dd)</td>
<td><div align="center">:</div></td>
<td><input name="birthdate" type="text" id="birthdate">
</td>
</tr>

<tr>
<td>Level</td>
<td><div align="center">:</div></td>
<td><select name="LevelID">
      <OPTION VALUE="0">Choose
   <?php echo $options?>



    </select></td>
</tr>
</form>
</td>
</tr>
</table>

This topic has been moved to MySQL Help.

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

Hello guys, im using this code atm and it's working, but the new rows created are put in the end of the table. I want them to stack up from the beginning pushing older rows down. What should i do to make that work?


<?php
$con = mysql_connect("localhost","*****","*******");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("ananaz_se", $con);

$sql="INSERT INTO stuff (adult, namn, url)
VALUES
('$_POST[adult]','$_POST[namn]','$_POST[url]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 row added";

mysql_close($con)
?>

I have tried several attempts and can get data to select and using echo display it, however, I need to take this data and insert it into the database in a separate table.   I have the following which does hafl the job, can I get some pointers on the rest.  I have looked everywhere and not found a solution, at all.


// Selects the data I need
<?php
mysql_connect("PRIVATE INFO","PRIVATE INFO","PRIVATE INFO") or
    die("Could not connect: " . mysql_error());

mysql_select_db("wpdb");

$result = mysql_query("SELECT ID FROM wp_posts

WHERE post_title LIKE '%future%'
AND post_status = 'publish'
OR post_title LIKE '%option%'
AND post_content LIKE '%fundamental%'
AND post_status = 'publish'

   ORDER BY post_date DESC");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{   echo $row['ID'];
   echo "<br />";};

?>



Thought maybe something like the following would work, but am at a loss:
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id, term_order)
       SELECT ID FROM wp_posts

            WHERE post_title LIKE '%future%'
            AND post_status = 'publish'
            OR post_title LIKE '%option%'
            AND post_content LIKE '%fundamental%'
            AND post_status = 'publish'

            ORDER BY post_date DESC

            while ($row = mysql_fetch_array($result, MYSQL_ASSOC))

VALUES
($row['ID'], '25', '0')

Hi guys, im inserting data into the table using drop-down list & multi select list,well it works very well. but i need to make sure i should not insert same StudentID & CourseID twice. here my code for you could anyone tell me pls where should i write code to check existing data?
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


  mysql_select_db("uni", $con)or trigger_error('MySQL error: ' . mysql_error());
$result  = mysql_query("SELECT * FROM student") or trigger_error('MySQL error: ' . mysql_error());


echo '<select name="sid">';

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

    echo '<option value="' . $row['StudentID'] . '">' . $row['StudentName'] . '</option>';
}

echo '</select>';

// ----------------

?>
</div>
<div class="style41" id="Layer7">

<?php
$result  = mysql_query("SELECT * FROM course") or trigger_error('MySQL error: ' . mysql_error());


echo '<select name ="cid[]" multiple="multiple" size="10">';

while($row = mysql_fetch_array($result))
{
    echo '<option value="' . $row['CourseID'] . '">' . $row['CourseName'] . '</option>';
}

echo '</select>';
mysql_close($con);
?>


------------------------------------
<?php

$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
  mysql_select_db("uni", $con)or trigger_error('MySQL error: ' . mysql_error());
   
 if (!empty($_POST['sid']) && !empty($_POST['cid'])) 
{
    $ct = 0;
    $student = $_POST['sid'];
    foreach ($_POST['cid'] as $key => $course)
    {
     $sql = "INSERT INTO take (StudentID, CourseID) VALUES('".mysql_real_escape_string($student)."',
 '".mysql_real_escape_string($course)."')";
     $query = mysql_query($sql) or trigger_error('MySQL error: ' . mysql_error());
     if (mysql_affected_rows() > 0){$ct++;}
     }
    echo $ct . ' rows added.';
 }  

mysql_close($con);

?>

Hi? im just a beginner in php i just want to ask how to insert a data into a table from a dropdown list. I have concatenate the itemid and description to form the dropdown list. But when i viewed my item_table the itemid and description columns are null. can you help me with this..
this is my php code for the dropdown list...
         <?php
         $query = "SELECT CONCAT(itemid,' ', '-',' ', description) AS Item FROM item_table";
         
         $result = mysql_query($query) or die(mysql_error());
         
         $dropdown = "<SELECT CONCAT(itemid,' ' '-',' ', description) AS Item FROM item_table>";

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

         $dropdown .= "\r\n<option value='{$row['Item']}'>{$row['Item']}</option>";

         }
         $dropdown .= "\r\n</select>";

         echo $dropdown;
         ?>

this my code for inserting data into the item_table...

<?php
if(isset($_POST ['submit']))
{
   $itemid = $_POST['itemid'];
   $description = $_POST['description'];
   $datein  = $_POST['datein'];
   $qtyin  = $_POST['qtyin'];
   $unitprice  = $_POST['unitprice'];
   $unit  = $_POST['unit'];
   $category  = $_POST['category'];
   $empid = $_POST['empid'];   
   $message ='';   
   if(($itemid && $description == "")||($itemid && $description == null))
   {
         header("location:IncomingEntry.php?msg=Incorrect");
         exit();
   }
   else
   {
      $link = mysql_connect('localhost', 'root', '') or die(mysql_error());
      $db_selected = mysql_select_db('inventory', $link);
      $message='';      
      $query = "INSERT INTO incoming_table (itemid , description,  datein,  qtyin, unitprice, unit, category, empid) VALUES ('".$itemid."',  '".$description."', '".$datein."',  '".$qtyin."', '".$unitprice."', '".$unit."', '".$category."', '".$empid."')";
      
      if (!mysql_query($query,$link))
      {
        die('Error: ' . mysql_error());
      }
      header("location: IncomingEntry.php?msg=1 record added");   
   }
}
?>

 

I am not sure if the title is correct; I tried my best. I'm a PHP/MySQL beginner and I really need some help. I have a small script that I am using for sending SMS. I recently added a phonebook. The problem with the phonebook right now is that it's available to all users, i.e. they can all update and delete all rows. What I would like to do is make it so that each user can update and delete only their own contacts. I have a table call contacts. Inside that table there is first name, last name, company and phonenumber. How can I accomplish this with PHP & MySQL?

CREATE TABLE IF NOT EXISTS `contacts` (
`contact_id` int(10) NOT NULL AUTO_INCREMENT,
`firstname` varchar(255) NOT NULL,
`lastname` varchar(255) NOT NULL,
`company` varchar(255) NOT NULL,
`cell_no` text NOT NULL,
PRIMARY KEY (`contact_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

CREATE TABLE IF NOT EXISTS `users` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`users_name` varchar(30) NOT NULL,
`uname` varchar(30) NOT NULL,
`u_pass` varchar(60) NOT NULL,
`utype` varchar(30) NOT NULL,
`timezone` varchar(30) NOT NULL,
`uapi_user` varchar(30) NOT NULL,
`uapi_pass` varchar(60) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

<?php
if (isset($_POST['submit'])){
    //form has been submitted1
    $firstname  = trim($_POST['firstname']);
    $lastname   = trim($_POST['lastname']);
    $company    = trim($_POST['company']);
    $cellno = trim($_POST['cell_no']);

    if($firstname == ''){
        echo '<div class="alert alert-danger">First Name is not Valid!</div>';
        exit;
    }elseif($lastname == ''){   
        echo '<div class="alert alert-danger">Last Name is not Valid!</div>';
        exit;
    }elseif($company == ''){    
        echo '<div class="alert alert-danger">Company is not Valid!</div>';
        exit;
    }elseif($cellno == ''){ 
        echo '<div class="alert alert-danger">Cellphone Number is not Valid!</div>';
        exit;

    }else{

        $query = "Select cell_no from contacts where cell_no = '".$cellno."' ";
        $result = mysql_query($query);
        if (!mysql_num_rows($result)) {

        $sql = "INSERT INTO contacts(firstname, lastname, company, cell_no)
                            values('{$firstname}','{$lastname}', '{$company}', '{$cellno}')";
        $result = mysql_query($sql);
        confirm_query($result);

        //echo '<div class="alert alert-success">Successfully added.</div>';
        //exit;
        ?>
                    <script type="text/javascript">
            window.location = "contact_list.php";
        </script>
    <?php
    }
    else{

        echo '<div class="alert alert-danger">Username. already exist!.</div>';
        echo '<p><a href="new_contact.php" class="btn btn-success"> Back </a></p>';
        exit;

    }}

}else{
    $firstname  = "";
    $lastname   = "";
    $company    = "";
    $cellno = "";
}

?>

Hello to all,

I have problem figuring out how to properly display data fetched from MySQL database in a HTML table.

In the below example I am using two while loops, where the second one is nested inside first one, that check two different expressions fetching data from tables found in a MySQL database. The second expression compares the two tables IDs and after their match it displays the email of the account holder in each column in the HTML table.

The main problem is that the 'email' row is displayed properly while its while expression is not nested and alone(meaning the other data is omitted or commented out), but either nested or neighbored to the first while loop, it is displayed horizontally and the other data ('validity', 'valid_from', 'valid_to') is not displayed.'

Can someone help me on this, I guess the problem lies in the while loop?
Here is part of the HTML code:

<thead>
 <tr>
 <th data-column-id="id" data-type="numeric">ID</th>
 <th data-column-id="email">Subscriber's Email</th>
 <th data-column-id="validity">Validity</th>
<th data-column-id="valid_from">Valid From</th>
 <th data-column-id="valid_to">Valid To</th>
</tr>
</thead>

Here is part of the PHP code:

 

    <?php
    while($row = $stmt->fetch(PDO::FETCH_ASSOC))
    {
        echo '
            <tr>
                <td>'.$row["id"].'</td>
        ';
        while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)) {
        echo '
                <td>'.$row1["email"].'</td>
        ';
        }
        if($row["validity"] == 1) {
            echo '<td>'.$row["validity"].' month</td>';
        }else{
            echo '<td>'.$row["validity"].' months</td>';
        }
        echo '  <td>'.$row["valid_from"].'</td>
                <td>'.$row["valid_to"].'</td>
        </tr>';
    }
    ?>

P.S. Please know that I have purposely omitted the connection part and the methods in the class that are used in this code to keep the spot of the problem as clean as possible. If you need me to rephrase the question, please ask.

Thank you.

Hi all!!! I could really use some help. I'm burning my brain out trying to figure out the easiest way to go about this.
Here is what I am trying to do (in a nutshell) so I could really use full coding examples.

I need to create a text area with simple formatting tools such as Bold, Italics, Underline, Bullets, and Numbering.
After formatting the text with only those available formatting tools, everything in the text area needs to be converted into html tags.
After the conversion, the HTML data that is create is submitted into a single field into a SQL database.


Any help will be greatly appreciated!!!

 

I can t seem to get this. I need to extract some data from the following xml file. http://api.twitter.com/1/users/show/seobpo.xml   I just want to get seobpo's tweet count. The data will be used in a wordpress blog.

Thank you

Is it possible to write a php script that would extract data from an external web page. I've been working with php for a few years as a hobby, but I've never seen this done or needed a reason to until now. Thanks in advance for any responses.

I am also trying to extract the "address_components" from the JSON data, but the array index changes if you do not submit an address line for example.

I am trying to get the "sublocality" and "administrative_area_level_1" from the "address_components" below.

The API sample is as follows:

{
   "results" : [
      {
         "access_points" : [],
         "address_components" : [
            {
               "long_name" : "10",
               "short_name" : "10",
               "types" : [ "street_number" ]
            },
            {
               "long_name" : "Gillespie Street",
               "short_name" : "Gillespie St",
               "types" : [ "route" ]
            },
            {
               "long_name" : "South Beach",
               "short_name" : "South Beach",
               "types" : [ "political", "sublocality", "sublocality_level_1" ]
            },
            {
               "long_name" : "Durban",
               "short_name" : "Durban",
               "types" : [ "locality", "political" ]
            },
            {
               "long_name" : "Durban Metro",
               "short_name" : "Durban Metro",
               "types" : [ "administrative_area_level_2", "political" ]
            },
            {
               "long_name" : "KwaZulu-Natal",
               "short_name" : "KZN",
               "types" : [ "administrative_area_level_1", "political" ]
            },
            {
               "long_name" : "South Africa",
               "short_name" : "ZA",
               "types" : [ "country", "political" ]
            },
            {
               "long_name" : "4001",
               "short_name" : "4001",
               "types" : [ "postal_code" ]
            }
         ],
         "formatted_address" : "10 Gillespie St, South Beach, Durban, 4001, South Africa",
         "geometry" : {
            "location" : {
               "lat" : -29.859728,
               "lng" : 31.039773
            },
            "location_type" : "ROOFTOP",
            "viewport" : {
               "northeast" : {
                  "lat" : -29.8583790197085,
                  "lng" : 31.0411219802915
               },
               "southwest" : {
                  "lat" : -29.8610769802915,
                  "lng" : 31.0384240197085
               }
            }
         },
         "place_id" : "ChIJGRCdW0mo9x4RcIwU_7S1xa8",
         "plus_code" : {
            "compound_code" : "42RQ+4W Durban, South Africa",
            "global_code" : "5G2H42RQ+4W"
         },
         "types" : [ "street_address" ]
      }
   ],
   "status" : "OK"
}

If you submit a full address to the API, you can use the hard coded index like below: [7]

$json_a['results'][0]['address_components'][7]['long_name']

But it is not reliable to hard code the index [7] in this case.

So I tested some sample code from above post, it is working, but in some cases it does not return the "long_name" of the "sublocality" or "administrative_admin_level_1":

/* if no address, then the array index change */
//  $json_a['results'][0]['address_components'][7]['long_name']
$area = array();
foreach ($json_a['results'][0]['address_components'] as $addrObj) {
    foreach($addrObj['types'] as $type) {
         if (substr_count($type, 'sublocality')>0) {
             $area['short_name'] = $addrObj['short_name'];
             $area['long_name'] = $addObj['long_name'];
						  // var_dump($addrObj);
         } 
         if (substr_count($type, 'administrative_area_level_1')>0) {
             $area['short_admin'] = $addrObj['short_name'];
             $area['long_admin'] = $addObj['long_name'];
						  var_dump($addrObj);
         } 
    }
}

In the var_dump() I do get the long_name value though: In this sample it must be "Kwazulu-Natal", but from the code above, it returns a NULL value.

array(3) { ["long_name"]=> string(13) "KwaZulu-Natal" ["short_name"]=> string(3) "KZN" ["types"]=> array(2) { [0]=> string(27) "administrative_area_level_1" [1]=> string(9) "political" } } 

Below is the full script I am trying to get to work. The lon, lng and format name is working 100%, it is just this array index problem.

/*  get google result in JSON*/
$googleString = file_get_contents($googleUrl); // get json content
$json_a = json_decode($googleString, true); //json decoder

// response status will be 'OK', if able to geocode given address 
if($json_a['status']=='OK'){
// get the important data
$lati = isset($json_a['results'][0]['geometry']['location']['lat']) ? $json_a['results'][0]['geometry']['location']['lat'] : "";
$longi = isset($json_a['results'][0]['geometry']['location']['lng']) ? $json_a['results'][0]['geometry']['location']['lng'] : "";
$formatted_address = isset($json_a['results'][0]['formatted_address']) ? $json_a['results'][0]['formatted_address'] : "";

/* if no address, then the array index change */
//  $json_a['results'][0]['address_components'][7]['long_name']
$area = array();
foreach ($json_a['results'][0]['address_components'] as $addrObj) {
    foreach($addrObj['types'] as $type) {
         if (substr_count($type, 'sublocality')>0) {
             $area['short_name'] = $addrObj['short_name'];
             $area['long_name'] = $addObj['long_name'];
						  // var_dump($addrObj);
         } 
         if (substr_count($type, 'administrative_area_level_1')>0) {
             $area['short_admin'] = $addrObj['short_name'];
             $area['long_admin'] = $addObj['long_name'];
						  var_dump($addrObj);
         } 
    }
}

Is there a better way to get the "sublocality" and "administrative_area_level_1" from the array $area array above. Any pointers will be much appreciated.

Hi,

Anybody can help me to extract data from son using php

 

{"location":{"woeid":2293962,"city":"Kasaragod","region":" KL","country":"India","lat":12.5174,"long":74.990662,"timezone_id":"Asia/Kolkata"},"current_observation":{"wind":{"chill":80,"direction":338,"speed":11.81},"atmosphere":{"humidity":70,"visibility":10.0,"pressure":29.8,"rising":0},"astronomy":{"sunrise":"6:54 am","sunset":"6:35 pm"},"condition":{"text":"Clear","code":31,"temperature":80},"pubDate":1549638000},"forecasts":[{"day":"Fri","date":1549564200,"low":76,"high":85,"text":"Sunny","code":32},{"day":"Sat","date":1549650600,"low":76,"high":85,"text":"Sunny","code":32},{"day":"Sun","date":1549737000,"low":75,"high":85,"text":"Sunny","code":32},{"day":"Mon","date":1549823400,"low":76,"high":87,"text":"Mostly Sunny","code":34},{"day":"Tue","date":1549909800,"low":76,"high":89,"text":"Sunny","code":32},{"day":"Wed","date":1549996200,"low":77,"high":88,"text":"Partly Cloudy","code":30},{"day":"Thu","date":1550082600,"low":76,"high":89,"text":"Mostly Sunny","code":34},{"day":"Fri","date":1550169000,"low":76,"high":86,"text":"Sunny","code":32},{"day":"Sat","date":1550255400,"low":76,"high":85,"text":"Sunny","code":32},{"day":"Sun","date":1550341800,"low":74,"high":85,"text":"Sunny","code":32}]}

 

How to extract data of "current_observation"

 

Thanks

There is a web page that is programmed in ASP and has a simple one field form (drop down list) and a submit button.
After you submit the form by selecting an option (over 150 options), it will take you to the result page using the "Post" method. The variable does not show in the result page URL. The result page has table with multiple columns.
What I want is to have ALL the results in one CSV file.

Here what I really need in details:
1- Import all tables (one table for each option in the drop-down list) into a CSV file.
2- The content of two columns has codes. Replace all the codes in the table to a separate column.
3- Create an additional column that contains the name of the option on the first page form.

I need to have it in a php file so that I can run it via cron job few times a year.

How can I obtain this functionality with PHP?