Search results

  1. fomalhaut

    Display all that would be secret while Mysql is broken

    Hello. While the Mysql update, if I try to connect my website, I got a (normal) error. What must I change for not display secret things, like user, password ? Here is the message I have : (naturelly, I've masked the real user, password ecc. by usr, ident, dbName...) Thanks if you can help me.
  2. fomalhaut

    mySql : Select into file

    Hello I want to make a copy of a table into a file in order to make a backup. $db = db_name; $dbh = new PDO("mysql:host=localhost;dbname=$db", 'user', 'pw'); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $TB = db_name.table_name; $backupFile = '../Backup/' . $TB . '.sql'...
  3. fomalhaut

    How to sort a html table

    Hello. I've a html table with five column: <table style="text-align:center; border-color:blue" border='1' > <caption><b>Liste des chants</b></caption> <tr> <th class="tri" onclick="<?php $_SESSION['tri']='cote_classement'; ?>; recall()" >C&ocirc;te</th> <th class="tri" onclick="<?php...
  4. fomalhaut

    Form in html/css positionning "search" button for an input type=file

    Hello I've this form (and it works) on my page : <form enctype="multipart/form-data" action="gesChants.php" method="post"> <!-- Création --> <fieldset><legend>Insertion d'un nouveau chant</legend> <input type="hidden" name="MAX_FILE_SIZE" value="200000" /> Nom du fichier partition : <br...
  5. fomalhaut

    php connect to multiple mySql Databases

    Hello. How many mysql databases can I create on my x10hosting account ? And if that is possible, with php can I connect multiple databases at the same time ? for example, can I have $db1 = user_database11; $db2 = user_database2; $dbconnect1 = new PDO("mysql:host=localhost;dbname=$db1"...
  6. fomalhaut

    Commit / Rollback

    Hello. In Php/Mysql, I want to insert rows into two inter-dependant tables T1 and T2. That is, when I insert 1 row into T1, I MUST insert the corresponding into T2. I've written two prepare statements for these inserts : $ins1 and $ins2, refering the two tables. $dbh->beginTransaction()...
  7. fomalhaut

    How to announce server is down ?

    Hello My web site is on the Chopin server, that is actually out of service, as you know. So, that's a question for the future : Is it possible (and how to do it) to give a "personnal message" when such a situation occurs such as "The site is temporary closed for work" in place of the actual...
  8. fomalhaut

    How can I test my robots.txt ?

    Hello. All is in the title. I've created a robots.txt in the public_html directory off my web site. How can I test this robots.txt is ok ? Thanks for your helps... And for all of you... Merry Christmas
  9. fomalhaut

    Security problem with history button

    Hello. The first page of my web site (php, html, javascript) is for public consultation, but there is a form which permits administrators to sign on (with user and password). When an administrator is signed on, he has a bigger menu, and so he can manage users and others things. That works fine...
  10. fomalhaut

    Controling time of user inaction

    Hello. On my page (written with php, mysql, html) after a user has connected himself (giving user name and password), the menu is changed, according to his "hierarchical level". I want to be sure he doesn't stay connected without action over a certain delay. How can I do that ? Does a...
  11. fomalhaut

    cPanel : problem with a text file

    Hello May be, it's not the good location... I've a problem in the file manager of cPanel with a text file (named "à_faire.txt") I created and I don't need anymore. I select it, and then clic "delete file". The systeme ask me confirmation, of course, I answer "Yes". The list is refreshed and...
  12. fomalhaut

    Problem with the "quote" PDO function

    Hello. I try to use the quote function of PDO to escape a string issued from a form. The connection with the DB seems to be establish, but I've this message : that's the function I use : include ('DB_Connect.inc'); include ('functions.php'); $ut = $_POST['utilisateur']; $pa =...
  13. fomalhaut

    Access denied using mysql_real_escape_string()

    Hello I've this message on x10hosting, that I havn't on my two personnal computers and I don't understand why! It's just at the begining of my script : This is the begining of index.php : <?php session_start(); include ('functions.php'); ?> <html><head><title>Fomalhaut</title> <SCRIPT...
  14. fomalhaut

    pb PHP using mysql prepare statement

    Hello. I want use prepare statement for a mysql insert statement but I have the following error : Parse error: syntax error, unexpected ':' in C:\xampp\htdocs\fomalhaut\gesUtil.php on line 2 I don't understand really how do I link this $dbh with my database which would already connected ...
  15. fomalhaut

    PHP and DOM

    Hello. I set a user value throught a form (that's ok). And I want this user to be visible in the "input form" during his whole session. here's the form: <form action="index.php" method="post"> Identifiant :<br /><input type="text" name="utilisateur" id="utilisateur" /><br /> Mot de Passe...
  16. fomalhaut

    passing variable's value from php to others

    Hello all. I've a problem in php. On a php page, I get the user's informations (user, password, etc...). On another php page, the user can change his password or his profile, but I don't want have to ask him again his user name. I've tried with session_start(); on the top of the first page...
  17. fomalhaut

    Manage Passwords

    Hello. I want to manage identifications and passwords for access to some lines of menu in my site. Is there existing php scripts I could get instead of writing it ? Thanks.
  18. fomalhaut

    pb with mysql_connect

    hello ! I've some problem using the mysql_connect function :nuts:. This is the beginning of my script, that works fine on my own computer : <?php $con = mysql_connect("localhost:3306"); $db = "usr_ayantdroit"; if (!$con) {die('Connection impossible : ' . mysql_error());} mysql_select_db($db...
  19. fomalhaut

    pb PHP with "include"

    Hello. I've these messages when I execute the index.php file of my site : Warning: include(ident.php) [function.include]: failed to open stream: No such file or directory in /home/usr/public_html/index.php on line 15 Warning: include() [function.include]: Failed opening 'ident.php' for...
  20. fomalhaut

    DB name problem

    Hello. I'm new to mysql ! On my computer, I've create a database with the 2 parts name "ayant_droit", but, when I want to create it on cPanel, it refuses the "_", and it seems to add my Ident as a prefix : "ident_dbname", and here with the "_" How can I create the name I want ? :nuts...
Top