PHP MySQL copiant dades d’una taula a una altra

[php]
<?php
// Aquest script carrega la taula 9000_CAMPS a la taula words les dos taules son de polidic_eng
// 9000_CAMPS -> ENGLISH_POLIDIC.words
// ES FA LA CONNEXIÓ
$conn= mysqli_connect("localhost", "miquel", "Beseit1968!","polidic_eng");// fa la conexió
if (!$conn) { echo "Error: No s’ha pogut connectar a:". DB_NAME ;}
else{echo "Connected successfully";}
$SQL="TRUNCATE TABLE words"; //buida la taula
mysqli_query($conn, $SQL);
$sql="INSERT INTO words (tipus, catala, castella, pron) SELECT * FROM 9000_CAMPS";
mysqli_query($conn, $sql);
echo "fet";
?>
[/php]

Assistant entrenat per OpenAI (chat.openai.com)

[pdf-embedder url=”https://www.beseit.net/wp-content/uploads/2022/12/assistant_openai.pdf”]

SELECCIONA FILES I LES MOSTRA
[php]

$conn = mysqli_connect($host, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
// Select row from table
$sql = "SELECT * FROM english_castilian WHERE catala LIKE ‘table’ ";
//$sql = "SELECT * FROM english_castilian WHERE id >= 10000 limit 10";
$result = mysqli_query($conn, $sql); //resultat
// Fetch rows and print them
while ($row = mysqli_fetch_assoc($result)) {
echo $row[‘catala’] . "—" . $row[‘castella’];
echo "<br>";
}
// Close connection
mysqli_close($conn);

?>

[/php]

BUSCAR UN NOM I MOSTRAR-LO

[php]

$conn = mysqli_connect($host, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
// Select row from table
$sql = "SELECT * FROM english_castilian WHERE catala LIKE ‘table’ ";
//$sql = "SELECT * FROM english_castilian WHERE id >= 10000 limit 10";
$result = mysqli_query($conn, $sql); //resultat
// Fetch rows and print them
while ($row = mysqli_fetch_assoc($result)) {
echo $row[‘catala’] . "—" . $row[‘castella’];
echo "<br>";
}
// Close connection
mysqli_close($conn);
[/php]

Script. Selecciona un primer caracter predefinit de un array (en aquest cas ‘C,c’) i crea un fitxer.

Per alguna circunstància en lloc del caracter TAP (09) les línies ‘pentinades’ somplen de C2 A0. Això causarà errors si fem un copy/pega del codi al editor SUBLIME 3. Per això s’hauran de suprimir esl jocs ‘C2 A0’.

[php]

<?php
$catala = "";
$new_line = 0;
$dic = file(‘C-definicions_mots0.txt’); //array de 6145
$num_linies = count($dic); //hauria de ser 6145
echo "$num_linies <br>";
$myfile = fopen("A-LLISTA.txt", "w") or die("Unable to open file!"); //a-> mode append, w->esborra
$i = 0;
while ($i < $num_linies) {
$first_char = mb_substr($dic[$i], 0, 1, ‘UTF8’); //agafo el primer caracter de la la linia dic[$i]
switch ($first_char) {
case C:
case c:
if ($catala != "") {
$catala = str_replace("\x0d\x0a", "", $catala);
$txt = "$catala \n";
fwrite($myfile, $txt);
$txt = "";
$catala = $dic[$i]; //nova linia
echo "$dic[$i] –catala= $catala <br>";
}
$catala = $dic[$i];
echo "$i–$first_char–0k $catala <br>";
$dic[$i] = str_replace("\x0d\x0a", "", $dic[$i]);
break;
default:
$catala = $catala . $dic[$i];
echo "muttttttttttttt$i–$first_char $catala<br>";
break;
}
$i++;
} //fi del while

[/php]

Connexió a MySql i mostrar una fila

asdfff
[php]

<?php
$SQL="SELECT id,catala FROM catala_castella where catala LIKE ‘fons’ ";
// ES FA LA CONNEXIÓ
$conn= mysqli_connect("localhost", "miquel", "Beseit….!","polidic_cat");// fa la conexió
if (!$conn) { echo "Error: No s’ha pogut connectar a:". DB_NAME ;}
else{echo "Connected successfully";}
// es llegeix la fila de la taula corresponent a "fons"
$result = mysqli_query($conn,$SQL);
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
echo "<br>".$row[‘id’];
echo "<br>".$row[‘catala’];
?>

[/php]

Publicat dins de PHP

PHP While, For (Treure els caracters C3 A0 del script amb 010 editor)

Asad

[php]
<?php
$x = 1;
while($x <= 5) {
echo "The number is: $x <br>";
$x++;
}
?>
[/php]

Scrip per fer una busqueda, dintre d’un fitxer de paraules que comencin per a

[php]
<?php

//busca mots que no comencin per ‘a’
//input A-definicions_mots.txt

$dic= file(‘A-definicions_mots.txt’); //array de 6145
$num_linies=count($dic); //hauria de ser 6145
//$num_linies=10;
echo "$num_linies <br>";
$i=0;
while($i < $num_linies){

$first_char= mb_substr($dic[$i],0,1,’UTF8′); //agafo el primer caracter de la la linia dic[$i]
//echo mb_substr( "воскресенье", 0, 1,’UTF8′); // Returns в
//echo $first_char.bin2hex( $first_char)."<br>" ;
switch($first_char) {
case A:
case a:
case à:
case Ä:
case ä:
echo "$i–$first_char–0k <br>";
break;

default:

echo "$i–$first_char <br>";

break;
}
$i++;
}

?>

[/php]