PHP - Storing Php Drop Down Values To Databse

This topic has been moved to Application Design.

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

This is more of a database architect question.   I am building a CMS for website development. I am ready to use it for the first time on one of my clients. Now, my issue is is how to set up some or one of my table(s) for some areas that my client wants to be able to change in the admin section.   In their website on the front page, I put together this nice block slider. Its 6 blocks with text, a background image and nice effects. At first it was always going to be static, which was no issue at all, but later they came to me and asked if they could be able to change words in the boxes themselves in the admin section..   Of course this can be easily done by creating a table that is associated with this home page block thing and each row in the table will correspond to one of the blocks on the home page.   But I believe there might be an easier way to store this type of data without having to create another table for every feature the client wants to edit, for example they also want to be able to edit a slider on another page.   The WordPress database then came into my mind and how they store most of their data as JSON. So I was then thinking of creating a table named 'modules' for examples with three columns (id, title, data). Then inside the data column store the editable fields as a JSON string object.   For example a row could like like :   1, "Front Page Box Slider", {"slider-home" : [ {"data" : "value", "img_1", "value1"}, {"data" : "value", "img_2", "value2"} ]}   I've been doing a bit of research on this and people have just been saying, never do this if you do want your data to be searched through, which I don't.   Can anyone tell me why or why not I should do this, or maybe a better solution to my problem?   Thank you
Edited by carlosmoreeira, 17 September 2014 - 07:37 PM.

i want to store some data that i have gained from a request at the planetfile of openstreetmap: so i have set up a database on my opensuse 13.1

i have created a db called test on the mysql-server on my opensuse:

CREATE TABLE `pois` (
  `id` bigint(20) unsigned NOT NULL,
  `lat` float(10,7) NOT NULL,
  `lon` float(10,7) NOT NULL,
  PRIMARY KEY (`id`)
)

CREATE TABLE `pois_tag` (
  `poisid` int(11) NOT NULL DEFAULT '0',
  `tagname` varchar(45) NOT NULL DEFAULT '',
  `tagvalue` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`poisid`,`tagname`)
)

Where each tagname/value pair is stored as a row in a separate table with the pois id
Processing would be like this

<?php

$db = new mysqli(localhost,root,rimbaud,'test'); // use your credentials

$xmlstr = <<<XML
<data>
<node id="2064639440" lat="49.4873181" lon="8.4710548">
    <tag k="amenity" v="restaurant"/>
    <tag k="cuisine" v="turkish"/>
    <tag k="email" v="info@lynso.de"/>
    <tag k="name" v="Kilim  - Café und Bar Restaurant"/>
    <tag k="opening_hours" v="Su-Th 17:00-1:00; Fr, Sa 17:00-3:00"/>
    <tag k="operator" v="Cengiz Kaya"/>
    <tag k="phone" v="06 21 - 43 755 371"/>
    <tag k="website" v="http://www.kilim-mannheim.de/"/>
  </node>
  <node id="2126473801" lat="49.4851170" lon="8.4756295">
    <tag k="amenity" v="restaurant"/>
    <tag k="cuisine" v="italian"/>
    <tag k="email" v="mannheim1@vapiano.de"/>
    <tag k="fax" v="+49 621 1259 779"/>
    <tag k="name" v="Vapiano"/>
    <tag k="opening_hours" v="Su-Th 10:00-24:00; Fr-Sa 10:00-01:00"/>
    <tag k="operator" v="Vapiano"/>
    <tag k="phone" v="+49 621 1259 777"/>
    <tag k="website" v="http://www.vapiano.de/newsroom/?store=29"/>
    <tag k="wheelchair" v="yes"/>
  </node>
  <node id="667927886" lat="49.4909673" lon="8.4764904">
    <tag k="addr:city" v="Mannheim"/>
    <tag k="addr:country" v="DE"/>
    <tag k="addr:housenumber" v="5"/>
    <tag k="addr:postcode" v="68161"/>
    <tag k="addr:street" v="Collinistraße"/>
    <tag k="amenity" v="restaurant"/>
    <tag k="name" v="Churrascaria Brasil Tropical"/>
    <tag k="phone" v="+496211225596"/>
    <tag k="wheelchair" v="limited"/>
  </node>
  <node id="689928440" lat="49.4798794" lon="8.4853418">
    <tag k="amenity" v="restaurant"/>
    <tag k="cuisine" v="greek"/>
    <tag k="email" v="epirus70@hotmail.de"/>
    <tag k="fax" v="0621/4407 762"/>
    <tag k="name" v="Epirus"/>
    <tag k="opening_hours" v="Mo-Sa 12:00-15:00,18:00-24:00"/>
    <tag k="phone" v="0621/4407 761"/>
    <tag k="smoking" v="separated"/>
    <tag k="website" v="http://epirus-ma.blogspot.com/"/>
    <tag k="wheelchair" v="no"/>
  </node>
  <node id="689928445" lat="49.4799409" lon="8.4851357">
    <tag k="amenity" v="restaurant"/>
    <tag k="cuisine" v="italian"/>
    <tag k="email" v="gianlucascurti@ristorante-augusta.de"/>
    <tag k="name" v="Ristorante Augusta"/>
    <tag k="opening_hours" v="Mo-Fr 12:00-14:00,18:00-23:00;Su 12:00-14:00,18:00-23:00"/>
    <tag k="phone" v="0621 449872"/>
    <tag k="website" v="ristorante-augusta.com/"/>
    <tag k="wheelchair" v="no"/>
  </node>
