Forum PHP.pl

[SQL] pobierz, plaintext 
ALTER TABLE tabela ADD kolumnaX TINYINT(3) NOT NULL
[SQL] pobierz, plaintext 

Cytat(KsaR @ 19.09.2016, 18:45:52 )

[SQL] pobierz, plaintext 
SELECT COUNT(*)
FROM `information_schema`.`columns`
WHERE `table_name` = 'tabela'
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
5
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 1 [type] => 0 ) 
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$sql = "SELECT COUNT(*) FROM `information_schema`.`columns` AS nradv WHERE `table_name`='stat'";
$result = mysqli_query($con, $sql);
$row = mysqli_fetch_array($result, MYSQLI_NUM);
$na = 'adv'.$row[0];
mysqli_query($con, "ALTER TABLE stat ADD ".$na." TINYINT(3) NOT NULL");
[PHP] pobierz, plaintext