Miko

Hello, I'm buidling a php scripts that dynamically get's subfolders from a specific folder. my code: <?php if(isset($button)){ $opendirdepot = opendir("C:/xampp/htdocs/arl/$depot/"); while($dirdepot = readdir($opendirdepot)){ if(is_dir($dirdepot)){ echo "Is a folder: ".$dirdepot."<br />"; }else{ echo "Is not a folder: ".$dirdepot."<br />"; } } closedir($opendirdepot); } ?> Output: The problem is that 20091012 and 20091013 are in fact folders. Anyone an idea? Thanks

your right, my explaination was not correct. I would like to do the following (tell me if it is hard to understand, my english is not so good): There a select menu with some contact persons inside. User selects one of the contact persons and should get the details of that person in the input fields below I'm trying to use the if in_array because I want to maintain the list of contact persons in the select menu. I hope that I was clear enough here?

FCkEditor?

Hello, I'm kinda new in oop php so my following question could be very easy for you experts I have here my code: <?php $contact = new Contact(); $get_contact = $contact->get_Contact($cl_number,$contact_id); if($get_contact == true){ echo "<select name=\"get_contact\" onChange=\"ContactDetails(this.value)\">"; echo "<option selected> </option>"; foreach($get_contact as $Contact){ $fname = $Contact['FIRST_NAME']; $lname = $Contact['LAST_NAME']; $email = $Contact['EMAIL']; $tel = $Contact['TEL']; $clnumber = $Contact['CUST_ID']; $c_id = $Contact['ID']; echo "<option value=\"$c_id\">".$fname."</option>"; } echo "</select>"; $array = array($get_contact); if($contact_id == $c_id){ //if(in_array($contact_id,$array)){ ?> <tr> <td>Contact First Name:</td> <td><input type="text" name="consignee_fname" value="<?php if($fname == ""){echo "No contact details found.";}else {echo $fname;} ?>" size="39" /></td> </tr> <tr> <td>Contact Last Name:</td> <td><input type="text" name="consignee_lname" value="<?php if($lname == ""){echo "No contact details found.";}else {echo $lname;} ?>" size="39"/></td> </tr> <tr> <td>Contact Email Address:</td> <td><input type="text" name="consign_email" value="<?php if($email == ""){echo "No contact details found.";}else {echo $email;} ?>" size="39" /</td> </tr> <tr> <td>Customer Number:</td> <td><input type="text" name="ct_cust_number" value="<?php if($custid == ""){echo "No contact details found.";}else {echo $custid;} ?>" size="39" /><td> </tr> <tr> <td>Contact Telephone:</td> <td><input type="text" name="ct_cust_tel" value="<?php if($tel == ""){echo "No contact details found.";}else {echo $tel;} ?>" size="39" /></td> </tr> <tr> <td> </td> <td><input type="submit" name="consignee_submit" value="Submit" /></td> </tr> <?php } ?> and my object: <?php class Contact { public function get_Contact($cl_number,$contact_id){ if(isset($cl_number)){ $sql = "SELECT * FROM tbl_client_contacts WHERE CUST_ID = '$cl_number' "; echo $sql; $query = mysql_query($sql); while($row = mysql_fetch_array($query)){ $contact[] = $row; } return $contact; }elseif(isset($contact_id)){ $sql = "SELECT * FROM tbl_client_contacts WHERE CUST_ID = (SELECT CUST_ID FROM tbl_client_contacts WHERE ID = '$contact_id' ) "; echo $sql; $query = mysql_query($sql); while($row = mysql_fetch_array($query)){ $contact[] = $row; } return $contact; } } }?> As you can see there is one line "if(in_array)" where I would like to "compare" 2 values, when the 2 values are the same some input fields are shown. How can I do that with a bit the same code? Thanks!

Well I was first thinking of doing that, but since most of the images have or could have a dynamic position I couldn't do it like that. Here is the link so you can check it out: http://www.hy-studio.net/demos/under_construction_page

Hello, I have here a "Under Construction" site that should work in the following browsers: - IE6 - IE7 - IE8 - FF - Safari - Chrome The site is everywhere the same (Mac and Windows), also in IE6 but I'm using a PNG fix for my png files. Here is the problem, locally the PNG fix works but when I upload the files to my hosting server the png fix does not work. This is very strange, it is the very last thing that is blocking my here and I'm out of ideas Anyone? Thanks

Hi Bricktop, thanks for your answer. Will this "keep in mind" that the values of the optgroup and option need to stay "seperated"?

