{"id":8375,"date":"2020-01-20T13:50:10","date_gmt":"2020-01-20T11:50:10","guid":{"rendered":"http:\/\/www.beseit.net\/?p=8375"},"modified":"2020-02-12T12:48:04","modified_gmt":"2020-02-12T10:48:04","slug":"php-instruccions-dus-frequent1","status":"publish","type":"post","link":"https:\/\/www.beseit.net\/?p=8375","title":{"rendered":"php instruccions d’us freq\u00fcent(1)"},"content":{"rendered":"

salt de l\u00ednia: <br>\u00a0\u00a0 <\/strong><?php echo “hello wold1 <br> hello world 2”;<\/p>\n

– \/\/es fa la conexi\u00f3 amb la BD
\n$conn= mysqli_connect(DB_HOST, DB_USER, DB_PWD, DB_NAME);<\/p>\n

\/\/s’escriu a la BD<\/p>\n

$SQL =”UPDATE $taula SET castella=’$castella’ WHERE id= ‘$idx’ “;
\n$result = mysqli_query($conn,$SQL);<\/p>\n

\/\/llegir registres d’una taula de BD ( include(‘conexi\u00f3&results.php’);
\n
\n$conn= mysqli_connect(DB_HOST, DB_USER, DB_PWD, DB_NAME);\/\/ fa la conexi\u00f3
\n$conn->set_charset(\"utf8mb4\");
\n$result = mysqli_query($conn,$SQL);\/\/llegeix i carrega matriu
\n$num_results = $result->num_rows;
\n<\/code>
\nLlegir una fila d’una taula
\n
\nDEFINE ('DB_HOST', 'localhost');
\nDEFINE ('DB_USER', 'root');
\nDEFINE ('DB_PASSWORD', 'beseit00');
\nDEFINE ('DB_NAME', 'polidic_eng');<\/code><\/p>\n

$conn = @mysqli_connect (DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
\nOR die (‘Could not connect to MySQL:’ .mysqli_connect_error());
\n$conn->set_charset(“utf8mb4”);
\n\/\/echo “Host information: ” . mysqli_get_host_info($conn) . PHP_EOL;
\n$SQL = “SELECT * FROM parametres WHERE id=1 LIMIT 1”; \/\/ordre mysql
\n$result = mysqli_query($conn,$SQL);\/\/llegeix i carrega matriu
\n$camps = mysqli_fetch_assoc($result);
\n$encerts=$camps[‘compt_encerts’];
\n$fallades= $camps[‘compt_fallades’];
\n$total= $encerts + $fallades;
\necho “encerts: $encerts, fallades:$fallades”;
\n$puntuacio= round(($encerts\/$total)*10,2);<\/p>\n

afegir un registre
\n
\n$SQL = \"INSERT INTO $_POST[taula](catala,castella,qualificador,aux)VALUES( '$catala','$definicio','$qualificador','$aux')\";
\nif (mysqli_query($conn, $SQL)) {echo \"New record created successfully\";}
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

salt de l\u00ednia: <br>\u00a0\u00a0 <?php echo “hello wold1 <br> hello world 2”; – \/\/es fa la conexi\u00f3 amb la BD $conn= mysqli_connect(DB_HOST, DB_USER, DB_PWD, DB_NAME); \/\/s’escriu a la BD $SQL =”UPDATE $taula SET castella=’$castella’ WHERE id= ‘$idx’ “; $result = … Continua llegint →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[72],"tags":[],"class_list":["post-8375","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/8375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8375"}],"version-history":[{"count":11,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/8375\/revisions"}],"predecessor-version":[{"id":8404,"href":"https:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/8375\/revisions\/8404"}],"wp:attachment":[{"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}