regoch

gonna try, thanks for help!

I got mysql with list if people and one of field in base is date of birth in date format. So I have two questions. 1. Hot to get poeple age from date of brith field? 2. How to get all people that are younger then 45 years.

echo "<p><a href='/products/product.php?ID=".$result['ID']." 'class='productlink'' 'rel='nofollow''>".$result['description']."</a> <a href='/products/product.php?ID=".$result['ID']."><img src='".$result['awImage']."'/> </a>

echo "<a href='#' onClick='window.open('".mysql_result($result, $i, 'te_link')."');'>link text</a>"; This?

No problem, finaly I help somebody, not getting helped, haha!

$info_id = $_POST['info_id']; $info_dodatni_posao = join(", ", $_POST['info_dodatni_posao']); $qry = "UPDATE tz_info SET info_dodatni_posao='$info_dodatni_posao' WHERE info_id='$info_id'"; $result = @mysql_query($qry); I add join() in second line and get all multiple post in one field in database with , between like this Full Time, Full Time Rotational, Freelance

foreach($results as $result){ echo "<p> <strong>".$result['description']."</strong> <br><a href='/products/product.php?ID=".$result['ID']." rel='nofollow'>".$result['description']."</a> <a href='/products/product.php?ID='".$result['ID']."><img src='".$result['awImage']."'/> </a> </p>"; } Try this, to me its working!

join() do the work! Thanks!

Hi! I got this script for inserting jobs from multiple select, but can not get it work. I wonna all data from "select info_dodatni_posao" to get in one variable and put it in mysql database. I try this way thats below but not working! Any ideas? When I remove [] i get it to put just one job in mysql even if i select 3 or more. test.html <select multiple="multiple" name="info_dodatni_posao[]" id="info_dodatni_posao[]"> <option value='Certified Beauty Therapist'>Certified Beauty Therapist</option><option value='Certified Dive Master'>Certified Dive Master</option><option value='Certified Diver'>Certified Diver</option><option value='Certified Hair Dresser'>Certified Hair Dresser</option><option value='Certified Personal'>Certified Personal</option></select> test.php $info_id = $_POST['info_id']; $info_dodatni_posao = $_POST['info_dodatni_posao[]']; $qry = "UPDATE tz_info SET info_dodatni_posao='$info_dodatni_posao' WHERE info_id='$info_id'"; $result = @mysql_query($qry);

Thanks!

If is this posible? To have 3-4 pictures on page, user chose one, type in messagge and friends e-mail and send. So friend gets in mail picture and message from user, not just link where he can see picture, but picture insert in mail.

Thanks!

1. So I have to ask my hosting? 2. You think javascript or jquery?

