private IEnumerator LoadImage(string str)
{
using (UnityWebRequest uwr = UnityWebRequestTexture.GetTexture(str))
{
yield return(uwr.SendWebRequest());
if (uwr.isNetworkError || uwr.isHttpError)
{
Debug.Log(uwr.error);
}
else
{
txt = new Texture2D(2, 2, TextureFormat.RGB24, false);
txt = DownloadHandlerTexture.GetContent(uwr);
ResizeImage rimage = this.gameObject.AddComponent <ResizeImage>();
txt = rimage.ScaleTexture(txt);
BildRawData brd = new BildRawData();
brd.BildHight = txt.height;
brd.BildWidth = txt.width;
brd.BildRaw = txt.GetRawTextureData();
speise.Bild = brd;
UpdateInput();
}
}
}
public Speise[] ReadSpeisen(int id)
{
//D:\xampp\mysql\bin\my.ini
//innodb_buffer_pool_size = 512M
//innodb_additional_mem_pool_size = 2M
//## Set .._log_file_size to 25 % of buffer pool size
//innodb_log_file_size = 128M
//innodb_log_buffer_size = 128M
string sqlText = "SELECT speisekarte.ID, speisekarte.Titel, speisekarte.Preis, speisekarte.Beschreibung, speisekarte.SpeisenArt_ID, speisenart.SpeisenArtName, speisekarte.BildRawData, speisekarte.BildHeight, speisekarte.BildWidth FROM speisekarte INNER JOIN speisenart ON " + id + " = speisenart.ID WHERE speisekarte.SpeisenArt_ID =" + id;
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlText;
MySqlDataReader reader = cmd.ExecuteReader();
int k = 0;
while (reader.Read())
{
k++;
}
reader.Close();
cmd.CommandText = sqlText;
reader = cmd.ExecuteReader();
Speise[] speisen = new Speise[k];
int i = 0;
while (reader.Read())
{
Speise speise = new Speise();
BildRawData bild = new BildRawData();
speise.ID = (int)reader[0];
speise.Titel = (string)reader[1];
speise.Preis = (string)reader[2];
speise.Beschreibung = (string)reader[3];
speise.SpeisenArt_ID = (int)reader[4];
speise.SpeisenArt = (string)reader[5];
bild.BildRaw = (byte[])reader[6];
bild.BildHight = (int)reader[7];
bild.BildWidth = (int)reader[8];
speise.Bild = bild;
speisen[i] = speise;
i++;
}
reader.Close();
conn.Close();
return(speisen);
}
