data structure in php and mysql

Question

Hello I have error on line 10 could tell me what is my mistake. Is it a boolean problem? I tried various solutions but I still get the same error:

<?php

class classData {

    function __construct() {
        mysql_select_db("dbVentas", mysql_connect("localhost", "root", ""));
    }

    function voidInsert($code, $name) {
        if (validateCodigo($code) == true) {
            mysql_query("insert into tbZone (code,zone) values ('" . $code . "','" . $name . "')")
                    or die("ERROR!!!... ");
        }
    }

    function validateCodigo($code) {
        $ok = true;
        $isql = mysql_query("select * from tbZone where code='" . $code . "'");
        $cCod = 0;

        while ($oRow = mysql_fetch_array($isql)) {
            extract($oRow);
            $cCod++;
        }

        if ($cCod > 0) {
            $ok = false;
        }

        return $ok;
    }
}
?>

I call this php file DataClass.php

what does the error message say specifically? qué dice el mensaje de error? — user428517
– user428517, Commented May 22, 2013 at 21:56
Do you mean there is a syntax error on line 10 or that the query function is returning false and the die() statement is running? — km6zla
– km6zla, Commented May 22, 2013 at 21:56
Why don't you actually echo out the mysql error message to find out what is going wrong? — Mike Brant
– Mike Brant, Commented May 22, 2013 at 21:56

ilbesculpi · Accepted Answer · 2013-05-22 22:03:13Z

2

Since you're calling another class method, you should use

$this->validateCodigo($code) instead of validateCodigo($code)

answered May 22, 2013 at 22:03

ilbesculpi

3283 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

data structure in php and mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related