Dynamically Creating Html Table Based On Array
I need to create a table based on parameters from a form on the previous page. The form sends up to 15 variables that are read out of the url into an array ($func).
These variables refer to functions that a product may or may not have. This page should show which products have the functions chosen.
Normally when I create such a table in DW, its always based off the DB directly with SQL, with a filter on the URL parameter. I can't work out how to do the same when there are multiple parameters in the URL, or alternatively, pulling the parameters from the array.
View Complete Forum Thread with Replies
Related Forum Messages:
Creating An Array From An HTML Table
Before I try to do this myself (I remember doing it in Java years ago and it was a pain).... Has anyone run across a function that will take a string parameter containing an HTML table, and return a 2-dimensional array with each element corresponding to the contents of a table cell? I see plenty of examples of doing the opposite: convert an array to an HTML table. I want to go the other way, from an HTML table to an array.
View Replies !
Dynamically Creating URLS Based On User Input !
I am looking to create pages on the fly or dynamically based on user input. For example if i have www.example.com and they visit this and enter 'bob' in a textfield and press submit they create www.example.com/bob.html . How would I go about this ? I am guessing I need to create a folder when submit is pressed in my website directory ?
View Replies !
Creating Table Rows Based On Query Result
I am trying to create a simple table with a fixed number of columns (5) but the number of row will depend on the results of the query. I have tried various examples found here or there and I can't get them to work. Code:
View Replies !
Dynamically Populate Drop-down List And Dynamically Include Html File
We have a drop down list on a PHP page, with several product names, and when people click one item, we will refresh the same page with the product name as parameter, and in turn we want to include a HTML file into the content area of the same page. I know it is recommended to put everything into database, but we want the web site to be very "portable", so the drop-downlist and the content should both in text files. Let's say the drop-down list will be poplulated from the product.txt file, and there will be a file for each corresponding item in the drop-down list. From the user point of view, if he wants to add a new product, he will just need to open the product.txt file, and add a new line with the product name, "Laptop", then add a new text file named "laptop" in the same folder which contains the HTML fragment to be included in the content area. What is the easiest way to do this?
View Replies !
Dynamically Select From 2 Tables Based On Id
im working on a performance request system, and i have three tables that im working with right now. the performances table holds the info about the performance (date, times, status, etc.), and has two columns, org_type and org_id, which both hold an int value to tell me where the organization info is. there are two org types which have respective tables, because we collect different information based on the type of org that is registering. is there any way to select info from all three tables (dynamically selecting between the two org tables based on org_type, then selecting the proper org info based on org_id) in one query?
View Replies !
Dynamically Show Content Based
I have a shopping cart template (leftcolumn template), that I want to show a different div depending on what the URL of the page is. For example, if the category id in the url is 250, then I want a certain div to display, but if the category url is 248, then I want a different div to display. Basically, how do I fetch the url info and then have that info change the content on the fly. Remembering that this is a template file.
View Replies !
HTML Table Data Into Array
I want to know if it already exists. I need some PHP code that will read a web page and return all text that comes between <td></td> tags in an array. So if there were three tables on that page, it would return the first table's fourth row, third column in a variable such as: $tableArray[0][3][1] // ^ ^ ^ - 2nd <td></td> // ^ ^ - 4th <tr></tr> // ^ - 1st <table></table> Does something like this exist somewhere where I can grab it, or do I have to build it from scratch?
View Replies !
Php Array Data To Html Table
I parse an XML file every day into php and use the print_r() function to display the contents. It looks like this: <Name="JOE" score="1.2538" /> <Name="BOB" score="136.69" /> <Name="ANN" score="0.5729" />
View Replies !
Parse HTML Table Rows Into Array
I have a script that extracts an HTML table from a page into a text string. I would like to parse each row of the table into an array named "$rows". I would like to keep the html intact so that I could re-create the same table like: Code:
View Replies !
Extract Html Table Cells And Put To An Array
i have a table like: <tr><td>headA</td><td>headB</td><td>headC</td><td>headD</td></tr> <tr><td>1a</td><td>1b</td><td>1c</td><td>1d</td></tr> <tr><td>2a</td><td>2b</td><td>2c</td><td>2d</td></tr> <tr><td>3a</td><td>3b</td><td>3c</td><td>3d</td></tr> <tr><td>4a</td><td>4b</td><td>4c</td><td>4d</td></tr> where there can be any number of rows and there can be any number of columns. how can i read through this and create an array for each row, and use the header row as the keys. ie have it something like: QuotemyArray[0] = array( 'headA' = '1a', 'headB' = '1b', 'headC' = '1c', 'headD' = '1c', ); myArray[1] = array( 'headA' = '2a', 'headB' = '2b', 'headC' = '2c', 'headD' = '2c', ); etc....
View Replies !
How Do I Retrieve Images Dynamically Based On The Login Username?
I have created a site in Joomla with a login (no self registration, users are provided with username and password by the admin). The users are supposed to login to a specific page where they can see 4 images. I have the following code: <?php // define directory path $dir = "images/user1/"; // iterate through files // look for JPEGs if (is_dir($dir)) { if ($dh = opendir($dir)) { while (($file = readdir($dh)) !== false) { if (preg_match("/.jpg/", $file)) { // read EXIF headers $exif = exif_read_data($file, 0, true); echo "<tr>"; // get thumbnail // link to full image echo "<td valign=top><a href=$dir/$file><imgsrc=thumbnail.php?file=$file></a><td>"; echo "<td valign=top><font size=-1>"; // get file name echo "File: <b>" . $exif['FILE']['FileName'] . "</b><br/>"; // get timestamp echo "Timestamp: " . $exif['IFD0']['DateTime'] . "<br/>"; // get image dimensions echo "Dimensions: " . $exif['COMPUTED']['Height'] . " x " . $exif['COMPUTED']['Height'] . " <br/>"; // get camera make and model echo "Camera: " . $exif['IFD0']['Model']; echo "</font></td>"; echo "</tr>"; } } closedir($dh); } } ?> The question now is how to change the code to dimamically replace the folder name by the login username used. For example....if user2 logs in the images loaded will be only those in the folder images/user2, if user3 logs in it will be from the folder images/user3, etc... I am a little confused as to how to implement that in Joomla but as long as I have the code right I thinkI can just insert the code into the appropriate page using a mambot. If anybody here has any tips on how to accomplish that it would be extremely appreciated.
View Replies !
Dynamically Populating Listboxes Based On Previous Selection
How do I populate the second listbox in this form based on the selection of the first listbox? The first listbox is populated by this query: $year_query = "SELECT distinct year FROM bench_data"; The second listbox should essentially be populated by this: $industry_query = "SELECT distinct comp_desc FROM comp_desc, benc_data where $_POST['year']=bench_data.year and bench_data.comp_key=comp_desc.comp_key"; I know this is alot to ask, but please EXPLAIN the code. I am new and need the explanation elucidated and not just supplied code that will accomplish the goal. Code:
View Replies !
Dynamically Creating A Crontab
Is it possibe to dynamically create a crontab. Say i have a form to enter minute, hour, day, etc... and wanted to create a cronjob that ran to those values. Has anyone done this?
View Replies !
Creating .m3u Files Dynamically
Im looking at creating a playlist program for my server. i have alist of files within my database, and i wanted to be able to place these values into a playlist file. the problem is that i dont know how to get the database to create the playlist form its records. ie, if i uploaded a new file to my server and into the database, then i woudl want the script to automatically grab that file ( SQL i know), anbd the nplace it in the m3u file ( i dont know). Coudl someone recommend a simple method to complete this? or point me in teh righ t doirection for a tutorial?
View Replies !
Creating Queries Dynamically
I've been struggling with a problem for a while and I think that the solution lies in the ability to create queries dynamically. On one page I have a number of drop-down menus created dynamically, so the number of menus can vary. Each drop-down represents a try/touchdown scored, and the user would select from the menu who scored it. On the next page I want to take the info entered and send it to the database, automatically creating new entries for each try/touchdown scored. Code:
View Replies !
Dynamically Creating A Image
I need to dymaically create a thumbnail button that when the user clicks on it, it does 2 things so i need to call php to echo out <a href commands 1. links to another page called (page1.php) 2. popup another page in new browser called (page2.php) but set this popup in the background but the problem is <a href only allows 1 page to be linked how do i do the above? can anyone show me an example of what should be written in the php echo command?
View Replies !
Dynamically Creating An Image With Imagecreate()
I have a multitude of images that I am trying to bring up dynamically depending on the scenario. These images are different sizes. To complicare things just a little more, I am rewriting a javaScript. Am I heading into the correct direction? Here is the original JS that I am attempting to rewrite: (This is most of the way translated to PHP)
View Replies !
Creating Text Files Dynamically
i am trying to create a text file using php. i want the file to be named by the value passed by a form text box. i am using the following code, but it also adds ' ' to the file name as well. please correct me. <?php $filename = "textfiles'$name.txt'"; $fp = fopen($filename, "a"); $strings1 = "line1 line2 line3 line4 line5"; $write = fputs($fp, $strings1); fclose($fp); ?>
View Replies !
Table Background Color Based On Results From MySQL Table
I am trying to get the "Did User Agree" field on a database query to be colored Green for "Agreed" Red for "Disagreed" and Blue for "Agreed (2nd Time)" .. I have my PHP setup to do the query just fine as of right now with alternating column colors, just can't seem to get the colors to work as I am hoping for. Can anyone help me get the Agreed? table's background color to the colors above? Code:
View Replies !
Showing Data From A Table Based On Infos From Another Table!
i have 2 tables in my database : THREAD, and POST THREAD's rows are: THREADID, TITLE + FORUMID + REPLYCOUNT + VIEWS POST's rows are: THREADID, PAGETEXT and PARENTID i'm a big php newbie... I want to display the LAST TWO messages (highest THREADID) of my forum number 99 (FORUMID=99). I can probably do that, but the problem is that the text of the message is located in another table.. and it's getting too hard for my low-skilled brain lol so basically I would like to check in "THREAD" for the highest THREADID where FORUMID=99, display the TITLE, REPLYCOUNT and VIEWS, and then check in POST for the same two THREADID's where PARENTID=0 (meaning it is the first message in the thread) and finally display the PAGETEXT ! Could anyone give me a PHP code that would display that?
View Replies !
Create A Table Dynamically
I am trying to create a table dynamically- meaning that a user will be able to add or delete rows via an admin tool. For now, the number of columns will be a fixed number. I figure I can store each row of information in a database and then keep some type of index to keep track of column inserts, deletions, etc. Does this make sense? Does any one have any ideas on how to accomplish this?
View Replies !
Creating An Article Based Website
i need to create an article based website, what words should i search for in yahoo to find a good strategy? or can someone just give me hints how to create it? the site should do the following-> 1-only administrator can add articles 2-public can only search 3-and of course the search should be optimized and fast.
View Replies !
Dynamically Generated Results Table
I'm trying to write a script that dynamically generates HTML tables depending on the results from an SQL query. So far, I have managed to set the HTML table headers to be the same as those in the MySQL table. [thanks to rod k -cheers !] Now i'm trying to put the results in the table. Basically, I need a MySQL function to retrieve data and put it into the table until there is no data left.... (At the moment I am using "mysql_fetch_array()", but with this it is necessary to know the names of the columns to retrieve the information for each result set. Since my table is dynamic and should be able to build itself from different MySQL tables, the column names aren't fixed and so i can't use this to put the data in the tables...)
View Replies !
Creating The Timer For A Turn-based Game
I've been working on creating an online turn-based game where a new turn occurs every hour, and the amount of items such as resources (gold, iron, food, whatever) is changed when the turn changes, regardless of whether a user is online or not. I've played many games like this before (I guess falling under the PBBG genre), so I know this is possible, but I can't figure out how to do it, and I'm obviously searching for the wrong phrases in forums because I can't find a tutorial anywhere.
View Replies !
Creating Rules Based Data In Form
On my form that I created that the data is being sent into a database, I also want to create rules to send outgoing email 1 of 5 people depending on something that was entered in the form.
View Replies !
Creating Totals Based On Field Input
I am trying to create a report with PHP that pulls data from a mysql database. Lets say in table called survey I have a field called zipcode, in which users fill out a form and enter their zip code. In the database the following entries have been made in the zipcode field: Code:
View Replies !
Dynamically Generated HTML
I am trying to fit dynamically generated HTML into a variable so I can mail it out to a recepient. Now - the catch is that the dynamic generated HTML contains nexted regions which mace some heavy duty use of "if" and "while" statements. Here is a code snippet example: $msgbody = "<a id="top"></a> <table width="100%" align="center"> <tr><td><span class="style3">$mailinga[analysis]</span></td></tr></table> <br />" ----> this is where the error occurs - it says unexpected T_IF <---- if I set a semicolon after the quotes above it will not include the stuff below, and I tried other combinations of symbols and googled the issue but no go - please help. ---->:( if($asnc > 0) ................
View Replies !
Dynamically Add New Html Pages
i want to build a new site for a friend but have noticed that in some free software i have installed you can dynamically add new html pages via an admin section. How is this done, i would like to beable to view the current pages via the adim side and edit and delete them as well as create them?
View Replies !
Parse CSV Headers & Dynamically Generate SQL Table?
I have a collection of CSV datasets which will all contain different numbers of columns and different column headers. There will always be a fixed number of such files and they have some common characteristics, especially those with column names in common (e.g., at some point I will be performing some database joins based upon similar column names). Initially I would like to parse each CSV file and automatically create a mySQL table containing fields corresponding to the CSV file headers. In some subsequent web page(s) I will be performing some boolean queries against this mySQL database, and will need to query the field names on the fly so that I can create suitable drop-down lists for the user to formulate her query. I'm really a Perl programmer, but have a feeling that this will be much easier in PHP.
View Replies !
Dynamically Create Table Rows As Needed
I have a form with a table. Each table row has a ID= "some number". I have 4 rows and might need to create more. how can i do this in php? To go along with this, When I hit the submit buton, I then need all the table row data saved to a db i have. I can insert 1 line with out a issue. I also made sure the table row name="" fields are unique. ex. Code:
View Replies !
Dynamically Build Table Of Images From Folders?
I have on our company web site a folder named "gallery". In that folder are MANY folders with varying names ("Bethel","Hamptonburgh",etc..). In each of these folders are a number of images and slideshow.php. What I am looking to do is dynamically build a Master page that will look in the Gallery folder, add a table cell for each sub folder, select 1 image from that folder (doesn't matter which one) to display in the cell, and give the cell a link to the corresponding slideshow.php for that group of images. The dynamic table needs to be 2 columns by "x" rows. Now, I can build a table using php, but how the heck do I go about getting all the folder links and images? Any ideas? The sub folders change constantly, with new stuff added and old stuff removed. If this can be done it would save me a TON of edit work on just this one page alone..
View Replies !
Creating Dynamic Page Based On Dropdown Selection?
I'm using Dreamweaver, but I believe this is a general PHP/MySQL question. I have a table, with 4 fields: id, year, car_make, car_model. The data looks like this: 1 1992 Honda Civic 2 1994 Ford Probe GT 3 1999 Audi S4 4 2002 Porsche 959 On my web page, I have a drop down list that's propogated automatically with the "car_model" field entries which are pulled from that table. So when I click the down arrow, I see Civic, Probe GT, S4 and 959. Code:
View Replies !
Dynamically Sorting MysQL Table Rows With Links?
I've just created a simple CMS but there's a certain functionality I want but dont know where to begin. Ive created a page that lists the records from a table in my database. That works fine. But what I now want to be able to do is have 2 links next to each record that moves the desired record up or down in the listing. I assume that this is a case of swapping the record id numbers so the order of the database information is changed? Does anyone have any knowledge of this or could point me in the right direction to help me out?
View Replies !
Static Html With One Dynamically Served Line?
I've a site with static HTML product pages. I would like to make the price on these pages dynamic so that when all of the prices change, rather than change them on each individual page, I can just change them in one place. But just the price in the list of product details that I wanted to serve dynamically. I've had a couple of posts back from my first query who say PHP is the way to go, so I thought that I'd come to the masters and check it would be able to do this?
View Replies !
Accessing Dynamically Created HTML Forms
Basically I have a form dynamically created by results from a database. As such it's going to be different ever time it's used. For each row in the database I want to have a drop-down list. So my HTML form looks like this: Code:
View Replies !
Selecting Array Rows Based On An Array Of Field=>values
Here's the code i have: $db = array(); //main array $db['main'] = array(); //table `main` $db['main'][] = array('id'=>0, 'username'=>'joshfrench','userpass'=>'password','userlevel'=>'admin'); //row $db['main'][] = array('id'=>1, 'username'=>'bob_smith','userpass'=>'psswrd','userlevel'=>'user'); //row function trim_value(&$value){ $value = strtolower(trim($value)); } function fdb_select($fields = "*", $table, $where = false, $limit = false){ global $db; $retv = $db[$table]; //LIMIT RESULTS TO FIELDS if(strrpos($fields, ",") === false){$field=array($fields);}else{$field = explode(",", $fields);}; array_walk($field, "trim_value"); $all_fields = array_keys($retv[0]); if($fields == '*'|| is_null($fields)){$field = $all_fields;}; $field = array_uintersect($all_fields, $field, "strcasecmp"); $retvi = array(); foreach($retv as $num =$row){ foreach($row as $fname =$fvalue){ $fname1 = strtolower($fname); if(in_array($fname1, $field)){ $retvi[$num][$fname]=$fvalue; }; }; }; //DONE LIMITING TO FIELDS if($where != false){ //UP TO HERE IT WORKS FINE //LIMIT TO WHERE CLAUSE $retvj = array(); foreach($retvi as $num =$row){ //IN THE ROW foreach($where as $k =$v){ //IF ROW MEETS ALL REQUIREMENTS if($row[$k] == $v){ $retvj[] = $retvi[$num]; //Keep that row }; }; }; //DONE LIMITING TO WHERE CLAUSE }; $retvi = (isset($retvj)) ? $retvj:$retvi; //SEND A FINAL ASSOCIATIVE ARRAY return $retvi; }; print_r(fdb_select("*", "main", array('id'=>"1", "username"=>"joshfrench"))); the previous code outputs this: Array ( [0] =Array ( [id] =0 [username] =joshfrench [userpass] =password [userlevel] =admin ) [1] =Array ( [id] =1 [username] =bob_smith [userpass] =psswrd [userlevel] =user ) )
View Replies !
Unique Titles To Html Pages That Are Dynamically Created
how to assign unique titles to html pages that are dynamically created through php? The problem IAM having is that although the pages on my site have html extensions when loaded in the browser they are not present on my server, this must mean that they are generated dynamically right? For this reason I am unable to assign unique titles to each page.
View Replies !
How To Add Element In Array Dynamically?
I want to add two element in a array. the first one is the key and the second is the value.but I want to add it dynamically. i want to do it like the following code: $arr=""; for($i=0;$i<20;$i++) { $arr[$i]=arr($i=>$i+1); array_push($arr[$i]); } print_r($arr); But of couse it don't work. Could anyone tell me how to do it ?
View Replies !
Array Dimension Dynamically
Is there a way that we can increase the array dimension dynamically like: PHP Code: $a = array(); // May be using for loop for($i=0; $i < 5; $i++) $a[0]; $a[0][0]; $a[0][0][0]; $a[0][0][0][0]; $a[0][0][0][0][0]; But not sure how can I accomplished that, or maybe is there other way which has the same concept as this dynamic array dimension resizing.
View Replies !
Creating A New Table With A Variable Table Name
Is there a way to automatically create a table with a tablename that is taken from a field the user has previously entered (i.e. username). I have tried : $sql ='CREATE TABLE $username (....)' and $sql ='CREATE TABLE '$username' (....)' but neither work. Any ideas??
View Replies !
Create A Table With A Textfield Where The User Can Enter An Amount For A Certain Dynamically Created Article
I want to go create a table with a textfield where the user can enter an amount for a certain dynamically created article coming from the database. Later, I want to calculate the whole price and so on. It works nicely to create my multi dimensional array, however, it does not work to save the values coming from the form to calculate the price. What's wrong??? <form name="shop" method="post" action="index.php"> $articleTable = array(); while ($row = mysql_fetch_array($result)) { $articleNr= $row["articleNr"]; $name= $row["name"]; $picName= $row["picName"]; $price = $row["price"]; $amount=""; $articleRow = array( "articleNr" => $articleNr, "name" => $name, "picName" => $bildName, "price " => $price , "amount" => $amount ); array_push($articleTable , $articleRow ); } foreach($articleTable as $article) { ?> <input type="text" name="article[amount]" size="2" maxlength="2" value="<? $article[amount] ?>"></td> } <? } ?> </form>
View Replies !
Dynamically Adding To Multidimensional Array
$sql= sql query $i=0; while ($a2=mysql_fetch_array($a1)){array_push($temparray ,$a2[0],$a2['ad'],$a2[1],$a2[1]); { I want this array to be the value of an asssoc. array $results[$i] $results[$i] =$temparray doesnt work $results[$i] =$temparray[] doesnt work $results[$i][] =$temparray doesnt work $results[$i] =>$temparray doesnt work then $i++; } so what does ?
View Replies !
Create Multidimensional Array Dynamically
I'm already trying for some days to create an array dynamically. I have the following situation: I have an array of strings. $data["base:foo:bar"] = "test1"; $data["base:foo2:bar"] = "test2"; $data["base:foo2:bar2"] = "test3"; $data["base:foo:bar2"] = "test4"; This array should be converted in a multidimensional array. The keys for this array are the above keys separated by colons. The dimension of the array varies form situation to situation. Code:
View Replies !
Dynamically Associating Array With Textfield
I have a form consisting of 3 dropdowns next to text fields, ie: Label: Textfield Select ---------------------------- Time1: 2 Days Time2: 2 Hours Time3: 2 Months (the option 'Week' is also available') I can go so far as to determine that Time1 has Day selected, Time2 has Hours selected, and Time3 has Months selected, like so: Array ( [0] => hour [1] => day [2] => month ) I then want to compare apples to apples by converting days, months, and weeks into hours (and eventually back again), so now I want to dynamically determine that Time1 (array 0) is associated with Time1, so textfield must now be 2*24 to equal 48 hours, while Time3 (array 2) must be 2*730.484398. Code:
View Replies !
|
TRACKER
