Click here to Skip to main content
15,902,114 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
AnswerRe: PHP CODES TO DISPLAY SLIDING IMAGES Pin
Peter Leow4-Nov-13 1:52
professionalPeter Leow4-Nov-13 1:52 
QuestionAvailable username on all pages after login Pin
msz90013-Oct-13 6:03
msz90013-Oct-13 6:03 
AnswerRe: Available username on all pages after login Pin
Ringunger24-Oct-13 21:11
Ringunger24-Oct-13 21:11 
QuestionHow to Play multiple Videos in single player page ? Pin
mAzeem228-Oct-13 22:49
mAzeem228-Oct-13 22:49 
Questionphp search form having 2 input fields and single submit button Pin
marshalericson8-Oct-13 7:59
marshalericson8-Oct-13 7:59 
Questionphp Pin
BipinVekariya25-Sep-13 2:12
BipinVekariya25-Sep-13 2:12 
QuestionPHP call to mysqli_query returns null (as expected) but I don't seem to be able to detect it Pin
Jonathan Davies9-Sep-13 6:22
Jonathan Davies9-Sep-13 6:22 
QuestionMYSQL to XML using PHP Pin
wolf7777726-Aug-13 22:27
wolf7777726-Aug-13 22:27 
Hello Sir.
I am trying to convert the MYSQL data into XML using the following code :

\n";
$output .="<tables>\n";
// iterate over each table and return the fields for each table
foreach ( $tables as $table ) {
$output .= "\n";
$result_fld = mysql_query( "SHOW FIELDS FROM ".$table, $dbhandle );

while( $row1 = mysql_fetch_row($result_fld) ) {
$output .= "<field name="\"$row1[0]\"" type="\"$row1[1]\"";
$output" .="($row1[3]" =="PRI" )="" ?="" "="" primary_key="\"yes\"">\n" : " />\n";


}
$output .= "
\n";
}
$output .="\n";

// tell the browser what kind of file is come in
header("Content-type: xml");

echo $output;

$handle = fopen("MyXML.xml", "w") or die("unable to create file");
file_put_contents("MyXML.xml", $output);
fclose($handle);


// close the connection
mysql_close($dbhandle);
?>

Sir , I have 2 questions :

how can i update the code in order to show the content of the data in MYSQL ? This code is only showing the table and fields name and the fields types.

How i can update the code in order to show the foreign key and relation between tables ?
It is Showing only the primary key .

Help Please.
Thank you
QuestionUsing .net webservice data in php Pin
Andile.M20-Aug-13 0:35
Andile.M20-Aug-13 0:35 
QuestionIntitialize a session variable after onclick event is fired Pin
pandu web dev11-Aug-13 23:16
pandu web dev11-Aug-13 23:16 
AnswerRe: Intitialize a session variable after onclick event is fired Pin
Kaivan Alimohammadi23-Aug-13 10:25
Kaivan Alimohammadi23-Aug-13 10:25 
GeneralRe: Intitialize a session variable after onclick event is fired Pin
pandu web dev26-Aug-13 3:28
pandu web dev26-Aug-13 3:28 
QuestionContact form - Bootstrap Error Validation Pin
bigcdh4-Aug-13 8:13
bigcdh4-Aug-13 8:13 
AnswerRe: Contact form - Bootstrap Error Validation Pin
Peter_in_27808-Aug-13 15:42
professionalPeter_in_27808-Aug-13 15:42 
AnswerRe: Contact form - Bootstrap Error Validation Pin
vbmike23-Aug-13 9:12
vbmike23-Aug-13 9:12 
GeneralRe: Contact form - Bootstrap Error Validation Pin
bigcdh23-Aug-13 9:22
bigcdh23-Aug-13 9:22 
QuestionPHP find all occurrences of string in file Pin
MicahC5-Jul-13 6:44
MicahC5-Jul-13 6:44 
AnswerRe: PHP find all occurrences of string in file Pin
Graham Breach5-Jul-13 21:20
Graham Breach5-Jul-13 21:20 
GeneralRe: PHP find all occurrences of string in file Pin
MicahC7-Jul-13 19:52
MicahC7-Jul-13 19:52 
GeneralRe: PHP find all occurrences of string in file Pin
MicahC10-Jul-13 5:56
MicahC10-Jul-13 5:56 
QuestionNot much traffic here is there..... Pin
Erudite_Eric16-Jun-13 23:40
Erudite_Eric16-Jun-13 23:40 
AnswerRe: Not much traffic here is there..... Pin
Ali Al Omairi(Abu AlHassan)7-Jul-13 22:18
professionalAli Al Omairi(Abu AlHassan)7-Jul-13 22:18 
QuestionCounting Menu Items & Determining If First/Last Pin
NickBogi7-Jun-13 13:20
NickBogi7-Jun-13 13:20 
AnswerGot It Working Pin
NickBogi10-Jun-13 8:29
NickBogi10-Jun-13 8:29 
QuestionUrgent !!! Looking for the best solution Pin
MacAriel15-May-13 8:43
MacAriel15-May-13 8:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.