simpson_121919

I have a alphabet link list that is inline, this list consists of all the 26 letters of the alphabet. I don't want spaces in between each character. The problem is that when I use carriage returns in my code(so that it is readable and not one long line) I get spaces in between the letters in my alphabet link list. Not sure how to fix this, any help would awesome, thanks.

That was it, I looked at that code for awhile and did not see that. I think I have been at this too long and need to give my eyes a rest. Thank you for the advice and help.

I am trying to use a SELECT count(*) to check if a given record exists but its not working and always returns FALSE. I am stumped. At the very least I would think it would return 0. I have checked the SELECT statement in myphpAdmn to make sure that was not the issue. Here is my code - $Qchoice = "SELECT count(*) FROM collect_temp_table WHERE user_ID=:userID AND gID=:gID AND rID=:rid"; $QchoicePreped = $dbh->prepare($Qchoice); $QchoicePreped->bindParam(':userID',$userID,PDO::PARAM_STR,75); $QchoicePreped->bindParam(':gID',$gID,PDO::PARAM_STR,; $QchoicePreped->bindParam(':rID',$rID,PDO::PARAM_STR,3); $QchoicePreped->execute(); $QchoiceResult = $QchoicePreped->fetch(PDO::FETCH_NUM); Any help would be appreciated, thanks.

Thank you very much, that solved my problem. I never thought to "textarea[<?php echo $databaseId; ?>]" This makes my textarea identifiable because I know where in the array it will be stored. Thanks again.

I have a web application that has about 700 rows, each rows has a html textarea for the user to add personal notes. I would like to pass text of some sort along with what the user typed typed into the textarea box. I want it to be hidden from the user. Any ideas? Any help would be appreciated, I've been stuck on this one for awhile. Thanks

Thanks that did the job. I had spelled my database table name wrong. I think Im going to realy like those functions. Thanks again I really appreciate it.

Here is the code I have been using - <?php $first_name = $_POST['firstname']; $last_name = $_POST['lastname']; $when_it_happened = $_POST['whenithappened']; $how_long = $_POST['howlong']; $how_many = $_POST['howmany']; $alien_description = $_POST['aliendescription']; $what_they_did = $_POST['whattheydid']; $fang_spotted = $_POST['fangspotted']; $email = $_POST['email']; $other = $_POST['other']; $dbc = mysqli_connect('localhost', 'root', 'x', 'aliendatabase') or die('Error connecting to MySQL server.'); $query = "INSERT INTO aliens_abduction (first_name, last_name, when_it_happened, how_long, " . "how_many, alien_description, what_they_did, fang_spotted, other, email) " . "VALUES ('$first_name', '$last_name', '$when_it_happened', '$how_long', '$how_many', " . "'$alien_description', '$what_they_did', '$fang_spotted', '$other', '$email')"; $result = mysqli_query($dbc, $query) or die('Error querying database.'); mysqli_close($dbc); echo 'Thanks for submitting the form.<br />'; echo 'You were abducted ' . $when_it_happened; echo ' and were gone for ' . $how_long . '<br />'; echo 'Number of aliens: ' . $how_many . '<br />'; echo 'Describe them: ' . $alien_description . '<br />'; echo 'The aliens did this: ' . $what_they_did . '<br />'; echo 'Was Fang there? ' . $fang_spotted . '<br />'; echo 'Other comments: ' . $other . '<br />'; echo 'Your email address is ' . $email; ?> I keep getting the die function read out 'Error querying database' I'm wondering if Im using the right username. How do I check to make sure I have the right username.

I have been trying to insert data into my database thru php script with no luck. I think its has to do with not being able access my database. My question is when I use MySQL command client and enter the password and get mysql> does that mean I can use that password to access my databases as long as I point to the correct database with the mysqli_connect function. I dont think I fully understand how this works. I have everything stored on my local computer and I use "localhost" in mysqli_connect function.

Xampp isnt compatible with 64 bit systems. If you have a 64 bit system you should look at Wamp. It has 64 bit support. I will be downloading and installing Wamp soon myself.

Ok thats what I thought, Maq had me second guessing myself. It looks like it might be a windows security issue. I'll have to look into that. Thanks for the help.

I'm glad you brought that up because one of the many tutorials that I have gone thru brought that up and I made sure to do what was necessary. It is saved as php.ini Does this file need to be in C:/windows

So the value Loaded Configuration File should be c:/windows/php.ini?

I was looking at a old tutorial and noticed that they had you edit a php.ini file that you were to put in c:\windows . Is this required on the newer versions of PHP. I'm using 5.3.5.

Thanks, I checked that and it is C:\PHP\php.ini which is the filel I've been editing. I'm beginning to think it has to do with windows 7 and security issues. I guess I will have to stick with the Command Client for now. Other than the phpmyadmin being a graphical interface for easier use is there other advantages in using phpmyadmin? Also this might be tied into my problem. When I download MySQL and I get to the password part of the wizard I have to enter three passwords. The old one, the new one and the new one again to confirm. Apparently my old password is in the system from the first time I installed MySQL. I made all three passwords the same. I used Ccleaner which usually uninstalls everything so I'm not sure about this password thing.

i dont have a php.ini in my bin file. I will look into this and make sure I am editing the correct php.ini file

I was wrong about the apache server. It seems to work just fine execpt that I have to start,stop and reset it in the control panel/admintrative tool/... instead of just doing it from the start menu/all programs/apache...

I tried to go the xampp way of doing it but it wasnt until I went through the whole processes that I learned xampp doesnt support 64 bit systems(this should be on the main pg, its not!). So I reinstalled everything again for the umpteenth time and still the same problem. I followed the tutorial(others also) to the t and I'm at a total loss to what is going on here. Yes I am. I'm using PHP/php.ini . I wasnt aware that there was others. Im having weird things happen with my apache server and I'm thinking maybe thats related. For me to restart my server I have to restart the pc. When I try to do it in the control panel is says something about port 80 not accessible which makes no sense to me because this is all for local development on my personal pc. JCbones -Thanks, I looked at that tutorial and it does the same thing as the one I've been using.

I did restart it. Looks like I might just have to start over and use xammp. I thought by installing them individually I would learn a lot more but this has been nothing but a headache. Does myphpadmin come with the xammp package?

If your php.ini did not already have a line in it to load the mysql.dll that you simply needed to uncomment and restart your web server, then it is likely that the method you used to install php requires that you do something completely different to enable an extension. How exactly did you install php? My mistake it did have a line in it to load php_mysql.dll. I installed all 3 indivdually without the ssl or the msi installer

jcbones - I'm using Apache. I did find the php_mysql.dll file in a ext. folder. I also did as followed below and still no luck. ;extension=php_mssql.dll extension=php_mysql.dll //<-DO IT HERE-> NOTICE A DIFFERENCE IN THE NAME. extension=php_mysqli.dll ;extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client ;extension=php_oci8_11g.dll ; Use with Oracle 11g Instant Client ;extension=php_openssl.dll ;extension=php_pdo_firebird.dll

This is the error I recieve when trying to load my index page in phpmyadmin - -Cannot load mysql extension. Please check your PHP configuration. - Documentation- Not sure what it means but I have tried a lot of things and cant seem to get phpmyadmin up and running.

I put in the code and I'm still getting the same error. Maybe its just a simple syntax error that Im not seeing. Here is the code - ;;;;;;;;;;;;;;;;;;;;;; ; Dynamic Extensions ; ;;;;;;;;;;;;;;;;;;;;;; ; If you wish to have an extension loaded automatically, use the following ; syntax: ; ; extension=modulename.extension ; ; For example, on Windows: ; extension=msql.dll ; ; ... or under UNIX: ; ; extension=msql.so ; ; ... or with a path: ; ; extension=/path/to/extension/msql.so ; ; If you only provide the name of the extension, PHP will look for it in its ; default extension directory. All I did was remove the semicolon from extension=msql.dll Here is the code for config.inc.php - <?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * phpMyAdmin sample configuration, you can use it as base for * manual configuration. For easier setup you can use setup/ * * All directives are explained in Documentation.html and on phpMyAdmin * wiki <http://wiki.phpmyadmin.net>. * * @version $Id$ * @package phpMyAdmin */ /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] = 'happy'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ /* * Servers configuration */ $i = 0; /* * First server */ $i++; /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* Server parameters */ $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; /* Select mysqli if your server has it */ $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['Servers'][$i]['AllowNoPassword'] = false; /* rajk - for blobstreaming */ $cfg['Servers'][$i]['bs_garbage_threshold'] = 50; $cfg['Servers'][$i]['bs_repository_threshold'] = '32M'; $cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600; $cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M'; /* User for advanced features */ $cfg['Servers'][$i]['controluser'] = 'root'; $cfg['Servers'][$i]['controlpass'] = 'running'; /* Advanced phpMyAdmin features */ // $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; // $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; // $cfg['Servers'][$i]['relation'] = 'pma_relation'; // $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; // $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; // $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; // $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; // $cfg['Servers'][$i]['history'] = 'pma_history'; // $cfg['Servers'][$i]['tracking'] = 'pma_tracking'; // $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; /* Contrib / Swekey authentication */ // $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf'; /* * End of servers configuration */ /* * Directories for saving/loading files from server */ $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; ?>

Hello, I get this error when trying to load phpmyadmin. From what I have read so far it sounds like I need to enable php_mysql.dll extension but I cant find this anywhere in my php.ini file. Im running a apache 2.2 PHP 5.2 and MySQL 5.1. Im a beginner and really want to get started learning PHP, any help would greatly appreciated.

so if I install the phpmailer does it overide my [mail function] in php.ini or do I have to reconfigure that or does the phpmailer do it for me?

I did not. I just assumed that it was part of the apache server software. Im doing all the testing of my php scripts on my local computer so what would be the best way to go about solving the mail server problem.