can i use both mysqli for form input and mysql for showing data using old cs6?

[iamdpk]

hello guys , i m working on a project i m using mysqli in that, but have used only mysqli for form inputs like login or reg. now i m creating pages to show only data using recordset, so my question is " is it still secure? " .

[BenPleysier]

There will be no change in security, keeping in mind that PHP<7/MySQL is less secure than PHP>5/MySQLi

[osgood_]

iamdpk  wrote

hello guys , i m working on a project i m using mysqli in that, but have used only mysqli for form inputs like login or reg. now i m creating pages to show only data using recordset, so my question is " is it still secure? " .

I would not worry about security too much, but the question is why are you using mysqli for login and register pages and mysql for getting data on your other pages, doesnt seem like good forward planning to me.

Youve obviously had to write your own code solution for the login and registration pages using mysqli so why not do the same for the other pages, rather than use the outdated DW server behaviours.

Just be aware you can't mix and match mysqli and sqli on the same page but you should by now not be even considering  using mysql

[iamdpk]

dude,i can understand what u r trying to tell me.... i m helpless . i  also wanted to use sqli  but don't have any option. i don't know coding that much and also don't have time to learn advance coding, server behaviours can help me for getting required data from multiple table with paging and other stuffs.... if u have any better suggestion from which i can use sqli simply or convert my dw sb code in sqli then i ll be very thankfull to u

[Nancy OShea · Accepted solution]

WebAssist has a commerical MySQLi extension to replace the deprecated server behaviors in DW.

MySQLi Server Behaviors | Dreamweaver extension | WebAssist

[iamdpk]

sorry i forgot to mention that i m a very poor boy who can't afford net bills and that thing is really costly... in my country currency

[Nancy OShea]

OK.  So you can't code.  You can't pay for extensions to help you code.  And I assume you can't afford to hire a coder to help you.  So why are you doing this project? 

[iamdpk]

that's a really really gOod question!

[pziecina]

Do not use Dw's server behaviours, unless you know how not to use the php connection scripts Dw creates.

The main reason the old mysql was dropped and no longer supported by both Dw and php itself, is because the password function used by the mysql extension was insecure, and php could not fix the problem without backwards compatibility problems.

The password function was used by every page that contained Dw server behaviours.