1. How big pdf file can be uploaded to hosting? I work on page for news company, and they won.t to upload via cms actual number of news. Is it posible via cms or must be via ftp. I got this script for upload pdf that working fine. <form action="" method="post" name="fileForm" id="fileForm" enctype="multipart/form-data"> <center> <table> <tr><td style="width:150px;">Naziv PDF-a HR: </td><td><input name="pdf_ime_hr" type="text" class="textfield" id="pdf_ime_hr" /></td></tr> <tr><td style="width:150px;">Naziv PDF-a EN: </td><td><input name="pdf_ime_en" type="text" class="textfield" id="pdf_ime_en" /></td></tr> <tr><td style="width:150px;">Odaberi pdf za upload:</td><td><input name="upfile" type="file" size="36"></td></tr> <tr><td style="width:150px;"></td><td align="lef"><br/><input type="submit" name="Submit" id="Submit" value="Pošalji" /></td></tr> </table></center> </form> <?php $novost_id = $_GET['novost_id']; if (isset($_POST['Submit'])){ $pdf_ime_hr = $_POST['pdf_ime_hr']; if ($pdf_ime_hr == '') { echo "Niste upisali naziv PDF-a"; } else { ?> <div id="result"> <table width="100%"> <?php function getExtension($str) { $i = strrpos($str,"."); if (!$i) { return ""; } $l = strlen($str) - $i; $ext = substr($str,$i+1,$l); return $ext; } $pdf_naziv = stripslashes($_FILES['upfile']['name']); $extension = getExtension($pdf_naziv); $extension = strtolower($extension); $ran_name = rand () ; $pdf_naziv = 'kus'.$ran_name.'.'.$extension; $allowed = array('pdf'); $uploadLocation = "../pdf/$pdf_naziv"; if(in_array($extension, $allowed)) { if(move_uploaded_file($_FILES['upfile']['tmp_name'], $uploadLocation)) { $pdf_ime_hr = $_POST['pdf_ime_hr']; $pdf_ime_en = $_POST['pdf_ime_en']; echo " <table width='400px' align='center' cellspacing='0'> <tr bgcolor='#E6e6e6' height='26'> <td align='center' width='100%' colspan='2'><strong>Potvrda</strong></td> </tr> <tr bgcolor='#F6f6f6'> <td align='center' style='border-left:#E6e6e6 1px solid;border-bottom:#E6e6e6 1px solid;'><img src='images/valid.png'></td> <td align='center' width='80'% style='border-right:#E6e6e6 1px solid;border-bottom:#E6e6e6 1px solid;'><strong>".$pdf_naziv." uspješno unesen.</strong></td> </tr> </table><br />"; mysql_query("INSERT INTO pdf SET pdf_naziv='$pdf_naziv', pdf_ime_hr='$pdf_ime_hr', pdf_ime_en='$pdf_ime_en', pdf_novost='$novost_id'"); } else{ echo " <table width='400px' align='center' cellspacing='0'> <tr bgcolor='#E6e6e6' height='26'> <td align='center' width='100%' colspan='2'><strong>Potvrda</strong></td> </tr> <tr bgcolor='#F6f6f6'> <td align='center' style='border-left:#E6e6e6 1px solid;border-bottom:#E6e6e6 1px solid;'><img src='images/warning.png'></td> <td align='center' width='80'% style='border-right:#E6e6e6 1px solid;border-bottom:#E6e6e6 1px solid;'><strong>PDF nije unesen.</strong></td> </tr> </table><br />";; } } else { echo "Pokušali ste uploadati datoteku koja nije PDF"; } ?> </table> </div> <?php } } ?> 2. Is it posible to add on page script that change desktop background. Exapmle i have 3 pictures for wall paper and user choose wich to put as desktop background?

RewriteRule ^hr/fotogalerija/(.*)/(.*)/(.*)$ /galerija.php?id_galerije=$1&galerija_seo=$2&page=$3 After hours spend, htacess solved thing!

