LethargicCoder

What I have right now is the category name is put up in the url like so subcategory.php?id=Drivers that way i can use that get variable to query the database and list all the entried from that database on the page. What I need to do though is limit how …

Basically I'm trying to get the post data from my form page to link back to my php page and it won't post for whatever reason. I've been scrutinizing my code and looking online at other posts but have had no luck. My html form: <form id="form1" name="form1" method="post" action="anthonyBook.php"> …

I have been given a database whose content I can't modify. Everything has been going fine until I was passing some variables in a URL through a link, and an apostrophe in one of the variables (i.e "Frank's Used Cars") is causing the variables behind it to not be passed. …

Hi, Im using session variables and when passing from one page to another with a target="_top" the session variables are erased. Is there anyway i can go around this problem ? Any idea will be greatly appreciated. Thank you

Hi all, I was wondering if it is a common thing to do when requesting variables to have the request names in an array and use a for loop to request the submitted variables. (will it hold the values if its a for loop?) What i have at present is …

I have four database tables locality table: localityid, locality. jobtype table: typeid, type. applywork table: id, userid, applyfor applicationsent, jobtypeid, vacancyseenon companyname, doorno buildingname, street, localityid, postcode, telephone, website, email, notes users: id, role, name, surname, gender, username, password. I have a page to edit selected field from applywork. I …

Hi guys, im trying to upload files to my script and have hit an anoying problem. if the file is bigger than what I allow in in my php.ini config, the $_POST and $_FILE comes through empty - and I cant check that there's been a post to then check …

Hi all, I'm working on a webpage with 2 dropdown menu and a submit button. both the dropdown menu has a default value="" selected. I am trying to figure out a way to filter mysql query. Here is the drop down menu <form action="showJobs.php" method="post"> <select name="Locations"> <option value="" selected="selected">All …

Hey guys, I have this code which grabs categories from my category table of the database and populates the category drop-down box. I was hoping someone could tell me how I could populate the second drop-down box depending on what was selected in the first box. E.g. If "Networking" is …

hey all. I am trying to do validation via PHP for submitted forms. Below is my own code, please comment if its the correct method or not. However, I tried so many ways to have the /n or /r added, but I cant get to it. Its just to make …

I am developing a web page which retrieve data from a seperate mysql server on the same network musql_connect('192.16.1.2:3306', 'root', '123'); but ana error shows Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '192.16.1.2' (13) in /var/www/html/index.php on line 3 the 2 servers are on 2 different virtual network …

HI, I have a script which reads an xml feed then uses a loop to insert information from that feed into a multi-dimensional array. I need to sort the array by 'day' before outputting, day is a dimension of the array. Below is a print_r() of the array after the …

Okay first of I want to apologize for the horrible title, I really couldn't come up with a decent title to be honest. Here's my problem, I am kind of new to all this but I'd like to try making (just for fun of course) a database. I have a …

hello. i have a code that looks like this: [CODE]$localdir = 'C:/somedir'; $dh = opendir($localdir); echo '<table><form method="post" action=""><input type="submit" value="Add checked" name="doneA" />'; while(($files = readdir($dh)) != false) { if ($files != "." && $files != "..") { echo '<tr><td><input type="checkbox" name="' . $files . '" /></td><td>' . $files …

Somebody please help with this code. I have been tryin to calculate and display the total of the total output from an oracle database. Please see my code below and kindly tell how i can display the total. <?php $conn = oci_connect("Username", "pwd", "IP/tns"); $date=date('d M Y'); $total= oci_parse($conn, "select …

The code: [CODE = php] $selecteddate = $_POST['Releasedate']; $selectedplatform =$_POST['Platform']; $selectedstyle = $_POST['style']; $query="SELECT * FROM $table WHERE date = '$selecteddate'AND Style = '$selectedstyle'AND Platform = '$selectedplatform'"; [/CODE] Ok, the code works if someone picks something for all 3 of the items, so all of the code works, but if …

In 2dys code, m trying best for updating values on the basis of id coumn value but its not updating... thn i tried to target data using select command.. nd it shws d result thr4 now m confused wth update command... plss chkout ths code as well... [CODE]<?php $host="localhost"; $username="root"; …

I hope you can help. I have a program using 2 pages (main.php and resize_image.php) fragments shown below. Each script works fine independenly of each other. My problem comes when I want to pass a value held on my database held in $story[picture] to resize_image.php..... It simply will not transfer …

Hello, I have a sql database which contains the names and descriptions of a product and the price. However, all products have a starting price of 5 and then the value of the product itself is added. THey also have a multiplier. eg. if a price is 210.13 dollars, the …

I have just become involved with PHP. I am running Vista with IIS7 and PHP 5.2.13. The installation was done via the Windows Web Installer and after a few issues I believe it now working. My initial question is one of basic environmental understanding by this I mean all the …

This error comes for mismatch use of parenthesis but i didn't succeed in tracking it Running this code, i am getting unexpected $end error kindly track the error and let me know with the required change code..... [CODE]<?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password …

OK I have made a little progress and now face something else. I will paste my code here. OK here goes. I am loading a php page from another page by clicking on a table row. This table is filled with data from mysql. When i click on a row …

Ok guys, I've kind of got this file half way working, but I get this message: [B]Notice: Undefined index:[/B] uploadedfile on line whatever. along with this: The file has been uploaded. which is the good part. But I don't understand why I always get those undefined errors. [CODE]$uploaded_size =''; $uploaded_type …

here i dont understand what does this function do. any can explain it to me thanks beforehands [CODE]function query($qry) { if(!isset($this->database_link)) $this->connect(); $result = mysql_query($qry, $this->database_link) or die("Error: ". mysql_error()); $returnArray = array(); $i=0; while ($row = mysql_fetch_array($result, MYSQL_BOTH)) if ($row) $returnArray[$i++]=$row; mysql_free_result($result); return $returnArray; } } [/CODE]

Could someone help me with this - I've cracked my head since. When i submit a form and then retrieve the data, there is no paragraphs. Yes I am aware of HTML encoders like TINYMCE but I'd like to submit in plain text. I tried htmlentities and htmlspecialchars but nothing …

Hi I'm just trying to input two string variables into 2 fields of a database that are VarChars. [CODE] $name = "jear"; $pass = "jartt2"; $query = 'INSERT INTO `user` (`id`, `name`, `password`, `char_name`) VALUES (NULL, '$name', '$pass', 'test')'; $result = mysql_query($query); [/CODE] This is the snippet of code that …

This is my code, as seen here: [url]http://pcafansa6.hosticks.com/episode1.php[/url] [CODE]<?php /*********************************** * PhpMyCoder Paginator * * Created By PhpMyCoder * * 2010 PhpMyCoder * * ------------------------------- * * You may use this code as long * * as this notice stays intact and * * the proper credit is given to …

Hi everyone, Ok, what I want to do is display a url that's stored in my database within an iframe when the specific record is selected. The code I had to display the record correctly is: [code] <?php $conn = mysql_connect(HOST,USER,PASS); $db = mysql_select_db("***") or die( "Unable to select database"); …

Hey team, I want to know how I should go about re-ordering records sent from a db table - but I want to order the data in a custom manner, i.e. allowing a user to change the position of the records. I have a table (for example sakes lets call …

Hi Does Anyone know how to display a table based on user selected fields? In my search box, once the user searches lets say all the female students, all the female students will show with all the fields of that particular table. then if need to print a report i …