</data>
XML;

$fields = array('id','name','lat','lon');
$xml = simplexml_load_string($xmlstr);

//
// PROCESS XML RECORDS
//

$poisdata = array();
$tagdata = array();

foreach ($xml->node as $node) {
    $nodedata = array_fill_keys($fields,'');
    $nodedata['id']  = intval($node['id']);
    $nodedata['lat'] = isset($node['lat']) ? floatval($node['lat']) : 0;
    $nodedata['lon'] = isset($node['lon']) ? floatval($node['lon']) : 0;
    $poisdata[] = vsprintf("(%d, %10.7f, %10.7f)", $nodedata);
    foreach ($node->tag as $tag) {
        $k = (string)$tag['k'];
        $v = (string)$tag['v'];
        $tagdata[] = sprintf("(%d, '%s', '%s')"
                , $nodedata['id']
                , $db->real_escape_string($k)
                , $db->real_escape_string($v));
    }
}

//
// STORE THE DATA
//
$sql = "REPLACE INTO pois ('id','lat','lon') VALUES\n" . join(",\n", $poisdata);
$db->query($sql);

$sql = "REPLACE INTO pois_tag (poisid, tagname, tagvalue) VALUES\n" . join(",\n", $tagdata);
$db->query($sql);

//
// DISPLAY THE DATA
//
$currentTags = array();
$sql = "SELECT DISTINCT tagname
        FROM pois_tag
        ORDER BY tagname = 'name' DESC, tagname";
$res = $db->query($sql);
while (list($tn) = $res->fetch_row()) {
    $currentTags[] = $tn;
}
$thead = "<tr><th>id</th><th>lat</th><th>lon</th><th>"
         . join('</th><th>', $currentTags) . "</th></tr>\n";
         
$currid = $currlat = $currlon = 0;
$sql = "SELECT p.id, lat, lon, tagname, tagvalue
        FROM pois p
            LEFT JOIN pois_tag t ON t.poisid = p.id
        ORDER BY p.id";
$res = $db->query($sql);
$tdata = '';
while (list($id, $lat, $lon, $t, $v) = $res->fetch_row()) {
    if ($currid != $id) {
        if ($currid) {
            $tdata .= "<tr><td>$currid</td><td>$currlat</td><td>$currlon</td><td>"
                . join('</td><td>', $poisrow) . "</td></tr>\n";
        }
        $currid = $id;
        $currlat = $lat;
        $currlon = $lon;
        $poisrow = array_fill_keys($currentTags,'');
    }
    $poisrow[$t] = $v;
}
$tdata .= "<tr><td>$currid</td><td>$currlat</td><td>$currlon</td><td>"
    . join('</td><td>', $poisrow) . "</td></tr>\n";
?>
<html>
<head>
<meta name="generator" content="PhpED 12.0 (Build 12010, 64bit)">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Tags</title>
<meta name="author" content="Barand">
<meta name="creation-date" content="06/04/2014">
<style type="text/css">
body, td, th {
    font-family: arial, sans-serif;
    font-size: 10pt;
}
table {
    border-collapse: collapse;
}
th {
    background-color: #369;
    color: white;
    padding: 5px 2px;
}
td {
    background-color: #EEE;
    padding: 2px;
}
</style>
</head>
<body>
<table border='1'>
    <?php echo $thead, $tdata; ?>
</table>
</body>

</html>

leeeds to the following errors....

