function get_weight($id_c) { if (get_trace($id_c) == 0) { return get_standard_weight($id_c); } else { $weight = get_token(get_trace($id_c)); return $weight; } }
function do_pdo($driver, $host, $db, $charset, $user, $password, $query) { global $db_connect_result, $db_data; try { // create new pdo object $pdo = new PDO("{$driver}:host={$host};dbname={$db};charset={$charset}", $user, $password); // Set Errorhandling to Exception $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // get fields from table $q = $pdo->prepare("DESCRIBE Country;"); $q->execute(); $table_fields = $q->fetchAll(PDO::FETCH_COLUMN); // get table data $q = $pdo->query($query); $results = $q->fetchAll(PDO::FETCH_ASSOC); // close the connection $pdo = null; } catch (PDOException $e) { $db_connect_result = '<p style="text-align:center"><img src="images/red-cross.png" style="margin-right:5px;margin-bottom:-3px; alt="" /><strong><span style="color:red">Connect failed!</span></strong></p>' . "\n\t"; $db_connect_result .= get_trace($e); return; } // create html data table $db_data .= "<table>\n"; $db_data .= " <tr>\n "; // add table headers from cols foreach ($table_fields as $field) { $db_data .= '<th>' . $field . '</th>'; } $db_data .= "\n </tr>\n"; // iterate through each record foreach ($results as $a) { $db_data .= " <tr>\n "; foreach ($a as $v) { $db_data .= '<td>' . $v . '</td>'; } $db_data .= "\n </tr>\n"; } $db_data .= "</table>\n"; $db_data .= "<p>Returned " . $q->rowCount() . " rows for " . $q->columnCount() . " fields.</p>\n"; $db_connect_result = '<img src="images/tick-clean.png" style="margin-right:5px;margin-bottom:-3px;" alt="" /><strong><span style="color:green">Successful</span></strong>'; }
function get_weight($id_c) { if (get_trace($id_c) == 0) { return get_standard_weight($id_c); //that si the case we understand } else { $weight = get_token(get_trace($id_c)); if ($weight == 0) { return get_standard_weight($id_c); } else { return $weight; } } }