Código PHP:
private DataSet GetData()
{
using (MySqlConnection cad = new MySqlConnection("Database=edmaccom_ap;Data Source=localhost;User Id=edmaccom_root;Password=Xjt54R87g2; Allow Zero Datetime=True"))
{
cad.Open();
MySqlCommand ComandoSQL = new MySqlCommand("Select idappact, codappact, desapeta, desapsub, nomapact, resappact, Date_format(fecappini,'%d/%m/%y'), " +
" Date_format(fecappfin,'%d/%m/%y'), Date_format(fecapprea,'%d/%m/%y'), porappava, obsappact, diaapact, obsextact From appactividades " +
" INNER JOIN apetapas on idapeta = idappeta INNER JOIN apsubetapas on idapsub = idappseta " +
" INNER JOIN apactividades on idapact = idappact1 WHERE codappact = ?codappact", cad);
ComandoSQL.Parameters.AddWithValue("?codappact", TextBox1.Text);
MySqlDataAdapter da = new MySqlDataAdapter(ComandoSQL);
cad.Close();
DataSet pubsDataSet = new DataSet("Pubs");
da.Fill(pubsDataSet, "ggeneral");
return pubsDataSet;
}
}
Código PHP:
private void GenerarExcel(DataTable dt)
{
string attachment = "attachment; filename=../../graficas/grafica_general.xls";
//Response.Redirect("../../graficas/grafica_general.xls");
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
//Response.ContentType = "application/vnd.ms-excel";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("windows-1254");
Response.Charset = "windows-1254";
string tab = "";
foreach (DataColumn dc in dt.Columns)
{
Response.Write(tab + dc.ColumnName);
tab = "\t";
}
Response.Write("\n");
int i;
foreach (DataRow dr in dt.Rows)
{
tab = "";
for (i = 0; i < dt.Columns.Count; i++)
{
Response.Write(tab + dr[i].ToString());
tab = "\t";
}
Response.Write("\n");
}
Response.End();
}