DaniWeb IT Discussion Community

Mysql LIMIT, OFFSET, ORDER BY?

OmniX — Wed, 02 Dec 2009 23:22:45 GMT

Hi People

I would like to get an sql statement that uses LIMIT and OFFSET and then sorts the results in ASC or DESC order through the user of ORDER BY, something like this:

SELECT * FROM table LIMIT 10 OFFSET 0 ORDER BY DESC

Note: that does not work so any ideas? I tried shuffling around order by to avial.

Thanks, Regards X

Data Validation / Protection when inserting into MySQL/etc?

OmniX — Thu, 12 Nov 2009 23:37:29 GMT

I would like to get everyones opinions on what processes should be used to validating and protecting the input into your storage medium aka MySQL.
In particular listing possible php functions that hsould be run and maybe once we have a list we put them in order, from most to least important?

Note: they should be able to be encoded/decoded when retrieved also.

htmlentities() - html_entity_decode()
addslashes() - stripslashes()

Got the ball rolling now up to you guys :D

Thanks, Regards X

Possible to make a Dynamic Function/Method?

OmniX — Thu, 12 Nov 2009 23:25:36 GMT

I was stuffing around and I was wondering if it was at all possible to make a function or method, dynamic at all? In what context? well I would like not to have the specify the elements required by the function so at any given day it can be more or less. Confused? so am I! HA

Example:

public function dynamic($x0, $x1, $x2, $x3, etc) {

 // blah blah blah

}

so those $x, one, two, three, etc can be used without them actually being defined maybe i want to use $x0-100. This at all possible or some ideas how we could make it possible?

Thanks, Regards X

Insert Statement not working?

OmniX — Tue, 06 Oct 2009 10:37:43 GMT

I throw the exact same sql statement in phpmyadmin and it works but it does not work with mysql_query.

Ideas?

$a = "INSERT INTO players (player_id, first_name, last_name, date_of_birth, email, mobile_number, emergency_number, mother_name, father_name, player_number, team_captain, ip_address) VALUES ('', '', '', '', '', '', '', '', '', '', '', '127.0.0.1')"

$q = mysql_query($a);

Connecting to a mysql database through a class

OmniX — Tue, 06 Oct 2009 02:41:50 GMT

I have done this a million times before.
I dont understand why this is not working through the use of a class.
It is telling me that the variable is "undefined" hence contains a NULL value which is a load of *((^&$#.
Anyways my code(sections of it) is below, any help much appreciated.

private con;

$this->con = mysql_connect(server, name, pass);

Obviously the initialization statement is in a method which is called via the constructor. Now something is wrong when it plan as day that con is being given a value, I dont understand why it saying it is not. Anyways any idea where to look and how to fix much appreciated.

Thanks, Regards X

How to create an excel spreadsheet?

OmniX — Fri, 18 Sep 2009 05:14:02 GMT

We have all wanted data to be transfered to excel at one stage or another. I would like to know how people have done it and come to a general consensis on how it should be done. I usually use fopen or simple echo statement and declaring it as .xls or .csv when required. I have found a new error which brings up a NON EXCEL format and a SYLK error (due to me using sessions in the same file I am downloading, which I dont know why it matters). But if I wish to remove both errors as it does not look professional. Also I would like to know the offical content type for both excel formats (.xls and .xlsx). Add your comments and self code so we can get a general consensis!!!

My code:

 session_start();

 $filename = "test.xls";

 $ABC = $_SESSION['A']; // Yes a valid session from previous page        

 $line_1 = "A" . "\t" . "B" . "\t" . "C";

 $line_2 = "1" . "\t" . "2" . "\t" . "3";

 $line_3 = "HELLO " . $ABC;

 $data = $line_1 . "\n" . $line_2 . "\n" . $line_3;

 session_destroy();        

 // What I find a mystery is what is the OFFICAL content type for excel?

 header("Content-Type: application/x-msexcel");

 header("Content-Disposition: attachment; filename=" . $filename);

 echo $data;

Regards, X