Connecting & Displaying Database on Website: XAMPP, Fatal Error, MySQL, Apache, strona.php

Question

Hello I got a job at school to create a database and display it on the website. I made the database but trying to display it on the website I can't connect. Apache and Mysql are enabled. The error that is displayed to me Fatal error: Uncaught Error: Call to undefined function mysql_connect...

arnoldziq · Accepted Answer

And so:
Execution of the inquiry:

Log in, to see the code

in phpAdmin it returns correctly.

However, as I suspected; calling the script with the same query displays the following message:

PHP wrote:
Query Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?y, id_klienta, id_towaru, ilo??, data from `Sprzedaż?` at line 1

Which means exactly what I wrote a few posts earlier; Polish letters in the names of variables, arrays, fields, etc. is not a good idea: /
Code used:

Log in, to see the code

However, the use of a code that avoids the use of Polish characters in the query;

Log in, to see the code

gives a good effect in my opinion:

adamz74 · Answer

MySQL databases are not enabled in PHP. There can be several reasons, the most common:
- php_mysql.dl and libmysql.dll libraries missing or unavailable (wrong path in php.ini - extension_dir = "C: \ PHP \ ext"),
- commented line in php.ini - extension = php_mysql.dll

https://www.youtube.com/watch?v=hcVI83ymuWg

Greetings!

hubert85 · Answer

The same error is still there

arnoldziq · Answer

I suggest you run PHPInfo from Xampp and check if and what MySQL support is installed. Among other things, something like this should be 'shown':

Anonymous · Answer

Well, you connected to the database, but you forgot that there is still a password! In XAMPIe you will not connect without a password.

adamz74 · Answer

One more thing ... from PHP 5.5.0, mysql_connect () is considered obsolete and probably has been removed since version 7.0.0. You can use mysqli instead

hubert85 · Answer

I changed xampp to an older version and now I get this error Code: text Expand Select all Copy to clipboardWarning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\strona.php on line 6 code same as above

arnoldziq · Answer

I suggest using a code like this:

Log in, to see the code

Another observation; I do not know how my colleague has set the database engine, but the use of Polish characters in the names of tables / record fields is not always properly supported. Maybe there is a problem here.

hubert85 · Answer

Now such a problem comes up Code: text Expand Select all Copy to clipboardNotice: Undefined variable: polaczenie in C:\xampp\htdocs\stronaa.php on line 5 Warning: mysql_query() expects parameter 2 to be resource, null given in C:\xampp\htdocs\stronaa.php on line 5 Blad zapytania:

adamz74 · Answer

Undefined variable $ connection. mysql_query () expects the resource id as the 2nd parameter. In this case, it means you have a typo in the variables you are using. $ connection != $ connection

hubert85 · Answer

it doesn't go with the other variable either and it's the same Error

arnoldziq · Answer

I suggest my colleague paste here exactly the code that my colleague is currently using. Because such comments do not bring anything new to the discussion. BTW: Sorry for the typo. You know; autism, dyslexia, dysorthography

hubert85 · Answer

Code: PHPLog in, to see the code In the attachment I am adding the database file

hubert85 · Answer

Thank you You are great. Thank you to the rest of the speakers too

Connecting & Displaying Database on Website: XAMPP, Fatal Error, MySQL, Apache, strona.php

Post #1

Post #2

Post #3

Post #4

Post #5

Post #6

Post #7

Post #8

Post #9

Post #10

Post #11

Post #12

Post #13

Post #14

Post #15

Topic summary