cd /usr/ports/databases/luasql-mysql && make clean install
It create mysql.so in usr/local/lib/lua/lua5.1 but i can't get it to wok. I have exhausted all options......
Thx.
PS: I will be happy if someone have this function completed:
PHP Code:
int mysql_do_query(int *luabp)
{
int *result, *p_res, i=0;
MYSQL_FIELD *field;
char *query, **row;
unsigned long long int num = 0;
query = lua_tostring(luabp,1);
result = (int *)DirectQuery(*DBManager, query);
p_res = *(int**)result[3];
if (!*p_res) {
lua_pushnumber(luabp, 0);
return 0;
}
lua_newtable(luabp);
while(row = mysql_fetch_row(*p_res)) {
while( field = (MYSQL_FIELD*)mysql_fetch_field(*p_res) ) {
lua_pushstring(luabp,field->name);
if (sscanf(row[i],"%llu", &num))
lua_pushnumber(luabp, num * 1.0);
else
lua_pushstring(luabp,row[i]);
lua_rawset(luabp, -3);
i++;
}
}
return 1;
}
PHP Code:
local result = sql.query("SELECT id, name FROM users;");
say(result[1].name)
say(result[3].name)
say(result[4].name)
But it displays only one row: say(result.name)