- PC Specs
- Ubuntu 13.10 Dual core nothing fancy
30 Posted Topics
 | Hi guys, I have the following code that I just cannot get to work! Can you please let me know where I have gone wrong? <?php //db_connect.php $con=mysqli_connect("localhost","root","password","database"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } function get_file_extension($file_name) { return end(explode('.',$file_name)); } function errors($error){ if …  |
| | Hi guys, I really need some help here. I have been tasked to do a secure login system for the charities website. I have been looking on the web, and sure there are a multitude of examples out there. But my problem is the police, ambulance, NHS, etc are going …  |
 | You are giving it a value and not referring to the database. Cycle through the database and put the values into strings and then call those strings in your code.  |
| | Hi guys, OK, here is the issue I am having. Perform a search and when you click the submit button, it takes you to the page that displays the info. Now, when the user clicks the back button on the browser it tries to re-submit the info. I don't want …  |
| | Hi guys, Got a problem uploading an image to a directory and then including that directory location into the database so that I can display the image. Here is the code I have so far. <div id="main_right"> <?php if ($picture) { ?> <img src="<?php echo "../images/teacher_photo/" . $picture ?>" alt="<?php …  |
| | Me again, I have the following which should generate a form and populate that form. <?php session_start(); include("db_connect.php"); if(($_SESSION['user_id']) && ($_SESSION['access_level'] == 1 )) { ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <head> <title>Teaching Int Limited - Home</title> <meta name="title" content="Teaching Int Limited"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta … |
| | Hey guys, me again. OK, I have this form that gets and populates the select boxes with the necessary info. Now, what I would like to do is to take the id field of the select box and use that to do a select query on the relevant table. So … |
| | Can never seem to get things to work! <?php if(isset($_POST['add'])) { $person_id = $_POST['person_id']; if (isset($_POST["cv"])) { $cv=1; } else { $cv=0; } if (isset($_POST["document_id"])) { $document_id=1; } else { $document_id=0; } if (isset($_POST["application_form"])) { $application_form=1; } else { $application_form=0; } if (isset($_POST["passport"])) { $passport=1; } else { $passport=0; } … |
| | Hey guys, the code below is where I am having the problem. The error I am getting when trying to insert the record is *Could not enter data: Unknown column '3' in 'field list'* <?php session_start(); include("db_connect.php"); if(($_SESSION['user_id']) && ($_SESSION['access_level'] == 1 ) ) { ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD … |
| | Hi all, I have a table which holds 130 companies and their related details. I have done the code to insert the information into the table when new companies come along. But now I need to display the existing information. I am looking at doing it using a form for … |
| | Hi guys, back again! OK, this is what I am sitting with now. I have to select a person from the database and in the select box display their first, middle, and last names. The data returned should be the fields id to insert into the foreign key id of … |
| | I am trying to populate a select box from my database. The value chosen must be the id of the item, and the text shown the name of the item so that once selected it will insert the id into the table column and not the name so that the …  |
| | Hi guys, I have a mysql database with many tables. Instead of creating a page each to enter info into the relevant tables, is it possible to have a form created dynamically depending on what table I want to insert information into? Database has 20 tables in it at present, … |
 | CREATE TABLE teacher ( teacher_id INT NOT NULL AUTO_INCREMENT, course_id INT NOT NULL, first_name VARCHAR(100) NOT NULL, middle_name VARCHAR(100) NULL, last_name VARCHAR(100) NULL, FOREIGN KEY (course_id) REFERENCES course(course_id), PRIMARY KEY (teacher_id) ) CREATE TABLE category ( category_id INT NOT NULL AUTO_INCREMENT, category_id VARCHAR(100) NOT NULL, PRIMARY KEY (category_id) ) CREATE … |
| | I have got this code from an article on secure login systems. I know basically nothing about php so I would like to know if this is good code to use? Part 1 of 8: Configure Your Server 1. 1 Install a Web Server, PHP and MySQL on your server. … |
| | Hi guys, I don't know if this is posted in the correct area, so forgive me if it isn't but I couldn't find a proper area for this. What I would like to know is this. I have a computer running windows 7 professional. Connected to my home hub, I … |
| | This has got me very confused. Here is the code but it is not doing what it should do!! echo "<span class='vehicle_table_normal'>";$str_bodystyle=str_replace("," ,"<br />",$bodystyle);$str_bodystyle=str_replace("-" ,"- ",$bodystyle);$str_bodystyle=str_replace(" - " ," - ",$bodystyle);echo $str_bodystyle; The first replace is the most important for display purposes at this moment. The next two are because … |
| | Hi all, I am retrieving information from a database and need to have that information put onto a new line (<br>) depending on the location of the comma which seperates the different areas of the information. Here is what is being retrieved *2.25 L 75 hp (56 kW) I4 petrol … |
| | Hi again guys, I am getting information from a table that I would dearly love to format using my css styles in an external css sheet. Now I am calling the sheet in the header correctly, tested that to make sure. Here is the code I am using. This generates … |
| | pritaeas, can't he do a database search for the value he wants, and then put that value in a session variable, open a new page and using the session value, do what has to be done? |
| | Hi guys, OK, here is what I have in mind. I have to be able to edit membership information, so I propose populating a form with the relevant information. But, I would like to populate the form depending on what member is chosen using a select box. Now, the form …  |
| | Hi all, I realise that this has been asked probably many times. I have searched but have not been able to find the relative answer - most likely not searching properly?? Anyway, what I would like to do is to display multiple images relating to one topic, ie. One member … |
| | Can you access the mysql database on the local server? If so, then just adjust the code on the html site to point to that database. Get the server dude at your college to give you / your site the necessary permissions and let you know what they are. |
| | SELECT studentid, name, contact_number FROM student order by studentid Connect to your database and run the query. I take it that each record in your database has a unique key and that that key is studentid. if so, then you should not get any duplicates. Is something like this what … |
| | Hi all, Here is all my code for processing a form. Having trouble with the last else statement. The error is saying it is not expecting that last else!! Sorry for all the code, but I thought I would put it all in here. Could somebody please let me know … |
| | Hi all, I have a table with quite a bit of columns in it. Nothing stored there yet, but will be soon. What I need to do is populate a drop down list with the first name and last name of the people in the table and also the unique … |
| | Hi all, I have a login system for the site. My problem is I am very new to php and battling to understand this. What I want to do is only accept logins from people that have emails from a certain domain. Here is the code I have at the … |
| | Hi all, I have a small problem. I need to be able to help the members of the organisation I belong to setup their email accounts. Now, I am at the best 2 1/2 hours drive away from them, so I can't drive there everytime somebody wants to setup an … |
| | Hi all, Did a site for a group I belong to. Now they want me to add a login page that would take people to a members only area. Need to be able to validate the users via a database. The only database I have available to me is Access …  |
| | Hi guys, I need to put the results of a query to an acces database onto a word document. now the query is driven by user choices so it might return one record or it might return over 300 records or then again, nothing at all. but if there is …  |
The End.