Gemini 🤖

Hi, i'm trying to activate the export to pdf function but it seems that is not so easy i have the following * Apache/2.0.63 (Win32) PHP/5.2.5 * MySQL client version: 5.0.45 * PHP extension: mysql phpMyAdmin * Version information: 3.0.1.1 i executed first this file i have attached that comes with the phpmyadmin package then i executed these : GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass'; GRANT SELECT ( Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv ) ON mysql.user TO 'pma'@'localhost'; GRANT SELECT ON mysql.db TO 'pma'@'localhost'; GRANT SELECT ON mysql.host TO 'pma'@'localhost'; GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'pma'@'localhost'; then this one : GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost'; and then i inserted into config.inc the following : $cfg['Servers'][$i]['controluser'] = 'pma'; $cfg['Servers'][$i]['controlpass'] = 'pmapass'; $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; Am i doing something wrong? Thanks in advance [attachment deleted by admin]

hi, thanks for your reply first the #center was going to used for a banner with the repeat function...anyway i didn't used that finally so that' why it was there. the name #center doesn't mean it was for adjusting text, but i removed them. also about the margin: auto 0; i have this : <style type="text/css"> body {margin: 0px; padding: 0px;} </style> isn't the same for the whole body?

Hi! i have made this : http://vmavrou.freetzi.com and i have this problem,when you click one of the buttons at the main page,at the second page if you don't view the page full screen and you start to decrease the size of the window, the home button at the right , is overlaying with the text. Any idea of what css script should i use to stop that? Thanks in advance.

Solved, using css. Thanks for your help.

Hi, i wanted to ask here : http://vmavrou.freetzi.com next to the login box is two lines with text. Is there any way to center them to the whole page? because with the <center> put them in the middle but after the login box. So i mean if there is anyway so the login boxed will be ignored at the align and the text will go to center. The text is dynamic so we don't know how many letters will be each time to adjust them manually. But the maxsize is ok so that if centralized won't fall on login box. Thanks in advance.

oh!! i'm dumb...you are so right ! fixed it! thanks alot! (missed the "")

yes you are right... i got this : int(1997) but what this means? and what am i doing wrong??

Hi, i want to check for dates with this form yyyy-mm-dd, ex 2009-11-20 i have made this : $pattern = "((19|20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01]))"; $test =2009-11-01; if (preg_match($pattern,$test)>0) { echo "ok"; } else { echo "false"; } but always getting false..am i doing something wrong with the pattern?

Manage to do it, by making up this solution. posted in case someone interested. $queryy = "DELETE FROM groupspu WHERE"; $result = mysql_query("SELECT * FROM groupspu"); $fields_num = mysql_num_fields($result); for($i=0; $i<$fields_num; $i++){ $field = mysql_fetch_field($result); $ff = $field->name; if($i==0) { $queryy = $queryy." ".$ff; } else{ $queryy = $queryy." ='0' AND ".$ff; } } $queryy = $queryy." ='0' "; $result = mysql_query($queryy);

yep, it worked in this form : DELETE FROM groupspu WHERE admin ='0' AND public ='0' AND dokimi ='0'  ... Thanks alot!

Hi i wanted to ask if i can use a query like this : DELETE FROM groupspu WHERE (proistamenos && dokimi && public && admin) = '0' because when i run it it deletes every row and not only the ones that the fields at the query are equal to zero. It is important the certain format that's why i'm asking if this query is possible without altering the (proistamenos && dokimi && public && admin) . Because that info is taken from other place of the program. Thanks in advance

hi! i have an array that contains name of fields. for example : $ff[0] = a $ff[1] = b $ff[2] = c and i know of course the length of the array. is possible to create a query to delete a row in a table where the contents of the array will be equals to zero for example . something like that. if($ff[0]==0&&$ff[1]==0&&$ff[2]==0) { delete row } but everytime we call that the array it could change. One time it might has 2 cells,other 3,4 etc. so we want to read the array and based on the results to automatic create a query. Is that possible to create a "dynamic" query to handle a case like this? Thanks in advance

