benanamen

Should you decide to outsource, I am available. I am a Senior Software Engineer with over thirty years experience. Just send me a message if you want to discuss your project. @rproffitt gave you very sound advice on drawing up specs. Whether in house or outsourced, you need a blueprint …

Tables for layout went out in the 90's. We use CSS now.

Look up "Database Normalization" and then apply what you learned.

This thread is TEN YEARS OLD. The OP is long gone.

Feel free to ask a question.

While not a bad idea to do the second clean install the upgrade is smart enough to put all the "crap" in a folder called windows.old which has everything from the previous version which is why you are able to roll back. All you really have to do is delete …

Didnt you like the answers on all the other forums you cross posted on?

As you have been told by many on the other forum you crossposted on, you need to fix your Database before you do anything.

> some error appears everytime It would have helped if you would have told us exactly what the error is. We dont have magic Crystal Balls.

The answer is simple. You just need to disable the foreign key checks first, run your querys, then turn the foreign key checks back on. SET FOREIGN_KEY_CHECKS=0; //Run Querys SET FOREIGN_KEY_CHECKS=1;

>I'm creating an online learning courseware using PHP 5.5 Why? Php 5.5 has already reached end of life and is no longer supported. [Click Here](http://php.net/supported-versions.php)

I only did a quick read through, but have you considered cloning your drive and then attempting whatever on the clone?

Writing a proper query would be helpful. INSERT INTO table2 SELECT * FROM table1 https://dev.mysql.com/doc/refman/5.7/en/insert-select.html

You have bigger problems to worry about. You are using obsolete, dangerous code that has been completetly removed from Php. You need to use PDO with Prepared Statements. [PDO Tutorial](https://phpdelusions.net/pdo)

You first need to start with code that is not dangerous and obsolete and removed from Php. Start with this tutorial [Click Here](https://phpdelusions.net/pdo) Where ever you are learning that code from, toss it!

You dont do anything with the result so of course it is blank.

Your DB design is incorrect. You need to learn about *Database Normalization*.

Your letting the user create their own ID?

There are numerous issues with your code. You need to check the request method. Depending on the name of a button being submitted in order for your script to work will completetly fail in certain cases. Get rid of the try/catch blocks. Php is perfectly capable of handling errors. Do …

For starters, you are using dangerous obsolete code that has been completetly removed from Php. You need to use PDO. [Click Here](https://phpdelusions.net/pdo) Second, that "code" is not going to do anything. You dont even have variables where you should have them. Additionally, the "logic" just makes no sense at all.

Being that their own server has numerous basic security issues and is vulnerable to a Clickjacking Attack, I would stay away from them.

This is a very poorly written and insecure script that is vulnerable to SQL Injection. Before you start adding new features you need to fix the script. There are numerous problems with it. You need to use Prepared Statements. I suggest you use [PDO](https://phpdelusions.net/pdo). Do not output internal errors to …

You are using obsolete and dangerous code that has been completetly removed from Php. You need to use PDO with prepared statements. [PDO Tutorial](https://phpdelusions.net/pdo) Never ever put variables in a query. Do not output internal system messages the user. That info is only good to hackers. Having the test id …

@sriram_2, you revived a SIX YEAR OLD thread to post severely flawed and **VERY DANGEROUS CODE**? I am not even going to get into everything wrong with what you posted. You need to do a lot more learning before you post a wall of code to "help".

Just to be more precise, it is not a "one way encrypted password" but a "one-way hashing algorithm using "[password_hash](http://php.net/manual/en/function.password-hash.php). Per the manual: > password_hash() creates a new password hash using a strong one-way hashing algorithm. You would then use [password_verify](http://php.net/manual/en/function.password-verify.php) to "Verify that the given hash matches the given …

I also have no idea what you want. Rather than talk about your attempt at solving the problem, explain to us the big picture of what you are doing,

You do realize that anyone can delete your entire database as written right?