Integrating PHP functions with a database

Question

I just submitted my work and my course leader has asked me to use PHP functions to query my database. How can I do this? Is it possible to add just "function getRooms" before my queries, and return the desired result. I need thorough briefing on functions with MySQL.

For example: How will I add a function to this code:

<?php
    // By Kelvin
    include ("player.php");
    $result = mysql_query("SELECT * FROM phplogin WHERE username = '$username'");
    $row = mysql_fetch_assoc($result);
    $medipack = $row['medipack'];
    if ($_POST['object'] == "Use Medipack") {
        if ($medipack != 0) {
            mysql_query("UPDATE phplogin SET score = score + 50, health = health + 50, medipack = medipack - 1
            WHERE username = '$username'");
            echo ("<P>Medipack Used!</P>");
            $RoomNumber =5;
        }
        else {
            echo ("<P>You're all out of medipacks!</P>");
        }
    }
?>

could you edit your question and add some of the code you are using? This would help with your question — Phill Pafford
– Phill Pafford, Commented Mar 7, 2011 at 15:27
@Phill Pafford.. I have added an example. How can I ad a function to that? — Kelvin
– Kelvin, Commented Mar 7, 2011 at 16:16

Peter Mortensen · Accepted Answer · 2013-12-21 04:58:14Z

1

If he's looking for a level of abstraction between the rest of your code and the code accessing the database, wrapping the database logic in functions should be on the right path:

function getRooms($link){
    $sql = "SELECT * FROM rooms";
    $data = array();
    if($set = mysql_query($sql)){
        while($row = mysql_fetch_assoc($set)){
            $data[] = $row;
        }
    }
    return empty($data)
        ? null
        : $data;
}

$db_connection = mysql_connect('host', 'user', 'pass');
mysql_select_db('name', $db_connection);
$rooms = getRooms($db_connection);

Wrapping these functions into a class, and accessing them by methods is another step, as the instantiated object can manage its own connection, etc., but that may be a step further than necessary. Other functions (based on what I can guess) might be:

function getRoomById($link, $id){ }
function getRoomsByName($link, Array $names){ }

edited Dec 21, 2013 at 4:58

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Mar 7, 2011 at 15:34

Dan Lugg

20.7k19 gold badges116 silver badges180 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dan Lugg Over a year ago

@Kelvin; Sorry, don't do homework outright; teach to fish and all that. What you need to do is extract your database logic into manageable functions. In this case, perhaps checkItem() to check the type of item picked up, and changeHp() to update the player HP. The example I've provided should serve as a good starting point.

BrynJ · Accepted Answer · 2011-03-07 15:30:36Z

0

I would imagine your course leader is referring to the PHP's native MySQL functions - http://php.net/manual/en/book.mysql.php

answered Mar 7, 2011 at 15:30

BrynJ

8,39214 gold badges69 silver badges90 bronze badges

2 Comments

Michiel Pater Over a year ago

No, I think he is talking about user-defined functions. Is it possible to add just "function getRooms".

BrynJ Over a year ago

@Michiel Pater - having seen the newly added code example, I agree - please disregard my answer.

Peter Mortensen · Accepted Answer · 2013-12-21 04:59:28Z

0

You can wrap your queries inside PHP functions. For example, like this:

function &getRooms(){
    $query="SELECT id,name FROM rooms";
    $result=mysql_query($query);

    $ar_out=array();
    while ($row = mysql_fetch_assoc($result)) {
        $ar_out[]=$row;
    }
    return $ar_out;
}

This said, you really should find a tutorial or a book on how to use MySQL and PHP together. There are many things to know about code organization and performance.

edited Dec 21, 2013 at 4:59

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Mar 7, 2011 at 15:34

Riccardo Galli

13.1k6 gold badges69 silver badges63 bronze badges

Collectives™ on Stack Overflow

Integrating PHP functions with a database

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related