Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // parameters, set them properly based on your needs.
- $host = '';
- $username = '';
- $password = '';
- $query = 'select * from [table] limit 0';
- $c = mysql_connect($host, $username, $password);
- $r = mysql_query($query, $c);
- $n = mysql_num_fields($r);
- $fieldType=[];
- for($i=0; $i<$n; $i++) {
- $fieldType[]=mysql_field_type($r, $i);
- }
- mysql_free_result($r);
- mysql_close($c);
- $c = mysqli_connect($host, $username, $password);
- $r = mysqli_query($c, $query);
- $n = mysqli_num_fields($r);
- $fieldiType=[];
- for ($i=0; $i<$n; $i++) {
- $fieldiType[]=mysqli_fetch_field_direct($r, $i)->type;
- }
- mysqli_free_result($r);
- mysqli_close($c);
- assert(count($fieldType) === count($fieldiType));
- for($i=0; $i<$n; $i++) {
- echo "$i. mysql_type: {$fieldType[$i]} --- mysqli_type: {$fieldiType[$i]}\n";
- }
Add Comment
Please, Sign In to add comment