Tagged Questions

0
votes
1answer
42 views

PHP game design - getting database information [on hold]

I am new to making games, and I am writing one for fun using php and javascript. I am using MySQL to store all of the info of the users of the game. The game is kind of like managing a sports team. ...
-3
votes
1answer
23 views

shuffle() array() and update the Database with new results mysql [on hold]

pull information where available='0' then there are numbers it shuffles all the id and i want it to update the database with with new Numbers for each line. $sql5="SELECT * FROM periodeight where ...
0
votes
1answer
21 views

php code, (database, forum) error

Need help with my php code, i get this error: Warning: mysqli_stmt::bind_param() [mysqli-stmt.bind-param]: Number of variables doesn't match number of parameters in prepared statement in ...
-3
votes
1answer
22 views

Php mysqli vol 2 [on hold]

I've tried to write some thing in to mysql database i go that error: the code: $fel = $mysqli->query("INSERT INTO deleted (uid, buy_type, prop_type, district, street, room_min, room_max, ...
-1
votes
1answer
40 views

Create pages from mysql database [on hold]

Hi I have a database with a table called products, I want it to generate a page when a url is requested with the "id" from the table is loaded so when a product with the id 23 is loaded it will show ...
0
votes
3answers
34 views

PHP/MYSQL Database Logic Query

Trying not to reinvent the wheel here so thought 'i'd ask you guys; There is an existing database for a computer game that records - map name, time it took to finish the map, the difficulty level, id ...
0
votes
2answers
21 views

Select from 3 possible columns, order by occurances / relevance

I have a table that contains 3 text fields, and an ID one. The table exists solely to get collection of ID's of posts based on relevance of a user search. Problem is I lack the Einsteinian ...
0
votes
1answer
23 views

PHP show next results in new row in html table

I have got a html table which i am using to show my products and i have the following code: <?php $result = mysqli_query($con,"SELECT * FROM products"); while($row = mysqli_fetch_array($result)) ...
1
vote
0answers
52 views

Database corrupts after many INSERT operations

My code below is supposed to automate insertion of a CSV into a database. Howvever, if the input file contains more than 10 lines, the database supposedly corrupts with the message, "database disk ...
0
votes
1answer
35 views

How can I echo an image in a PHP script?

I have a small problem. I have made a small database for storing found geocaches. When someone submits a geocache, and it successfully goes into the database, I want an image to appear. This is a snip ...
-1
votes
2answers
38 views

PHP/MySql Connection Overhead

I have recently completed a data layer for a PHP application. In my data layer I have various methods for executing different sql tasks such as selects, inserts, deletes, etc. Coming from a .NET ...
0
votes
1answer
18 views

PHP - Doctrine Store File (Binary in Database)

I'm looking for an example of how to store files in the database with doctrine. Unfortunately i cannot find much information online. I thought of a schema like: file: id, fileName, fileExt, ...
0
votes
1answer
10 views

If website gets closed return og kill session

i got a tiny issue. On my webpage i have a system that check how many users that is online and display their username. The code counts from table. When they login it gets inserted to database, and ...
-1
votes
1answer
17 views

Strict Standards: Non-static method DatabaseConnection::getConnection() should not be called statically in

I'm using php, and the following line produces an error I've not been able to fix: self::$connection = DatabaseConnection::getConnection();
-1
votes
1answer
25 views

Joining and Counting from MYSQL Table

So I have 2 tables in my db called users and map. The users has an ID assigned to a user, this ID is captured into the map table as capture_id when they input a marker. How can I tell how many places ...

1 2 3 4 5 … 526
15 30 50 per page