Finally figure it out,the problem was a bad declaration at tha phpmyadmin . Thank you very much for your time and your help. Really gratefull,it was very hard to find out what was wrong. respect

here i use require_once (mysql_work.php) where set character and set names are included,at the page that updates the db.at the page that reads i have include_once. Does it makes any difference?

Yep,it's working, but the the problem is that when i submit it with the form then at the phpmyadmin value is not correct,is like ????????. It works only if i edit myself the field into phpmyadmin and enter the greek value. The it shows it fine. Is a problem at the storage now?

Yes! That was a main problem and now is solved! Great,thank you very very much. If you have time,now the remaining problem is the ????? at the index.php this text is given by the user and it's saved at the db,and then is imported from there. at the code that is for adding the text i use again : <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> tried also and the header(), saved utf-8 if(isset($_POST['stext'])) { $newtext = $_POST['stext']; $query = "UPDATE settings SET content = '$newtext' WHERE text = 'yes'"; $result = mysql_query($query); $stext = $newtext; at the phpmyadmin the field content is text and the charset utf8_unicode_ci When i enter it by hand at the phpmyadmin it was exported and printed fine. But when i try to insert it from the form it is saved like ?????????? like now at the main page. Any more ideas?

and the mysql_Work.php <?php $hostaddr = "http://vmavrou.freetzi.com/"; $adminupload= $hostaddr."admin/upload/"; $defaultupload= $hostaddr."upload/"; $dbhost = 'localhost'; $dbuser = 'test'; $dbpass = 'ts'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); $dbname = 'test'; mysql_select_db($dbname); mysql_query("SET NAMES 'utf8'", $conn); mysql_query("SET CHARACTER SET 'utf8'", $conn); ?>

The e exam and examino 3 are imported from the database,the other button for the search button is plain text. [attachment deleted by admin]

well now for any changes i make the with notepad... does this matter? i didn't know it..

I have insert it but it's still the same, also i meant that at least the word for the search button should at least work,but not even this one

well it includes some info, as the login box at the left top, but at the middle, adove the logo there is a search box, and there there is a greek word for search that is not included, it is at the index and it's not showing it correct. also at the mysql settings from the phpmyadmin : MySQL connection collation: Collation utf8_unicode_ci Characted set of mysql : UTF-8 Unicode (utf8)

well by using : <?php header('Content-type: text/html; charset=utf-8'); ?> it's even worst,check out index.php now it shows and this one with problem. Well it makes me confused with the same lines (without the header) <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> the index.php works and then the rest not. That's why i'm thinking if there is something that makes a kind of reset at the settings of the db? Also i remind that i include the configuration file in every page with the include_once("mysql_work.php");

well at the index.php there is the <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> and i added to the rest but i see no change i don't know if there is a problem with this doctype,it was added by dreamweaver i think i haven't enter it and i don't know if i have to make any change? I will now try your other suggestion with the header() and will be back with the results. Really thankfull for your time and help

unfortunatelly it remains the same.. what do you mean by live server? the site is here http://vmavrou.freetzi.com/index.php at the index works,but when you click a button then the problem starts

hi! i have this problem.. i want to use the utf-8 as the charset of my site and db on every page i have this : <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> and at the configuration file which i include also in every file with : include_once("mysql_work.php"); i have in this : $dbhost = 'localhost'; $dbuser = 'test'; $dbpass = 'ts'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); $dbname = 'test'; mysql_select_db($dbname); mysql_query("SET NAMES 'utf8'", $conn); also at the phpmyadmin every collation i have put it as utf8_unicode_ci But it's not working. Any ideas what am i doing wrong? Maybe is something with the include of the configuration file,because at the index.php works but at the other pages stops workings.. Also i'm not sure if this mysql_query("SET NAMES 'utf8'", $conn); is right or need and something else.. I don't know if i explain it very well..if you don't understand anything, i can give more info. Thanks in advance