PHP/MySQL basic query failing

Lolslayer

So, this is a problem that is bugging me for a while now.

I've got a query I want to run with PHP, but it Always fails, even if it's very simple.

This problem only occures at one table, all other tables just work fine so it isn't a problem with connecting to the database.

Here is the code:

<?php
// Start the session
session_start();
?>

<html>
<head>
<title>Chat room</title>
</head>
<body>

<?php
  include 'opendb.php';

  $query = "SELECT id
  FROM chat";

  $resultaat = mysql_query($query, $connectie) or die('Error, query failed 1');


  include 'closedb.php';
?>

<p><?php echo $user?><?php echo $text?></p>
</form>

</body>
</html>

Yes, this actually fails, here's a link to the adress: http://ln99030804.haperen.eu/chat.php

Here's a picture showing my table on phpMyAdmin.

I also need to tell that I took some code away just to make it less chaotic, but it didn't have anything to do with the part crashing.

could anybody please help me with this?

Lolslayer

Okay, on request of @RiggsFolly I'll tell what the problem was.

The problem was that my opendb.ph and closedb.php files were on another folder then this page itself.

I didn't suspect that this was the problem because somehow other database tables didn't give an error to me, so I thought that that part was completely working.

Thanks everybody for helping me with this, it was a really stupid mistake but I was really stuck for days on this before I dared to ask on stack overflow xD

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-04-11

Comments

0 comments

TOP Ranking

Article

PHP/MySQL basic query failing

PHP/MySQL basic query failing

Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

pump.io port in URL

How to import an asset in swift using Bundle.main.path() in a react-native native module

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

Emulator wrong screen resolution in Android Studio 1.3

3D Touch Peek Swipe Like Mail

Double spacing in rmarkdown pdf

Svchost high CPU from Microsoft.BingWeather app errors

How to how increase/decrease compared to adjacent cell

Using Response.Redirect with Friendly URLS in ASP.NET

java.lang.NullPointerException: Cannot read the array length because "<local3>" is null

BigQuery - concatenate ignoring NULL

How to fix "pickle_module.load(f, **pickle_load_args) _pickle.UnpicklingError: invalid load key, '<'" using YOLOv3?

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

Can a 32-bit antivirus program protect you from 64-bit threats

Make a B+ Tree concurrent thread safe

Bootstrap 5 Static Modal Still Closes when I Click Outside

Vector input in shiny R and then use it

Assembly definition can't resolve namespaces from external packages