Probleme Wamserver 2.5 and Dreamweaber CS6
Posted by: manyblue (---.Red-88-10-48.dynamicIP.rima-tde.net)
Date: August 22, 2014 10:07AM

Greetings to all.
I worked with Dreamweaber CS6 and wampserver 2.2.
two days ago I decided to upgrade to version 2.5 wamp and I now nothing works.
example
1) Connection file Dreamweaber, conex_db_company.php Connections within the directory:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_conex_db_teldetv = "localhost";
$database_conex_db_teldetv = "db_teldetv";
$username_conex_db_teldetv = "root";
$password_conex_db_teldetv = "";
$conex_db_teldetv = mysql_pconnect($hostname_conex_db_teldetv, $username_conex_db_teldetv, $password_conex_db_teldetv) or trigger_error(mysql_error(),E_USER_ERROR);
?>
2) File index.php
mysql_select_db($database_conex_db_teldetv, $conex_db_teldetv);
$query_ConsultaPlayerPortada = "SELECT * FROM tbl_player_portada";
$ConsultaPlayerPortada = mysql_query($query_ConsultaPlayerPortada, $conex_db_teldetv) or die(mysql_error());
$row_ConsultaPlayerPortada = mysql_fetch_assoc($ConsultaPlayerPortada);
$totalRows_ConsultaPlayerPortada = mysql_num_rows($ConsultaPlayerPortada);

mysql_select_db($database_conex_db_teldetv, $conex_db_teldetv);
$query_ConsultaCategNoticias = "SELECT * FROM tbl_categ_noticias";
$ConsultaCategNoticias = mysql_query($query_ConsultaCategNoticias, $conex_db_teldetv) or die(mysql_error());
$row_ConsultaCategNoticias = mysql_fetch_assoc($ConsultaCategNoticias);
$totalRows_ConsultaCategNoticias = mysql_num_rows($ConsultaCategNoticias);

//Consulta a categoria de noticias para el menu principal
mysql_select_db($database_conex_db_teldetv, $conex_db_teldetv);
$query_ConsultaCategNoticias_2 = "SELECT * FROM tbl_categ_noticias";
$ConsultaCategNoticias_2 = mysql_query($query_ConsultaCategNoticias_2, $conex_db_teldetv) or die(mysql_error());
$row_ConsultaCategNoticias_2 = mysql_fetch_assoc($ConsultaCategNoticias_2);
$totalRows_ConsultaCategNoticias_2 = mysql_num_rows($ConsultaCategNoticias_2);

The last gives me this error:
Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\teldetv_3\Connections\conex_db_teldetv .php on line 22

I have almost finished the website and if I use wamp 2.5 must correct all connections, queries, inserts .......

Must i back to wamp 2.2 for to work with Dreamweaber ??

And other probleme with the DB mysql and the tables from mysql 5.5 to mysql 5.6

Best regards: Manyblue

Options: ReplyQuote
Re: Probleme Wamserver 2.5 and Dreamweaber CS6
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: August 22, 2014 11:20AM

I cannot help saying that making major changes mid project is NEVER A GOOD IDEA, but I guess you now know that!

The error

Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\teldetv_3\Connections\conex_db_teldetv .php on line 22

Is not actually an error it is just a warning, and a useful warning too. It is telling you that the mysql_* functions will soon be removed from the PHP language. So some time in the future, if you want to upgrade PHP to get the latest version with all the latest bug fixes, you are going to have to recode all your database access to use the mysqli_* functions or the PDO functions.


But for now there is a simple amendment you can add to your 'php.ini' to stop it giving this WARNING message.


Edit php.ini ( using the wampmanager menus )

wampmanager -> PHP -> php.ini

Find this line
error_reporting = E_ALL

And change it to

error_reporting = E_ALL & ~E_DEPRECATED

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Probleme Wamserver 2.5 and Dreamweaber CS6
Posted by: manyblue (---.Red-88-10-48.dynamicIP.rima-tde.net)
Date: August 23, 2014 10:06AM

1) Ok but hiding the error is not corrected.
2) The proble is not from Wamp is from Adobe Dreamweaber, There is a solution for the new versions php and mysql:
[www.webassist.com]
I think i will made the code at hand with mysqli.
Best regards: Manyblue

Options: ReplyQuote
Re: Probleme Wamserver 2.5 and Dreamweaber CS6
Posted by: manyblue (---.Red-88-10-48.dynamicIP.rima-tde.net)
Date: August 23, 2014 10:09AM

PD: My actual proyect is big and if i use the new mysqli i must correct all bufffffffffff very long for that i finish this proyect with mysql no mysqli but my next proyect, over the table now, will be diferent with mysqli.
Best regards: Manyblue

Options: ReplyQuote


Sorry, only registered users may post in this forum.