Hi, I got this pagination script and workin fine for me in 3-4 years. But until now i use it in static pages, now i wonna use it on my gallery page that go truogh cms. So problem is here, when i put it in statis page <?php //Postavke za pagination //Ime tablice $tablica="galerije"; //Poredaj po kojem polju i kako $poredak="id_galerije DESC"; //Ime stranice na kojoj se radi pagination $targetpage = "/hr/novosti; //Broj prikaza po stranici $limit = 1; include('pagination.php'); //Izvršavanje querya kojeg želimo paginationirati while ($redak=mysql_fetch_array($rezultat)) { ?> <div id="galerije_lista"> <?php echo $redak['naslov_hr']; ?> </div> <?php } ?> <?php //Ispisivanje pagionationa echo $paginate; ?> work fine buit when i get in page that is called by &id_galerije not working. <?php //Postavke za pagination //Ime tablice $tablica="galerije"; //Poredaj po kojem polju i kako $poredak="id_galerije DESC"; //Ime stranice na kojoj se radi pagination $galerija_seo=$redak_galerija['galerija_seo_hr']; $targetpage = "/".$home_jezik."/".$menu_fotogalerija."/".$id_galerije."/".$galerija_seo; //Broj prikaza po stranici $limit = 1; include('pagination.php'); //Izvršavanje querya kojeg želimo paginationirati while ($redak=mysql_fetch_array($rezultat)) { ?> <div id="galerije_lista"> <?php echo $redak['naslov_hr']; ?> </div> <?php } ?> <?php //Ispisivanje pagionationa echo $paginate; ?> htacces code for this page is RewriteRule ^hr/fotogalerija/(.*)/(.*)$ /galerija.php?id_galerije=$1&galerija_seo=$2 here is live example http://www.sinjske-novine.kus-sinj.hr/hr/fotogalerija/3/22 <?php //skripta za pagination $query = "SELECT COUNT(*) as num FROM $tablica"; $total_pages = mysql_fetch_array(mysql_query($query)); $total_pages = $total_pages['num']; $stages = 3; $page = mysql_escape_string($_GET['page']); if($page){ $start = ($page - 1) * $limit; }else{ $start = 0; } //Dohvati podatke iz baze $query1 = "SELECT * FROM $tablica ORDER BY $poredak LIMIT $start, $limit"; $rezultat = mysql_query($query1); if ($page == 0){$page = 1;} $prev = $page - 1; $next = $page + 1; $lastpage = ceil($total_pages/$limit); $LastPagem1 = $lastpage - 1; $paginate = ''; if($lastpage > 1) { $paginate .= "<div class='paginate'>"; // Predhodna if ($page > 1){ $paginate.= "<a href='$targetpage?page=$prev'> << </a>"; }else{ $paginate.= "<span class='disabled'> << </span>"; } //Stranice if ($lastpage < 7 + ($stages * 2)) // Not enough pages to breaking it up { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page){ $paginate.= "<span class='current'>$counter</span>"; }else{ $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";} } } elseif($lastpage > 5 + ($stages * 2)) // Enough pages to hide a few? { if($page < 1 + ($stages * 2)) { for ($counter = 1; $counter < 4 + ($stages * 2); $counter++) { if ($counter == $page){ $paginate.= "<span class='current'>$counter</span>"; }else{ $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";} } $paginate.= "..."; $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>"; $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>"; } elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2)) { $paginate.= "<a href='$targetpage?page=1'>1</a>"; $paginate.= "<a href='$targetpage?page=2'>2</a>"; $paginate.= "..."; for ($counter = $page - $stages; $counter <= $page + $stages; $counter++) { if ($counter == $page){ $paginate.= "<span class='current'>$counter</span>"; }else{ $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";} } $paginate.= "..."; $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>"; $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>"; } else { $paginate.= "<a href='$targetpage?page=1'>1</a>"; $paginate.= "<a href='$targetpage?page=2'>2</a>"; $paginate.= "..."; for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page){ $paginate.= "<span class='current'>$counter</span>"; }else{ $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";} } } } //Sljedeća if ($page < $counter - 1){ $paginate.= "<a href='$targetpage?page=$next'> >> </a>"; }else{ $paginate.= "<span class='disabled'> >> </span>"; } $paginate.= "</div>"; } ?>

can I send you config in pt message?

I post it in first post, if you think of that?