Hello, I have here a select menu and in that I have several optgroups with several options (php loop that prints out the values). What I want to do is getting 2 values from the select menu. I got this code: <select name="reason" onChange="getReason(this.value)"> <option selected>Select a request</option> <?php $sql2 = "SELECT * FROM tbl_group_reason"; $query2 = mysql_query($sql2); while($row2 = mysql_fetch_array($query2)){ $group_id = $row2['ID']; $group_reason = $row2['GROUP_REASON']; echo "<optgroup label=\"$group_reason\" name=\"group_reason\" value=\"$group_id\">"; $sql3 = "SELECT * FROM tbl_reason WHERE GROUP_ID = '$group_id' "; $query3 = mysql_query($sql3); while($row3 = mysql_fetch_array($query3)){ $reason = $row3['REASON']; $reason_id = $row3['REASON_ID']; echo "<option value=\"$reason_id\">".$reason."</option>"; } echo "</optgroup>"; } ?> </select> Getting the value of the <option> isn't a problem, but getting the value of the <optgroup> that I don't know how to do. Anyone? Thanks!

Hello, I have here a little website http://www.hy-studio.net/demos/fancy_portfolio_blog/ that's works fine in IE8, FF, and Safari (the major explorers for which the site must be coded). Now my problem is not the png files in IE6 (I've managed that) but the position of 2 backgrounds in color light green, one is in the top of the content (at the back) and the other on the bottom of the content (also in the back). In IE6 and 7 those 2 images, are moved completely to the right, I don't get why. Anyone knows how to fix this? I could post the code here but it is very long , so feel free to check the source and source css with the FF webdevelopment tool Thanks!

border-image is integrated with CSS3 below it won't work

Hello, I'm a total noob if it comes to Ajax and also javascript, so that's why I come here I have this code: function getSubCat(mainCat) { createXMLHttpRequest(); var params = "titleid="+mainCat; var params = "main_cat="+mainCat; xmlHttp.open("POST", "getSubCat.php", true); xmlHttp.onreadystatechange = done; xmlHttp.setRequestHeader("Content-Type", "application/x-www-form-urlencoded"); xmlHttp.send(params); } code works just fine but it will only take the var "titleid", how can I "post" both vars? Thanks

put a ob_start() on top of your header.php and a ob_flush() on the bottom of the footer.php This should do the job.

I've managed to get this done! here is a sample of what I've done <?php $sql = "SELECT * FROM sub_cat WHERE main_cat = '1' ORDER BY id"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)){ $subcatid = $row['id']; $subcatname = $row['name_genre']; $sql2 = "SELECT * FROM linked WHERE title_id = '1' "; $query2 = mysql_query($sql2); while($row2 = mysql_fetch_array($query2)){ $linkedsubcatid = $row2['sub_cat_id']; $explode = explode(",",$linkedsubcatid); if(in_array($subcatid,$explode)){ echo "<input type=\"checkbox\" checked=\"checked\" />".$subcatname."<br />"; }else{ echo "<input type=\"checkbox\" />".$subcatname." <br />"; } } } ?> and it works like a charm

yeah it's a tricky request that my client demands I was just thinking of using some of my objects from another project, there I had something similar I think. It was also a request which took a more on more relation between tables .. (there should be a good plan for this kind of things), Out of my head like that it was something like tbl_user, tbl_group, tbl_perm (DB was existed already with a few hundred members inside) and my client asked if I could create a page that allows him to edit users, and when he had select a user the exisiting groups and perms etc would be shown on the page (it wasn't checkboxes I think) and he could edit on the fly. Stupid thing is, I don't remember where I've put the files

Hello, I'm trying to do the following: I have a DB with a table with sub categories (let's say there a 10 sub categories in it) and another one that I keep the link between a product and the sub category (tbl name = LINKED). My goal is to allow the user to have possibility to edit the product. So when the user clicks on the 'edit' button next to the products name it will show a page (another page)where he has some input fields and a text area, these input fields and textarea are already completed with the data from the products that he had selected. Now the product can have several sub categories like lets say it's a movie, the movie has as sub categories "romance, comedy, politic " , so I have in my table where a keep the link between product and sub category 3 rows with the title_id and then the sub category. In the page with the input fields I should print out checkboxes with the sub category name, no problem here. But how can I print out that same list but with the checkboxes romance,comedy and politic already checked? So in other words, I have 10 sub categories and the products is linked with 3 of them, I want to print out all 10 and check those 3 sub categories. I was thinking using a loop where I first get the entire list of sub categories, then query the tbl "LINKED" but then I'm stuck :-\