PHP Fatal error:  Call to a member function fetch_row() on a non-object in /home/martin/php/osm_200.php on line 121
martin@linux-70ce:~/php> php osm_200.php
PHP Notice:  Use of undefined constant localhost - assumed 'localhost' in /home/martin/php/osm_200.php on line 3
PHP Notice:  Use of undefined constant root - assumed 'root' in /home/martin/php/osm_200.php on line 3
PHP Notice:  Use of undefined constant rimbaud - assumed 'rimbaud' in /home/martin/php/osm_200.php on line 3
PHP Fatal error:  Call to a member function fetch_row() on a non-object in /home/martin/php/osm_200.php on line 121
martin@linux-70ce:~/php>

so what goes wrong here...?

Hello!

I am designing a user registration form which has some radio buttons for people to select. I am confused as to how I should store the value selected by the user into the database.

Here is my code, just in case.
<li id="li_2" >
<label class="description" for="element_2">I am a  </label>
<span>
<input id="element_2_1" name="element_2" class="element radio" type="radio" value="1" />
<label class="choice" for="element_2_1">Student</label>
<input id="element_2_2" name="element_2" class="element radio" type="radio" value="2" />
<label class="choice" for="element_2_2">Staff</label>
<input id="element_2_3" name="element_2" class="element radio" type="radio" value="3" />
<label class="choice" for="element_2_3">Member</label>
<input id="element_2_4" name="element_2" class="element radio" type="radio" value="4" />
<label class="choice" for="element_2_4">Other</label>
</span>
</li>   

Hi there,

I am working on a PHP web form and I have a very simple situation I guess, I have a variable named: $MyVal

When I do

print_r($MyVal);
To see whats inside, I get:

SimpleXMLElement Object ( [0] => 8.23 )
Now I am assigning this variable into a session variable so that I can do calculations with it.

So I assign:

$_SESSION['MySesVal'] = $MyVal;
But after assigning to session variable, when I do my calculations:

$finalValue = $_SESSION['MySesVal'] * 4;

I get 0. So is it because the actual $MyVal variable has some XML stuff as:

SimpleXMLElement Object ( [0] => 8.23 )

So what is the right way to properly assign $MyVal variable to a session variable to do calculations.

Please reply.

All comments and feedbacks are always welcome.

Thank you!

i have a dictionary  - THIS IS obviously a python dictionary

an this has approx 8 000 lines with records


[/CODE]

$ python printer.py
{'url': 'http://www.site1_com' 'cname': 'butcher', 'name': 'cheng', 'email': 'mail1@hotmail.com'}
{'url': 'http://www.site2_com' 'cname': 'dilbert', 'name': 'James', 'email': 'mail2@hotmail.com'}

[code=auto:0]i have a mysql-db up and runing in my opensuse

there i have created a db with the fields

url
cname
name
email



i use the

import MySQLdb

i studied this documentation he http://stackoverflow...abase-in-python

but i think this goes a bit over my head.


- well how can i get the data  ( in other words the dictionary) into the database?

love to hear from you

greetings

helllo dear php-commmunity


new to Ruby - i need some advices -

i plan to do some requests in osm-files. (openstreetmap)

Question - how can i store the results on a Database -
eg mysql or - (if you prefer postgresql) -

note: my favorite db - at least at the moment is mysql


here the code

    require 'open-uri'
    require "net/http"
    require 'rexml/document'
     
    def query_overpass(object_type, left,bottom,right,top, key, value)
       base_url = "http://www.overpass-api.de/api/xapi?"
       query_string = "#{object_type}[bbox=#{left},#{bottom},#{right},#{top}][#{key}=#{value}]"
       url = "#{base_url}#{URI.encode(query_string)}"
       resp = Net::HTTP.get_response(URI.parse(url))
       data = resp.body
       return data
    end
     
    overpass_result = REXML::Document.new(query_overpass("node", 7.1,51.2,7.2,51.3,"amenity","restaurant|pub|ice_cream|food_court|fast_food|cafe|biergarten|bar|bakery|steak|pasta|pizza|sushi|asia|nightclub"))
     
    overpass_result.elements.each('osm/node') {|x|
      if !x.elements["tag[@k='name']"].nil?
        print x.elements["tag[@k='name']"].attributes["v"]
      end
      print " | "
     
      if !x.elements["tag[@k='addr:postcode']"].nil?
        print x.elements["tag[@k='addr:postcode']"].attributes["v"]
        print ", "
      end
      if !x.elements["tag[@k='addr:city']"].nil?
        print x.elements["tag[@k='addr:city']"].attributes["v"]
        print ", "
      end
      if !x.elements["tag[@k='addr:street']"].nil?
        print x.elements["tag[@k='addr:street']"].attributes["v"]
        print ", "
      end
      if !x.elements["tag[@k='addr:housenumber']"].nil?
        print x.elements["tag[@k='addr:housenumber']"].attributes["v"]
      end
      print " | "
      print x.attributes["lat"]
      print " | "
      print x.attributes["lon"]
      print " | "
      if !x.elements["tag[@k='website']"].nil?
        print x.elements["tag[@k='website']"].attributes["v"]
      end
      print " | "
      if !x.elements["tag[@k='amenity']"].nil?
        print x.elements["tag[@k='amenity']"].attributes["v"]
        print " | "
      end
      puts
    }