ok, I start from zero again, copy whole (http://galerija-sikirica.kus-sinj.hr/admin) working admin to (http://galerija-galiotovic.kus-sinj.hr/admin) and just change in config.php "define('DB_DATABASE', 'database');" line, so now I shure that there is no white space . If i leave connected to first database bout admin login works fine, but when I connect second admin to his database get same error again. I try to name session but no help with that!

But I copy-paste first subdomain admin to other 2 subdomains admins, and everything works fine only if I connect other 2 subdomein admin to database of first subdomain. If I connect other two admins to their databases getting error.

HI! I got 3 indetical pages (only different colors in css) on 3 subdomeins like this: http://www.galerija-sikirica.kus-sinj.hr (http://galerija-sikirica.kus-sinj.hr/admin) http://www.galerija-galiotovic.kus-sinj.hr (http://galerija-galiotovic.kus-sinj.hr/admin) http://www.sinjske-novine.kus-sinj.hr (http://sinjske-novine.kus-sinj.hr/admin) on http://www.kus-sinj.hr/ Every page have own admin (for news and galleries) and own mysql database. And I try to every admin have their own users (because there are 3 separate sections of company) but my login script works only on first subdomain, on other two getting that cant star sessins, headers allready send. But when i conect login of all 3 admins to first admin that works fine, but all user are together. This is my login form: <?php include ("include/head.php"); ?> <body> <div id="main_container"> <div class="header_login"> <div class="logo"><a href="index.php"><img src="images/logo.gif" alt="" title="" border="0" /></a></div> </div> <div class="login_form"> <h3>Admin Panel - Prijava</h3> <div class="form"> <br /> <form action="login.php" method="post"> <table cellspacing="2" cellpadding="2" border="0"> <tr> <th align="right" style="width:150px">Korisnik: </th> <td><input type="text" name="login" id="login" size="44" /></td> </tr> <tr> <th align="right">Lozinka: </th> <td><input type="password" name="password" id="password" size="44" /></td> </tr> <tr> <th></th> <td><input type="submit" name="Submit" id="Submit" value="Pošalji" /></td> </tr> </table> </form> </div> </div> <div class="footer_login"> <?php include ("include/footer.php"); ?> </div> </div> </body> </html> login.php <?php //Start session session_start(); //Podaci za spajanje na bazu podataka require_once('config.php'); //Funkcija za konvertiranje tekstualnh polja function clean($str) { $str = @trim($str); if(get_magic_quotes_gpc()) { $str = stripslashes($str); } return mysql_real_escape_string($str); } //Pozivanje funkcije za konvertiranje tekstualnh polja $login = clean($_POST['login']); $password = clean($_POST['password']); //Provjera jesu li ispunjena sva polja if($login == '') { $errmsg_arr[] = 'Niste upisali ime korisnika'; $errflag = true; } if($password == '') { $errmsg_arr[] = 'Niste upisali lozinku'; $errflag = true; } //Ako nisu sva polja ispunje vraća na stranicu unosa if($errflag) { $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: prijava.php"); exit(); } //Izvršenje SELECT query $qry="SELECT * FROM members WHERE login='$login' AND passwd='".md5($_POST['password'])."'"; $result=mysql_query($qry); //Provjera da li je izvršen Query if($result) { if(mysql_num_rows($result) == 1) { //Login Successful session_regenerate_id(); $member = mysql_fetch_assoc($result); $_SESSION['SESS_MEMBER_ID'] = $member['member_id']; $_SESSION['SESS_FIRST_NAME'] = $member['firstname']; $_SESSION['SESS_LAST_NAME'] = $member['lastname']; session_write_close(); header("location: index.php"); exit(); }else { //Login failed header("location: prijava-nesupjela.php"); exit(); } }else { die("Query nije izvršen"); } ?> config.php <?php //Podaci za spajanje na bazu podataka define('DB_HOST', 'localhost'); define('DB_USER', 'user'); define('DB_PASSWORD', 'password'); define('DB_DATABASE', 'database'); //Array za provjeru jesu li ispunjena sva polja $errmsg_arr = array(); //Isključivanje provjere jesu li ispunjena sva polja $errflag = false; //Spajanje na mysql server $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if(!$link) { die('Greška prilikom spajanja na server: ' . mysql_error()); } //Odabir baze podataka $db = mysql_select_db(DB_DATABASE); if(!$db) { die("Greška prilikom spajanja na bazu podataka"); } logout.php <?php //Start session session_start(); unset($_SESSION['SESS_MEMBER_ID']); unset($_SESSION['SESS_FIRST_NAME']); unset($_SESSION['SESS_LAST_NAME']); ?> <?php include ("include/head.php"); ?> <body> <div id="main_container"> <div class="header_login"> <div class="logo"><a href="index.php"><img src="images/logo.gif" alt="" title="" border="0" /></a></div> </div> <div class="login_form"> <h3>Admin Panel - Odjava</h3> <p align="center"> </p> <h4 align="center" class="err">Odjavili ste se.</h4> <p align="center">Kliknite za ponovnu <a href="prijava.php">prijavu.</a></p> </div> <div class="footer_login"> <?php include ("include/footer.php"); ?> </div> </div> </body> </html> and here is error code Warning: session_regenerate_id() [function.session-regenerate-id]: Cannot regenerate session id - headers already sent in /home/kussinj/public_html/sinjske-novine/admin/login.php on line 47 Warning: Cannot modify header information - headers already sent by (output started at /home/kussinj/public_html/sinjske-novine/admin/config.php:1) in /home/kussinj/public_html/sinjske-novine/admin/login.php on line 53

Hi, I have this simple code for gallery on my page. And everything working fine but when i click on small picture to change big picture if I'm page scroll up to top of page. So i scroll to the gallery change picture ad page scroll up to the top. What could be the reason? Here is live axample: http://www.galerija-galiotovic.kus-sinj.hr/hr/fotogalerija/3/test-hrvatski# <table id="Table_galerija"> <tr> <td style="width:520px;height:445px;vertical-align:top;padding:20px;"> <h2 style="position:absolute;top:200px;color:#FFF;" id="naslov">Test hrvatski</h2> <div id="slika_velika"><img id="glavna_slika" style="max-height:390px;max-width:520px;vertical-align:middle;" src="/slike/10012012_7119092522.jpg" alt="KUS Sinj" /></div></td> <td> <div class="slikica"><a href="#" onclick="document.getElementById('glavna_slika').src='/slike/10012012_7119092522.jpg'"><img src="/slike/thumbnails/10012012_7119092522.jpg" style="max-height:88px;max-width:125px;vertical-align:middle;" alt="KUS Sinj" /></a></div> <div style="height:14px;"></div> <div class="slikica"><a href="#" onclick="document.getElementById('glavna_slika').src='/slike/12012012_7509043961.jpg'"><img src="/slike/thumbnails/12012012_7509043961.jpg" style="max-height:88px;max-width:125px;vertical-align:middle;" alt="KUS Sinj" /></a></div> <div style="height:14px;"></div> <div class="slikica"><a href="#" onclick="document.getElementById('glavna_slika').src='/slike/12012012_9295689431.jpg'"><img src="/slike/thumbnails/12012012_9295689431.jpg" style="max-height:88px;max-width:125px;vertical-align:middle;" alt="KUS Sinj" /></a></div> <div style="height:14px;"></div> <div class="slikica"><a href="#" onclick="document.getElementById('glavna_slika').src='/slike/12012012_8527430603.jpg'"><img src="/slike/thumbnails/12012012_8527430603.jpg" style="max-height:88px;max-width:125px;vertical-align:middle;" alt="KUS Sinj" /></a></div> <div style="height:14px;"></div> <div class="slikica"><a href="#" onclick="document.getElementById('glavna_slika').src='/slike/12012012_2126924535.jpg'"><img src="/slike/thumbnails/12012012_2126924535.jpg" style="max-height:88px;max-width:125px;vertical-align:middle;" alt="KUS Sinj" /></a></div> <div style="height:14px;"></div> <div id="gori"><a href="#" onmousedown="moveup()" onmouseup="clearTimeout(moveupvar)"><img src="/images/gori.png" width="119" height="23" alt="Top Sport" /></a></div> <div id="doli"><a href="#" onmousedown="movedown()" onmouseup="clearTimeout(movedownvar)"><img src="/images/doli.png" width="119" height="23" alt="Top Sport" /></a></div></td> </tr> </table>

version 2 worked, thanks!

I got site wirch I like tu turn to multilanguage. <?=$home_jezik?> This is my variable for language code. So I wonna add it to <?php echo $redak['novost_naslov_hr']; ?> so that "hr" change to "en" or any other language. I try with this but nothing happens <?php echo $redak['novost_naslov_.$home_jezik']; ?>

after all day googling and giving Adam trooble find out that this only work with sans fonts, so i change font to open sans and with that javascript get it woking! http://jsfiddle.net/aNUjB/14/ Thank you!