39,323 Topics
| |
this is my table structure [CODE]CREATE TABLE IF NOT EXISTS `test` ( `id` int(11) DEFAULT NULL, `disable` timestamp NULL DEFAULT NULL, UNIQUE KEY `id` (`id`,`disable`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;[/CODE] Assume values as [CODE]INSERT INTO `test` (`id`, `disable`) VALUES (1, NULL), (2, '2010-07-27 15:52:20'), (3, '2010-08-03 00:00:00'), (5, '2010-07-28 15:53:39'), … | |
hi all, i had a page in which list of images can be seen by selecting some date. so now in that table i am having a dropdown of users. so if i select a user and click submit that username, imagename,size,type should be stored in database,but i cant store … | |
Hello, I'm trying to build a list of categories and I don't want to overflow my tables, so I was wondering if anyone has a code that will allow users to click on a link and a pop up will show the rest of the list. I would like the … | |
Hi, I am trying to build a MCQ website. One question set will have around 50 questions, each shown in a different page I need to put a countodown timer which will work across all the questions any suggestions please | |
Hi there, I couldn't find a solution to this small problem so posting it here. I have some hardcoded values I want to send back to the browser. When I have this code: [code=php] ... $cr1 = '{"date_added":"8/3","type":"1","contact":"John Smith"}'; $cr2 = '{"date_added":"8/7","type":"2","contact":"Jane Smith"}'; $company_reqs[0] = json_decode($cr1,1); $company_reqs[1] = json_decode($cr2,1); $company_data['reqs'] … | |
Dear Friends, Please help me with this issue. the design of my database isnt well normalized, but due to the ammount of work done based on this queries i found it more difficult to have to change the whole design . Instead im trying just to solve it. i have … | |
Now, knowing I'm fairly new on this whole PHP, MySQL, and HTML project. I'm working as an intern and my boss has run out of things for me to do so I'm creating a data driven website for him. I'm having a hard time with getting to work right. Here … | |
this snippet is to create random passwords with a chosen length and a specified number of numbers. Uses both lower case and capital letters, which are chosen at random. And example is: wep5Q268LtTe. [B][U]How to use.[/U][/B] Using this is very easy just add to the appropriate page and call the … | |
Hi all, I have a big problem. I am very new to php and sql and I need to create a login web page page for access to a database I have created in mySQL. I have located a script online here: [url]http://php.about.com/od/finishedphp1/ss/php_login_code.htm[/url] that basically explains the entire process. My … | |
Hi all, 3 tables : one events table (each event can have differents types) one types table (each type can have differents events) and one liaison table (link between events and types tables) I have some problems when I show screen. [code=php] <select name="type[]" size="10" multiple="multiple"> <?php $req_type = "SELECT … | |
I don't know if there is something unstable about using $_SESSION variables or not, but I've written user management scripts for my website, most of the time everything works okay but sometimes my server goes off on it's own and I can't load any pages on my server until I … | |
Hi, I am interested in starting a small price comaprison website in my local area. The site should compare prices from 20 suppliers, selling an identical product in 4 different quantities and some suppliers only deliver to certain post/zip codes. What would be the best way to set up this … | |
Hi, I am getting an 500 internal server error when using the redirection code in my HTACCESS file.Given is the code i am using: RewriteEngine On rewritecond %{http_host} ^domain.com rewriterule ^(.*)$ http://www.domain.com$1 [r=301,L] I also have already following lines of code in my htaccess file: # -FrontPage- IndexIgnore .htaccess */.?* … | |
Hi everyone This is my first post here and it would be great if someone could help me with this small problem. I have a PHP script which inserts form data into a MySQL database. But clicking on the Submit button produces the following error:- [COLOR="red"]Database ERROR: You have an … | |
Hi, I have a bunch of uploaded files in a folder. Now I want to be able to get the names of these files that are stored in the folder using PHP so that can I create direct links to each file from my page. ie can PHP read the … | |
Hi, how can I get "2" with Url using CI, I try $this->uri->segment() but it doesn't work. [code] http://127.0.0.1/~nertos/index.php/website/search?search=abc+xyz/2 [/code] Any ideas? | |
Hello people, On my site i am using a .htaccess file with a simple rewrite rule: [code] Options +FollowSymLinks RewriteEngine on RewriteRule ^servers/(.*)/ index.php?action=servers&id=$1 [/code] Allowing visitors of my site to use [url]www.example.com/servers/1/[/url] - which will grab and display the correct page from [url]www.example.com/index.php?action=servers&id=1[/url] In the index.php file, there are … | |
Hi everybody, I don't understand waht does bigint(20)in MySql means. First I thought bigint(20) means number from 0 to 99999999999999999999 digits, but I made a test with bigint(2). I thought bigint(2)=number from 0 to 99, but it's not. Did you know anybody? I'll be happy to know. Thank you :) | |
hi guys, pls can someone pls help look into this code.. i'm trying to create a code that will add data into the database.. after inputing, its giving me the "ERROR: Please fill in all required fields!" error [CODE]<?php /* NEW.PHP Allows user to create a new entry in the … | |
Hi all I am in need to of some help. As I just sorted out a loging scritp to. I can't seem to add a downloading counter within the members page. So say for example after when the user logs and then wants to view the speacial page the download … | |
Hi everyone. Could some assist me? I have a link. [code] <a href="index.php?make=<?=$mead_make?>&model=<?=$model?>&veh_id=<?=$vehicle_id?>">Add to Cart</a> [/code] This HREF link is generated by a for loop from a mysql DB. All I want to do is add the veh_id to a array and keep adding them to a array until I … | |
Hi all, Here is my htaccess code for url rewrite: [CODE] RewriteRule ^(.*)/test.php$ test.php?language=$1 [NC] [/CODE] which will redirect [url]www.domain.com/english/test.php[/url] to [url]www.domain.com/test.php?language=english[/url] It is working fine... But when i have extra variable with that url then it doesn't work. e.g. [url]www.domain.com/english/test.php?name=abc[/url] should work like: [url]www.domain.com/test.php?language=english&name=abc[/url] But it is not working.. … | |
Hello, I am currently developing a review site that requires displaying video reviews. I have created a PHP page that successfully retrieves all records from my video database called reviews.php. I have also created a page that a user gets redirected to when he/she selects a video entitled watch.php. The … | |
Hi there, here is my code and I don't know how to add <br /> to get a return in the email received: [CODE]<?php $to = "myemail@gmail.com"; $subject = "From the website"; $email = $_REQUEST['email'] ; $yname = $_REQUEST['name'] ; $ycompany = $_REQUEST['company'] ; $yphone = $_REQUEST['phone'] ; $ymessage = … | |
I don't know where to start so I just got to ask from the experts :). From my MySQL (database) I got a date formatted mm-dd-yyyy (i.e. 01/01/2010), now from my php page there are 3 dropdown/list menus which are for [B][Month]-[Day]-[Year][/B] and a [B][TextField][/B] then a [B][Submit Button][/B]. When … | |
hi, i have to write a program that simulates a vending machine: the sale of items,coin counting and change giving. can some1 help??? | |
Hello, Here is my problem: I have copied a web site onto my development server. All the images and files are called using absolute paths, for example: <img src="/images/picture.jpg" /> So it's trying to do this: [url]http://www.localhost.com/images/pictures.jpg[/url] When I want it is actually suppose to do this: [url]http://www.localhost.com/client/folder/images/pictures.jpg[/url] How do … | |
$ct is my array: array(4) { ["a"]=> int(1) ["b"]=> int(2) ["z"]=> int(2) ["c"]=> int(1) } I need to put it in a two column database where "item" is col1 and "count" is col2 where the first row has an "a" in col1 and 1 in col2, 2nd row has a … | |
Hello! I have been searching for a good solution all morning but can't seem to get one! I'm trying to create a form that sends to a different set of email addresses based on what is selected in a drop down menu. While I can make this happen, I need … |
The End.