Jump to content
php.lv forumi

Kaspars

Reģistrētie lietotāji
  • Posts

    6
  • Joined

  • Last visited

Kaspars's Achievements

Newbie

Newbie (1/14)

  1. Kaadu laiku vienam cilveekam izpaliidzeeju ieksh ProgrammingTalk.com, kur bija nepiecieshams upload scripts. Tev pasham ir jaapievieno klaat mysql_query, kas pievieno faila nosaukumu datubaazei: <?php // Set the upload place, after your document root directory $upload_dir = $_SERVER['DOCUMENT_ROOT'] . "/upload/"; // An array of allowed file types $file_types = array( 'audio/mpeg' => 'mp3', 'image/pjpeg' => 'jpg', 'image/jpeg' => 'jpg', 'image/gif' => 'gif', 'image/bmp' => 'bmp', 'image/x-png' => 'png', 'image/x-dwg'=> 'dwg' ); if (isset($_POST[submit])) { // Write as many file upload // inputs as user wanted $file_amount = $_POST['file_amount']; // Check if not amount of files not empty if ( empty($file_amount) ) { print "<font color='#990000'>You did not select the amount of files you want to upload!\n " . "Please <a href='java_script_:history.back(-1)'>go back</a> and select!</font>"; return; } $counter = 1; while ($counter <= $file_amount) { $foto_input .= "$counter. file: <input name='filename[$counter]' type='file'><br />\n"; $counter++; } // Generate an html output // where to display the file // upload fields print "<form enctype='multipart/form-data' action='$PHP_SELF' method='post' name='upload_form'> <table width='100%' border='0' align='center'> <tr><td> <li>Upload path: $upload_dir</li>\n <li>Amount of files to upload: <b>$file_amount</b></li>\n </td></tr>\n <tr><td>$foto_input</td></tr>\n <tr><td><input type='submit' name='upload' value='Upload Files'></td></tr>\n </table>\n </form>\n"; } else { // Generate the form // for user to select how many uploads he // wants to do. print "<form name='gallery_setup' method='post' action='$PHP_SELF'>" . "Number of photos to upload:" . " <input name='file_amount' type='text' id='file_amount' size='10'>" . " <input type='hidden' name='MAX_FILE_SIZE' value='300000000'>" . " <input name='submit' type='submit' id='submit' value='submit'> " . "</form>"; } if (isset($_POST[upload])) { // Get the upload file array // and upload them to a destination // by looping through that array // Get the variables from previous form $up_files = $_FILES['filename']; $counter = 0; // Start the file upload to server while($counter <= count($up_files)) { if($up_files['size'][$counter] > 0) { // Read the mime type of current file $filetype = $up_files['type'][$counter]; $filename = $up_files['name'][$counter]; $tempname = $up_files['tmp_name'][$counter]; if (!array_key_exists($filetype, $file_types)) { print "<font color='#990000'>File <b>$filename</b> of type <b>$filetype</b> is not valid for upload!</font><br />"; } else { $upload_file = $upload_dir . $filename; // Upload the files move_uploaded_file($tempname, $upload_file); // Print the uploaded file print "<font color='#009900'>File <b>$filename</b> uploaded... new location: <b>$upload_file</b></font><br />"; } } $counter++; } // End if upload } ?> Ceru, ka izpaliidzeeju, Kaspars
  2. Paldies! Praksē ir bijis tā, ka reizumis nav nepieciešams funkcijai līdzņemamo, bet gan ierakstīt kā: Global $mainigais; un var šo mainigo lietot iekš funkcijas. Tāpēc arī bija tāda nesaprašana!
  3. Sveiki, Izveidoju bilžu galerijas skriptu, bet tomēr ir viena problēma. VISS SEKOJOŠAIS STRĀDĀ BEZ PROBLĒMĀM - Kad palaiž sākuma failu, tad uz ekrāna izdrukā visu bilžu galeriju aprakstus un linku, lai katrai no tām apskatītu visus pieejamos thumbnailus. (case select_gallery($db);, lejējā kodā) - Kad izvēlas galeriju no saraksta, tad tiek palaists - case 'thumbs', līdzi tiek padots konktrētās galerijas direktorijas nosaukums "current_dir". Get_thumbs funkcija savāc visus mazo bilžu nosaukumus, ieraksta tos masīvā - Show_thumbs funkcija panjem galerijas direktorijas nosaukumu, izveidoto masību (ar bilžu nosaukumiem) un arī mazo bilžu apakšdirektorijas nosaukumu. - Uz ekrāna izdrukājas visas vajadzīgās mazās bildītes. Katrai no viņām tiek piešķirta hipersaite <a href='$PHP_SELF?kodarit=liela&current_dir=$current_dir&id=$img'>, kur id ir bildes nosaukuma kārtas numurs mazo bildīšu masīvā. - Ideja ir tāda, ka tālāk, kļikšķinot uz mazās bildes tiek palaista funkcija show_full, kas paņemtu līdzi arī mazo bildīšu masību - $foto_faili. BET IR PROBLĒMA: Show_full funkcijai nekādīgi neizdodas iebarot visu mazo bildīšu masīvu. Cik saprotu, tad problēma daļēji rodas, jo pēc case 'thumbs' ir break (skatīt kodā), kas it kā pārtrauc palaistās funkcijas. Visi citi nepieciešamie elementi, kā current_dir un $id tiek pārmantoti, bet $foto_faili nē! Ja noņem break pēc case 'thumbs', tad uz ekrāna parādās uzklikšķinātā bilde (lielā), tikai zem visiem thumbnailiem, nevis jaunā logā, kā tas būtu, lietojot break; pēc case 'thumbs'. <code><font color="#000000"> switch($_GET['kodarit']) { case 'thumbs': get_thumbs($_GET['current_dir']); show_thumbs($_GET['current_dir'], $foto_faili, $fThumbDir); break; case 'liela': show_full ($_GET['current_dir'], $_GET['id'], $_GET['foto_faili']); break; default: select_gallery($db); } </font> </code> Paldies par uzmanību un atsaucību, Kaspars
  4. Paraknaajos pa manuaaljiem un veel visaaadi, beidzot pieveicu. Ja kaadam ir interese, luuk shitaa taa lieta straadaa: datums ir mysql lauks timestamp(8), kas noziiimee formaats GGGG-MM-DD. paareejais amptuveni saprotams taa pat: <code><font color="#000000"> <font color="#0000CC"><? $Year </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/date]date[/url]</font><font color="#006600">(</font><font color="#CC0000">"Y"</font><font color="#006600">); </font><font color="#0000CC">$Month </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/date]date[/url]</font><font color="#006600">(</font><font color="#CC0000">"m"</font><font color="#006600">); </font><font color="#0000CC">$Day </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/date]date[/url]</font><font color="#006600">(</font><font color="#CC0000">"d"</font><font color="#006600">); </font><font color="#0000CC">$StopDate </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/date]date[/url]</font><font color="#006600">(</font><font color="#CC0000">"Y-m-d"</font><font color="#006600">, </font><font color="#0000CC">[url=http://lv.php.net/mktime]mktime[/url]</font><font color="#006600">(</font><font color="#0000CC">0</font><font color="#006600">,</font><font color="#0000CC">0</font><font color="#006600">,</font><font color="#0000CC">0</font><font color="#006600">,</font><font color="#0000CC">$Month</font><font color="#006600">, (</font><font color="#0000CC">$Day </font><font color="#006600">+ </font><font color="#0000CC">20</font><font color="#006600">), </font><font color="#0000CC">$Year</font><font color="#006600">)); </font><font color="#0000CC">$StartDate </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/date]date[/url]</font><font color="#006600">(</font><font color="#CC0000">"Y-m-d"</font><font color="#006600">); </font><font color="#0000CC">$MenesisLV </font><font color="#006600">= array (</font><font color="#CC0000">"janvaris"</font><font color="#006600">, </font><font color="#CC0000">"februaris"</font><font color="#006600">, </font><font color="#CC0000">"marts"</font><font color="#006600">, </font><font color="#CC0000">"apr¾lis"</font><font color="#006600">, </font><font color="#CC0000">"maijs"</font><font color="#006600">, </font><font color="#CC0000">"jĖnijs"</font><font color="#006600">,</font><font color="#CC0000">"jĖlijs"</font><font color="#006600">, </font><font color="#CC0000">"augusts"</font><font color="#006600">, </font><font color="#CC0000">"septembris"</font><font color="#006600">, </font><font color="#CC0000">"oktobris"</font><font color="#006600">, </font><font color="#CC0000">"novembris"</font><font color="#006600">, </font><font color="#CC0000">"decembris"</font><font color="#006600">); if (</font><font color="#0000CC">$id</font><font color="#006600">) { </font><font color="#FF9900">// saak mekleet papildus info dayofmonth(datums) as die, month(datums) as men, year(datums) as gad, notikums, pilns_notikums, id </font><font color="#0000CC">$sql </font><font color="#006600">= </font><font color="#CC0000">"SELECT dayofmonth(datums) as die, month(datums) as men, year(datums) as gad, notikums, pilns_notikums, id FROM kalendars WHERE id=$id"</font><font color="#006600">; </font><font color="#0000CC">$res </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/mysql_query]mysql_query[/url]</font><font color="#006600">(</font><font color="#0000CC">$sql</font><font color="#006600">); </font><font color="#0000CC">$myrow </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/mysql_fetch_row]mysql_fetch_row[/url]</font><font color="#006600">(</font><font color="#0000CC">$res</font><font color="#006600">); } else { </font><font color="#0000CC">$query </font><font color="#006600">= </font><font color="#CC0000">"SELECT dayofmonth(datums) as diena, month(datums) as menesis, year(datums) as gads, notikums, id FROM kalendars WHERE ((datums >= '$StartDate') AND (datums <= '$StopDate')) ORDER BY datums ASC"</font><font color="#006600">; </font><font color="#0000CC">$result </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/mysql_query]mysql_query[/url]</font><font color="#006600">(</font><font color="#0000CC">$query</font><font color="#006600">); echo </font><font color="#CC0000">"No: <i>$StartDate</i><br/>L¾dz: <i>$StopDate</i><br/>"</font><font color="#006600">; echo (</font><font color="#CC0000">"<b>N²kam²s sacens¾bas:</b>"</font><font color="#006600">); echo (</font><font color="#CC0000">"<table border = '0' width = '100%' align='left'>"</font><font color="#006600">); while (</font><font color="#0000CC">$rows </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/mysql_fetch_row]mysql_fetch_row[/url]</font><font color="#006600">(</font><font color="#0000CC">$result</font><font color="#006600">)) </font><font color="#FF9900">// printee arra notikumus </font><font color="#006600">{ </font><font color="#0000CC">$menesis </font><font color="#006600">= </font><font color="#0000CC">$rows</font><font color="#006600">[</font><font color="#0000CC">1</font><font color="#006600">]; echo (</font><font color="#CC0000">"<tr><td><b><font face="</font><font color="#0000CC">arial</font><font color="#CC0000">" size="</font><font color="#0000CC">2</font><font color="#CC0000">">$rows</font><font color="#006600">[</font><font color="#CC0000">0</font><font color="#006600">]</font><font color="#CC0000">. $MenesisLV</font><font color="#006600">[</font><font color="#CC0000">$menesis</font><font color="#006600">]</font><font color="#CC0000">, $rows</font><font color="#006600">[</font><font color="#CC0000">2</font><font color="#006600">]</font><font color="#CC0000"></font></b><br/><font face="</font><font color="#0000CC">arial</font><font color="#CC0000">" size="</font><font color="#0000CC">2</font><font color="#CC0000">">$rows</font><font color="#006600">[</font><font color="#CC0000">3</font><font color="#006600">]</font><font color="#CC0000"></font><br/><a href="</font><font color="#006600">?</font><font color="#0000CC">id</font><font color="#006600">=</font><font color="#0000CC">$rows</font><font color="#006600">[</font><font color="#0000CC">4</font><font color="#006600">]</font><font color="#CC0000">"><font color="</font><font color="#0000CC">red</font><font color="#CC0000">" face="</font><font color="#0000CC">Fixedsys</font><font color="#CC0000">">><font face="</font><font color="#0000CC">arial</font><font color="#CC0000">" color="</font><font color="#0000CC">black</font><font color="#CC0000">" size="</font><font color="#0000CC">2</font><font color="#CC0000">"> vair²k</font></a><hr size="</font><font color="#0000CC">1</font><font color="#CC0000">" noshade></td></tr></font>"</font><font color="#006600">); } </font><font color="#FF9900">// aiver ciet table </font><font color="#006600">echo </font><font color="#CC0000">"</table>"</font><font color="#006600">; } </font><font color="#0000CC">?> </font> </font> </code>
  5. Lauks ir date. Tad cik noprotu vajadzeetu labaak timestamp, un tad var meeginaat kaut ko saliidzinaat? Paldies par ieteikumu!
  6. Sveiki, Man ir tabula ieksh mysql, kuraa ir sekojoshais: id, notikuma laiks, notikuma apraksts. Lieta taada ka veelos dabuut araa laukus, kas ir kaaadaa notikuma laika intervaalaa. Kaa lai to izdara. Ir meeginaats sekojosh variants <code><font color="#000000"> <font color="#0000CC"><? $Year </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/date]date[/url]</font><font color="#006600">(</font><font color="#CC0000">"Y"</font><font color="#006600">); </font><font color="#0000CC">$Month </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/date]date[/url]</font><font color="#006600">(</font><font color="#CC0000">"m"</font><font color="#006600">); </font><font color="#0000CC">$Day </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/date]date[/url]</font><font color="#006600">(</font><font color="#CC0000">"d"</font><font color="#006600">); </font><font color="#0000CC">$StopDate </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/date]date[/url]</font><font color="#006600">(</font><font color="#CC0000">"Y-m-d"</font><font color="#006600">, </font><font color="#0000CC">[url=http://lv.php.net/mktime]mktime[/url]</font><font color="#006600">(</font><font color="#0000CC">0</font><font color="#006600">,</font><font color="#0000CC">0</font><font color="#006600">,</font><font color="#0000CC">0</font><font color="#006600">,</font><font color="#0000CC">$Month</font><font color="#006600">, (</font><font color="#0000CC">$Day </font><font color="#006600">+ </font><font color="#0000CC">10</font><font color="#006600">), </font><font color="#0000CC">$Year</font><font color="#006600">)); </font><font color="#0000CC">$StartDate </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/date]date[/url]</font><font color="#006600">(</font><font color="#CC0000">"Y-m-d"</font><font color="#006600">); echo(</font><font color="#0000CC">$StartDate</font><font color="#006600">); echo(</font><font color="#0000CC">$StopDate</font><font color="#006600">); </font><font color="#0000CC">$query </font><font color="#006600">= </font><font color="#CC0000">"SELECT date_format(datums, '%Y %d, %m') FROM kalendars WHERE ('$datums' > StartDate )"</font><font color="#006600">; </font><font color="#0000CC">$result </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/mysql_query]mysql_query[/url]</font><font color="#006600">(</font><font color="#0000CC">$query</font><font color="#006600">); </font><font color="#0000CC">?> </font> </font> </code> p.s. datums ir datubazes lauks kuraa ir konkreetaa notikuma datums. Kopeejaa ideja taada, ka uz ekraana izdrukaa visus notikumus kas veeel buus, piemeeram 10 dienas uz priekshu.
×
×
  • Create New...