เว็บบอร์ด PHP เว็บส่งเสริมการเรียนรู้ Hosting CRM ERP Server Programming ถาม-ตอบปัญหา

phpversion(); 

$con = mysqli_connect("localhost","my_user","my_password","my_db");

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  } 

ปัญหามาจาก เขียนใน php 7 ต้องแก้ไข connect ค่ะ

หรือจะดักด้วยตัวแปล เช็คเวอร์ชั่น php ก่อนก็ได้ค่ะ

[code=php]phpversion(); [/code]

[code=php]$con = mysqli_connect("localhost","my_user","my_password","my_db");

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  } [/code]

JConfig Object ( [offline] => 0 [offline_message] => This site is down for maintenance.
Please check back again soon. [display_offline_message] => 1 [offline_image] => [sitename] => m039mindphp [editor] => tinymce [captcha] => 0 [list_limit] => 20 [access] => 1 [debug] => 0 [debug_lang] => 0 [dbtype] => mysqli [host] => localhost [user] => root [password] => [db] => m039 [dbprefix] => tx4th_ [live_site] => [secret] => mGZ848GMFKFFDiVC [gzip] => 0 [error_reporting] => default [helpurl] => https://help.joomla.org/proxy/index.php?keyref=Help{major}{minor}:{keyref} [ftp_host] => [ftp_port] => [ftp_user] => [ftp_pass] => [ftp_root] => [ftp_enable] => 0 [offset] => UTC [mailonline] => 1 [mailer] => mail [mailfrom] => [email protected] [fromname] => m039mindphp [sendmail] => /usr/sbin/sendmail [smtpauth] => 0 [smtpuser] => [smtppass] => [smtphost] => localhost [smtpsecure] => none [smtpport] => 25 [caching] => 0 [cache_handler] => file [cachetime] => 15 [cache_platformprefix] => 0 [MetaDesc] => m039mindphp [MetaKeys] => [MetaTitle] => 1 [MetaAuthor] => 1 [MetaVersion] => 0 [robots] => [sef] => 1 [sef_rewrite] => 0 [sef_suffix] => 0 [unicodeslugs] => 0 [feed_limit] => 10 [feed_email] => none [log_path] => C:\xampp\htdocs\m039mindphp\administrator/logs [tmp_path] => C:\xampp\htdocs\m039mindphp/tmp [lifetime] => 15 [session_handler] => database )
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\m039mindphp\Ex-1-Form\connect.php:14 Stack trace: #0 C:\xampp\htdocs\m039mindphp\Ex-1-Form\form.php(3): require_once() #1 {main} thrown in C:\xampp\htdocs\m039mindphp\Ex-1-Form\connect.php on line 14

[quote="mindphp"]ลอง print_r($joomlaconfig)
ดูว่ามีค่าจาก Joomla เข้ามาไหมครับ[/quote]

JConfig Object ( [offline] => 0 [offline_message] => This site is down for maintenance.
Please check back again soon. [display_offline_message] => 1 [offline_image] => [sitename] => m039mindphp [editor] => tinymce [captcha] => 0 [list_limit] => 20 [access] => 1 [debug] => 0 [debug_lang] => 0 [dbtype] => mysqli [host] => localhost [user] => root [password] => [db] => m039 [dbprefix] => tx4th_ [live_site] => [secret] => mGZ848GMFKFFDiVC [gzip] => 0 [error_reporting] => default [helpurl] => https://help.joomla.org/proxy/index.php?keyref=Help{major}{minor}:{keyref} [ftp_host] => [ftp_port] => [ftp_user] => [ftp_pass] => [ftp_root] => [ftp_enable] => 0 [offset] => UTC [mailonline] => 1 [mailer] => mail [mailfrom] => [email protected] [fromname] => m039mindphp [sendmail] => /usr/sbin/sendmail [smtpauth] => 0 [smtpuser] => [smtppass] => [smtphost] => localhost [smtpsecure] => none [smtpport] => 25 [caching] => 0 [cache_handler] => file [cachetime] => 15 [cache_platformprefix] => 0 [MetaDesc] => m039mindphp [MetaKeys] => [MetaTitle] => 1 [MetaAuthor] => 1 [MetaVersion] => 0 [robots] => [sef] => 1 [sef_rewrite] => 0 [sef_suffix] => 0 [unicodeslugs] => 0 [feed_limit] => 10 [feed_email] => none [log_path] => C:\xampp\htdocs\m039mindphp\administrator/logs [tmp_path] => C:\xampp\htdocs\m039mindphp/tmp [lifetime] => 15 [session_handler] => database )
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\m039mindphp\Ex-1-Form\connect.php:14 Stack trace: #0 C:\xampp\htdocs\m039mindphp\Ex-1-Form\form.php(3): require_once() #1 {main} thrown in C:\xampp\htdocs\m039mindphp\Ex-1-Form\connect.php on line 14

ลอง print_r($joomlaconfig)
ดูว่ามีค่าจาก Joomla เข้ามาไหมครับ

<?php

require_once '../configuration.php';

$joomlaconfig = new JConfig();

$host = $joomlaconfig->host;
$username = $joomlaconfig->user;
$password = $joomlaconfig->password;
$db = $joomlaconfig->db;

mysql_connect($host, $username, $password) or die('connnect Failed');
mysql_query('set names utf8');
mysql_select_db($db) or die('Select DB Failed');


 ?>

echo $joomlaconfig;

[code]<?php

require_once '../configuration.php';

$joomlaconfig = new JConfig();

$host = $joomlaconfig->host;
$username = $joomlaconfig->user;
$password = $joomlaconfig->password;
$db = $joomlaconfig->db;

mysql_connect($host, $username, $password) or die('connnect Failed');
mysql_query('set names utf8');
mysql_select_db($db) or die('Select DB Failed');


?>
[/code]
[color=#FF0000]
Error[/color]

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\Ex-1-Form\connect.php:12 Stack trace: #0 C:\xampp\htdocs\Ex-1-Form\form.php(3): require_once() #1 {main} thrown in C:\xampp\htdocs\Ex-1-Form\connect.php on line 12

[code]echo $joomlaconfig;[/code]

Recoverable fatal error: Object of class JConfig could not be converted to string in C:\xampp\htdocs\Ex-1-Form\connect.php on line 7