Click here to Skip to main content
15,891,033 members
Home / Discussions / Web Development
   

Web Development

 
AnswerRe: Asp.Net Core Web API Pin
Richard Deeming15-Jul-20 23:29
mveRichard Deeming15-Jul-20 23:29 
Questionnot close sqlitedb in php is ok? Pin
Member 144909644-Jul-20 21:05
Member 144909644-Jul-20 21:05 
AnswerRe: not close sqlitedb in php is ok? Pin
Richard MacCutchan4-Jul-20 21:11
mveRichard MacCutchan4-Jul-20 21:11 
GeneralRe: not close sqlitedb in php is ok? Pin
Member 144909644-Jul-20 21:16
Member 144909644-Jul-20 21:16 
GeneralRe: not close sqlitedb in php is ok? Pin
Richard MacCutchan4-Jul-20 21:44
mveRichard MacCutchan4-Jul-20 21:44 
Questionweb development: php, MSQLI Pin
baalfire4-Jul-20 1:16
baalfire4-Jul-20 1:16 
AnswerRe: web development: php, MSQLI Pin
Richard MacCutchan4-Jul-20 3:36
mveRichard MacCutchan4-Jul-20 3:36 
AnswerRe: web development: php, MSQLI Pin
ellegonzalez26-Dec-20 5:45
ellegonzalez26-Dec-20 5:45 
Database data export is a familiar operation for many of us. phpMyAdmin is the go to choice for a database client in PHP. It provides database administration tools and also allows exporting the data. The exported data can be in various formats like SQL, CSV as selected.

Please let me know if below code is useful. I used it for adding same functionality on my website here.
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

 // Check connection

 if ($conn->connect_error) {

    die("Connection failed: " . $conn->connect_error);
}


 
$sql = "INSERT INTO MyGuests (firstname, lastname, email)

 VALUES ('John', 'Doe', 'john@example.com')";

 
if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

?>


Here is another good reference https://phppot.com/php/database-data-export-to-excel-file-using-php/
Questionrestore real ip to access.log of xampp apache server registered in cloudflare Pin
Member 144909643-Jul-20 21:12
Member 144909643-Jul-20 21:12 
QuestionMessage Removed Pin
2-Jul-20 8:04
Saim Irfan2-Jul-20 8:04 
Questionwhat would you recommend me to use graphs in PHP+MySQL? Pin
Joan M18-Jun-20 9:49
professionalJoan M18-Jun-20 9:49 
Questionnode js express redirect from http to https Pin
Oscar K.13-Jun-20 1:45
Oscar K.13-Jun-20 1:45 
QuestionPlotting points on interactive map Pin
StampedePress9-Jun-20 5:07
StampedePress9-Jun-20 5:07 
AnswerRe: Plotting points on interactive map Pin
Saim Irfan2-Jul-20 7:58
Saim Irfan2-Jul-20 7:58 
Questionweb development Pin
moustafa arabi6-Jun-20 3:39
moustafa arabi6-Jun-20 3:39 
AnswerRe: web development Pin
Mycroft Holmes6-Jun-20 12:07
professionalMycroft Holmes6-Jun-20 12:07 
QuestionHow to successfully Async download a pdf file to a client PC vb.net web application Pin
Amer Amer5-Jun-20 22:47
Amer Amer5-Jun-20 22:47 
AnswerRe: How to successfully Async download a pdf file to a client PC vb.net web application Pin
F-ES Sitecore6-Jun-20 2:40
professionalF-ES Sitecore6-Jun-20 2:40 
AnswerRe: How to successfully Async download a pdf file to a client PC vb.net web application Pin
Richard Deeming8-Jun-20 0:24
mveRichard Deeming8-Jun-20 0:24 
GeneralRe: How to successfully Async download a pdf file to a client PC vb.net web application Pin
Amer Amer8-Jun-20 4:11
Amer Amer8-Jun-20 4:11 
QuestionGoogle SignIn and regular account, using the same email Pin
jkirkerx2-Jun-20 12:53
professionaljkirkerx2-Jun-20 12:53 
QuestionWhere can passwords for webpages be stored, except in browser itself and Credentials Manager? Pin
arnold_w18-May-20 21:23
arnold_w18-May-20 21:23 
AnswerRe: Where can passwords for webpages be stored, except in browser itself and Credentials Manager? Pin
Richard Deeming19-May-20 0:22
mveRichard Deeming19-May-20 0:22 
GeneralRe: Where can passwords for webpages be stored, except in browser itself and Credentials Manager? Pin
arnold_w19-May-20 9:16
arnold_w19-May-20 9:16 
GeneralRe: Where can passwords for webpages be stored, except in browser itself and Credentials Manager? Pin
Richard Deeming19-May-20 9:25
mveRichard Deeming19-May-20 9:25 

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.