Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

3 Neutral

About princesohrab

  • Rank

Profile Information

  • Location
  • Interests
    Web Design, Graphic Design, Photography
  1. it works now.. Ive figured it out..It was to do with setting the keys..Im very new to this.. sorry to be a pain guys
  2. Ok thanks.. Where do I put this mysqli_error() to get the error message?
  3. Hi Birbal,In my table called "people" I created through MySql,I have 3 columns:peopleid (auto increment)firstnamelastname which one should be primary key? At the moment,peopleid and firstname fields are as primary key. Im trying to set only the peopleid as primary but for some reason it wont let me.
  4. Oh, I get the error message which I echoed in the statement.. Error inserting new record but only if there's one entry saved on the database already..
  5. I have created the table with 3 columns..peopleidfirstnamelastnameI believe I have them all as primary key.. (I'm not home, on the way to work)Which one should be primary key?Only peopleid?? peopleid is auto increment and was defined as medium integer..The code seems fine.. I think it's to do with the structure if the table..I'm not sure..I will reset a table and please let me know which one to use as primary.Thanks
  6. Hi all,Im am trying to use a web form to send data to a table called "people" in my database using php.The script store the first time you submit the for and the data goes to the correct table too. The problem is it only allows you to do it only once meaning only 1 entry is registrered. If I try again, I get error message. Then i delete the entry from the database, I refresh the form, send again and it registers. I just need to know how to make it register more than one person's details. Below is the code <?phpif (isset($_POST['submitted'])) {include('w-hill-reg-form-database-connect.php')
  7. I just had to put the define host first
  8. Hey sorry guys.. Ive done itthanks
  9. hi all, wondering if you would be able to help me..im trying to connect to my database but i keep getting the error message which i echo in the page <?php DEFINE('DB_USER', 'ok');DEFINE('DB_PASSWORD', 'ok');DEFINE('DB_HOST', 'ok.com.mysql');DEFINE('DB_NAME', 'o_co');$dbconnect = mysql_connect(DB_USER, DB_PASSWORD, DB_HOST, DB_NAME);if (!$dbconnect) {die('Error connecting to the database');} echo 'You have connected successfully';?>
  10. The one thing Im lost on is creating the CSV file..Does that file stay opn the server? Do I create it with Excel? Then how to link the 2 together?
  11. Thanks.. Appreciate it..I will do it step by step and if I get stuck, Ill get back to you.I found a few tutorials and hopefully Ill get my head around it.Thanks
  12. That is exacly what needs to be done.. But I am more of a front end guy..Im not too sure how to proceed about it.Your help is greatly appreciated. I found this tutorial Not sure if its the same thing..I really need to figure this out.
  13. Hi all,Online registration form which allow users to fill in their details and send the data by submitting the form to my email using php.I need to create an online registration form and when the form is submitted, the data needs to go in to a spreadsheet in (MS EXCEL). Maybe a database I guess..The data should be able to be accessed at any time and read by a spreadsheet by someone in the office. Someone sent me this code $df = fopen("php://output", 'w'); fputcsv($df, array_keys(reset($array))); foreach ($_POSTas $row) { fputcsv($df, $row); } fclose($df); Can anyone help me as to
  14. ok.. I want it to write to an XLS file. How do i set up that file on the server andWhat are the functions on the PHP file?Have you got an example please? Im in real trouble as I need to get that done by tomorrow morning. this task is part of a recruitment process. Basically they told me: (Set up an “apply online” functionality – so that the person who review the data can get all the information he needs to get a team together. This should be provided on an excel spreadsheet) They also said: (It is not useful for members of the management team to receive emails every time someone applies in th
  • Create New...