look forward to hear from you

again - i would love to store it on a mysql - database - if possible. If you would prefer postgresql - then i would
takte this one.... ;-)



look forward to hear from you

again - i would love to store it on a mysql - database - if possible. If you would prefer postgresql - then i would
takte this one.... ;-)

well - i guess that the answer to this will be the same no matter what language we are using.
If the db is a sql database we need to design the database schema and create the tables in the database.

The first step in accessing a db in our code is to get a connection to it.
If ruby is our choice of language, a search for "ruby sql connector" will give us
lots of options to read about.

Well - we also can do it in PHP. What do you think!?

Next, based on the schema we have designed, we need to create queries suitable for storing the data.
We will likely need to consider our transactional model.

Again, searching "ruby sql transactional model" will give us plenty of food for thought. Finally, we may want or need to close the connection to the database.

I created a simple search box which will query my table and match the input value to one of my columns. two of these columns store comma separated values. if i query a column other than a column which stores my csv i can see my search results. if i query a column which stores my csv i will not see results unless the search value matches the first value within the column. how would i be able to get say the second or third or forth value. here is the code i am using to query the table any help would be appreciated thanks.

Code: [Select]
$q = $this->db->query("SELECT * FROM table WHERE col1 LIKE 'searchvalue'".
             " OR col2 LIKE 'searchvalue'".
             " OR col3 LIKE 'searchvalue'".
             " OR col4 LIKE 'searchvalue'".
             " OR FIND_IN_SET('searchvalue', col5) > 0 ".
             " OR FIND_IN_SET('searchvalue', col6) > 0");

Hello again, guys!
I have a couple of questions that I hope anyone can answer.

I am making a form that is storing the information in a database, and in this form I also want images to be uploaded.
I want to make a function that allows the user to upload as many images as they would like to have in their ad on my website, and I also need something that can handle the upload process, and see how many images the user is trying to upload. Any easy solutions for this?

I also have another question:
As you can see on the example image underneath this text, I have a form with multiple inputs where the user is suppose to choose how many inputs they want to fill in themself.
How should I store this information in the database, and how can I make a script that detects how many of the forms the user actually filled?

I hope you guys understood what I was trying to say, and I thank you all anyways.
Underneath you can see an image of my forms.

Example image:


Cheers,
Marius

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

I've got two tables (classOfferings, instructors). The fields I'm dealing with are 'co.instructorId', 'i.instructorId', 'i.fName', 'i.lName'.
I have a form with dynamically generated drop downs.
What I would like to do is check classOfferings table to see which instructors are teaching classes then display them in drop down with the 'instructorId' as the value and 'fName' and 'lName' as the user selectable part.  So I have found the distinct 'instructorId', but I can't make 'fName' and 'lName' appear as the user selectable part.
The code below produces a drop down which has invisible values, but still posts a value.

<select size="1" name="instructor">
<option value="" selected>Search By Teacher...</option>
<?

$instrList=mysql_query("select distinct instructorId from classOfferings order by instructorId asc");
$instrNameList=mysql_query("select fName, lName from instructors where classOfferings.instructorId = instructors.instructorId order by lName asc");

// Show records by while loop.
while($instructor_list=mysql_fetch_assoc($instrList)){
$instrNames = ($instr_Name['fName']) . ($instr_Name['lName']);
?>
<option value="<? echo $instructor_list['instructorId']; ?>" <? if($instructor_list['instructorId']==$select){ echo "selected"; } ?>>
<? echo $instrNames; ?></option>
<?
// End while loop.
}
?>

</select>

i'm trying to print out values from a table into a drop down box, but my code doesnt seem to work. when i test it, there are no values in the drop down box.

if someone could find the problem, that would be great.

