1

Hello today I was working on a php script that when ran on the browser would create tables in mysql but it is not working properly.

I am using xampp with MariaDB 10.1.21 and PHp version 7.1.1

<?php

$server = "127.0.0.1";
$username = "root";
$password = "";
$database = "****";

$connId = mysql_connect($server,$username,$password) or die("Cannot connect to server");
$selectDb = mysql_select_db ($database,$connId) or die("Cannot connect to database"); 

$result = "CREATE TABLE track(
`id` int(6) NOT NULL auto_increment,
`tm` varchar(20) NOT NULL default '',
`ref` varchar(250) NOT NULL default '',
`agent` varchar(250) NOT NULL default '',
`ip` varchar(20) NOT NULL default '',
`ip_value` int(11) NOT NULL default '0',
`domain` varchar(20) NOT NULL default '',
`tracking_page_name` varchar(10) NOT NULL default '',
 UNIQUE KEY `id` (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 "; 

if (mysql_query($result))
{
 print "Success in TABLE creation!......";
} 
else 
{
die('MSSQL error: ' . mssql_get_last_message());
}


?>'

And it is giving me this error Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\fix\create_table_track.php:8 Stack trace: #0 {main} thrown in C:\xampp\htdocs\fix\create_table_track.php on line 8

Nixdorn
  • 11
  • 1

0 Answers0