hi, thanks for your reply! it works like this

Hello, I have this object here : class getIDs { function list_MainCat(){ $sql = "SELECT * FROM MAIN_CAT ORDER BY main_cat_id ASC"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)){ $maincat[] = $row['main_cat_id']; $maincat[] = $row['main_cat_name']; } return($maincat); } } this object is in a file called 'core.php'. as you can see there is a loop inside, what I would like to do is to echo out the $maincat in another php file. So I did this in another php file: $listmaincat = new getIDs(); list($maincat_id,$maincat_name) = $listmaincat->list_MainCat(); echo $maincat_id." ".$maincat_name; but of course, it only echoes out 1 record. Anyone knows how I can fix this?

Hi, I have some records that contains a certain value that needs to be deleted. Let me explain: In my database I have a certain amount of records with in one of the columns a or in most cases multiple values. example of some records: header column a | header column b | header column c bla bla bla | more bla bla | 1,2,4,8 this is more bla bla | even more bla bla | 1,5,9,6,2,7 what I want to do is deleted the values '1' and '2' and keep the others, so in other words, I don't want to delete those records, I want keep them and only delete the value '1' and '2', in the first record (header not counted) I should have '4,8' after my query. This I want to accomplish with PHP. I'm thinking using a LEFT JOIN in my query for this?

does this work? echo "<p><a href=\"listPlate.php?Customer_ID=$customerid\">Click here to start selling! </a></p>";

owkay, it works, it was actually that obvious thanks!

sorry, forgot to mention it it is in the root movie

the ones in my sidebar.php? <?php echo "<li class=\"list2\"><a href=\"view_list.php?genre=$name_genre&main_id=$id\">".$name_genre."</a></li>"; ?>

Hi, I have some trouble with including / requiering files. I have this kind of structure in my htdocs folder: - movie - config - admin - lib So the goal is that when my webapp is ready, I will send it to some friends, colleges etc to test, but off course, not everyone will paste my files it in the same location and not everyone that I know works with windows. So let's say in the root folder 'movie' I have 1file containing anchors and so on. in the admin folder I have index.php file, in this one there is a require("../sidebar.php") (sidebar.php in root of movies). in the sidebar there are some echoes like <a href="view_list.php?bla=blabla"> So when I go to http://localhost/movie/admin/index.php I have my anchor that is like this: http://htdocs/movie/admin/view_list.php?bla=blabla . not really correct huh? should be http://movie/view_list.php?bla=blabla., but when I go to for ex: http://localhost/movie/index.php and I put there a require for the sidebar.php the anchor is shown correctly and that's correct Is there a some kind of global variable in php where that you can tell what the root is, or where to "start"?

found it! had to change my collumn properties in DB, it was an INT instead of VARCHAR. also changed a bit the query from : $insert_sql = "INSERT INTO titles(id,title,genre,year,actors) VALUES(NULL,'test title',' ".implode(" ',' ", $array)." ','2009','test actors')"; to: $insert_sql = "INSERT INTO titles(id,title,genre,year,actors) VALUES(NULL,'test title',' ".implode(",", $array)." ','2009','test actors')"; thanks anyway!

Hi, I've tried it like Kickstart told and this works just fine and is less type work So this time it works, I got the ID's like this 1,2 Tried the to insert into another table because the other table will contain more values like year, genre etc ... but it seems that he only inserts the first value (1) <?php require("config.php"); class insert_Title { function implodeId($test){ foreach($test as $name){ $sql = "SELECT * FROM categories WHERE name = '$name' "; $query = mysql_query($sql); $row = mysql_fetch_array($query); $array[] = $row['id']; } $insert_sql = "INSERT INTO titles(id,title,genre,year,actors) VALUES(NULL,'test title',' ".implode(" ',' ", $array)." ','2009','test actors')"; $insert_query = mysql_query($insert_sql); if(!$insert_query){ echo "Failed!"; }else{ echo "Success!"; } } } $test = $_POST['test']; $submit = $_POST['submit']; if(isset($submit)){ $get_id = new insert_Title(); $exec = $get_id->implodeId($test); //$test_implode = implode(",",$test); //echo $test_implode; } ?> <form name="myForm" action="<?php $_SERVER['PHP_SELF'] ?>" method="post"> <input type="checkbox" name="test[]" value="Movies" />Movies<br /> <input type="checkbox" name="test[]" value="Manga" />Manga<br /> <input type="submit" name="submit" value="Go!" /> </form> :-\