<form name="add_sub_section" method="post" action="<?php echo $_SERVER['../PHP_SELF']; ?>">
Sub Section Name <input type="text" name="sub_section_title" maxlength="200" /><br/><br/>
Sub Section desc <textarea name="sub_section_desc" rows="4" columns="30" /></textarea><br/><br/>
SECTION 
<?php
$list = "SELECT section_title FROM section_main";
echo "<select name='section_title'>";
while ($a = mysql_fetch_row($list)) {
for ($j = 0; $j < mysql_num_fields($list); $j++) {
echo "<option value=". $a[$j] . ">". $a[$j] . "</option>";
}
}
echo "</select>";
?>
<br/><br/>
<input type="submit" name="submit" value="Add Section"/>
</form>


the connection to the table works, so i havnt put that code in.
 there's no formatting for the html yet, i just want to get the php working first
Thanks

Ive been scanning over and over this code and I cant work out why my 2nd drop down menu doesnt have unique values.
Please if anyone can give me guidance, you never know I may be able to get rid of my headache!

Code: [Select]
<body>
<p>
<form action="" method="post">
<select name="drop_1" id="drop_1">
<option value="" selected="selected" disabled="disabled">Select a Category</option> 
<?php getTierOne(); ?>
</select>
<span id="wait_1" style="display: none;">
<img alt="Please Wait" src="ajax-loader.gif"/>
</span>
<span id="result_1" style="display: none;"></span>   
</form>
</p>
<p>
<?php if(isset($_POST['submit'])){
$drop = $_POST['drop_1'];
$tier_two = $_POST['Subtype'];
echo "You selected ";
echo $drop." & ".$tier_two;
}
?>
</body>
Code: [Select]
<?php
function getTierOne()
{
$result = mysql_query("SELECT DISTINCT Type FROM business") 
or die(mysql_error());
while($tier = mysql_fetch_array( $result ))   
{
echo '<option value="'.$tier['Type'].'">'.$tier['Type'].'</option>';
}
}
if($_GET['func'] == "drop_1" && isset($_GET['func'])) { 
   drop_1($_GET['drop_var']); 
}
function drop_1($drop_var)
{  
include_once('db.php');
$result = mysql_query("SELECT DISTINCT Subtype FROM business WHERE Type='$drop_var'") 
or die(mysql_error());
echo '<select name="Subtype" id="Subtype">
<option value=" " disabled="disabled" selected="selected">Choose one</option>';
while($drop_2 = mysql_fetch_array( $result )) 
{
echo '<option value="'.$drop_2['Subtype'].'">'.$drop_2['Subtype'].'</option>';
}
echo '</select> ';
echo '<input type="submit" name="submit" value="Submit" />';
}
?>

Hi all,

I'm just wondering if there's an easier way of doing what accomplishing the following:

I have a value in my database which represents a selection in a drop down menu, i want to read it from the database and have it automatically selected depending on the stored data.

I have the following working but just wondered if there was an easier way to get the same result:

Code: [Select]
<?php
//database connection

$query = "SELECT id
  FROM  `tablename`
  WHERE  username='$username'";
$result = mysql_query($query);
$row = mysql_fetch_object($result);

$id = $row->id;
$id = (int)$id;
?>

<select name="id">
<option value="">Select your option...</option>
<option value="1" <?php if (($id - 1) === 0) { echo 'selected="selected"'; }?>>Selection 1</option>
<option value="2"<?php if (($id - 2) === 0) { echo 'selected="selected"'; }?>>Selection 2</option>
</select>

Sorry if it's not very clear, i'll explain best i can if anyone can help.

Thanks

Basically,

I have a database table called 'users' and I would like to populate a drop down box with these values of 'users'.

How?? - to call upon the values is this: 'upduser2'

Right now, all I am using is a text box, in where you have to type in the users name manually (this is so an admin can change variables and settings according to that current user). This is what I am using so far:


<h3>Update User Level</h3>
                                                    <? echo $form->error("upduser"); ?>
                                                    <table>
                                                      <form action="adminprocess.php" method="post">
                                                        <tr>
                                                          <td> Username:<br />
                    <input type="text" name="upduser" maxlength="30" value="<? echo $form->value("upduser"); ?>" /></td>
                                                          <td> Level:<br />
                                                          <select name="updlevel">
                                                              <option value="1">1 </option> //example settings
                                                              <option value="9">9 </option>
                                                            </select></td>
                                                          <td><br />
                                                            <input type="hidden" name="subupdlevel" value="1" />
                                                            <input type="submit" value="Update Level" /></td>
                                                        </tr>
                                                      </form>
                                                    </table></td>
                                                </tr>


Much help would be appreciated.