Microsoft Access Dropdown List
l am building a new site using PHP which has a lot of pages pulling from an Access Database. I would like to have a dropdown list that pulls exhibitions from the database and then when the user selects one it shows the rest of the details from DB just below the dropdown list, hope that makes sense. Code:
View Complete Forum Thread with Replies
Related Forum Messages:
SQL Error: [Microsoft][ODBC Microsoft Access Driver] Too Few Parameters
I'm trying to execute the following SQL statement and get the following error. SELECT DomainNames.DomainName FROM DomainNames WHERE DomainNames.DomainName Like "*ab*" ORDER BY DomainNames.DomainName SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect I'm running PHP4, Apache 1.3.12 (Win32) and connecting to an Access database on a Win2K box.
View Replies !
Odbc_exec(): SQL Error: [Microsoft][ODBC Microsoft Access Driver]
i am trying to write to the database through odbc. i get the following error: Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in c:inetpubwwwroot514VIP_SurveyProcess.php on line 41 my directory has read/write permissions why am i getting this? here is the code as an example: ... $x = 10; $querySet = "UPDATE Survey SET $rdoOption = $x"; odbc_exec($objConn, $querySet); ...
View Replies !
PHP And Microsoft Access
Is it possible to use php to interface with an ms access database? Our current database (customers, suppliers etc) is in ms access format and we need to run msaccess. I dont feel like converting the whole database over to mysql and we still need the original system, the idea will be that the staff can access the database on the road thru a webpage.
View Replies !
Microsoft Access
I wanted to find out if any of you know the odbc equivalent to mysql_query I'm using a Microsoft Access DB and need to insert values into a table ex. mysql_query("insert into cart(cookieId, MaterialListID, qty) values('" . GetCartId() . "', $MaterialListID, $qty)");
View Replies !
Exporting To Microsoft Access
I have a PHP website with a mySQL database and a client wants to be able to see the database on his computer using Microsoft Access. I would like to be able to make a special backdoor section for him, where he enters his username and password and is given a link which will make take a snapshot of the mySQL database and convert it to a Microsoft Access database which he can download to his computer. Is this possible? Since he isn't very computer savvy I need a way as user friendly as possible to let him download the database and view on his local computer.
View Replies !
Microsoft Access -> PhpMyAdmin
Alright, so what’s going on is that I have coded an entire website with in mind to have an Access Database. So everything works great... But now I am faced with the problem that I have to have my webpage work with phpMyAdmin, which works completely differently in running my sql statements and everything, ie: ->EOF, select statement, etc... Is there a way for me to have a smooth transition for my code to work with phpMyAdmin instead of Access at the moment, because recoding all of this means an enormous amount of work with not much free time left on my hands. Code:
View Replies !
Insert Into Microsoft Access Table Using ODBC
The following lines of code don't return an error but they also do not insert the row into the database: $SQLText="Insert into member (MailingID, MemberID, [File As], EMail, LetterID, AudienceID, DateSent, Sent) Select $MailingCode, $row[0], '".$row[5]."', '".$row[6]."', $LIDToInsert, $AIDToInsert, '".$DateSent."', 1;"; print '<br>'.$SQLText; $rs_upd=odbc_exec($link, $SQLText); if (!$rs_upd) die("Couldn't update database"); I've tested the resulting $SQLText string in Access directly and it works find there so this must be a PHP or ODBC issue.
View Replies !
Inserting A Date Into A Microsoft Access 97 Database
I was wondering if anyone could help me insert a short date into microsoft access 97 using php? i can insert text no problem but i can't seem to be able to insert a date properly. i have been using //$date = "#" . "$sqlmonth" . " 1" . "$cboyear" . "#"; $strSQL = "INSERT INTO tblSupport (tDate) VALUES ($date)"; $result = odbc_exec($connect, $strSQL); Note: i can insert a date if i hard code it like putting in #01
View Replies !
Inserting Records Into A Microsoft Access Database...
I'm still new at using PHP although thanks to these forums I'm learning quite a lot. Currently, I am trying to insert a new record into my access database. I can display records from it but not add new ones. I know that I am to use the 'INSERT' SQL function but how would an Access Database be different from mySQL? So far I've seen only mysql examples and havent been able to find anything on access...
View Replies !
Dropdown List
I have a Dropdown list with Select with 1, 2, 3, 4, after select on of them it bust to refresh the page to what you select but it don't do it. PHP Code:
View Replies !
Dropdown List Box
I am able to populate data in a dropdown list box using php and mysql. However, I a wondering if i can add inside some icons such as close or More records, where the drop down acts to the specified request, ie., closing the drop down or fetching some more data from backend.
View Replies !
Populating Dropdown List
I am wanting to know how to populate the <SELECT> dropdown menu with all existing values from the DB and also have the value associated with that id selected. This is an updating area of my admin. Any ideas? Here's the code so far. At the moment it only retrieves the value assigned to that id. PHP Code:
View Replies !
Smarter Way Of Doing Dropdown List?
I've got a dropdown list that is acting as a filter on a table, so the user can select a value and the page is reloaded only showing the matching values from the database. Now when the page reloads the dropdown was set to 'all' as it was first in the list, even if I'd selected a different value, this was confusing for users, so I added an initial <option> field which pulled the correct value from $_GET (code below) - however this is a little odd as it means the value appears twice! Does anyone have a genius solution to this? I've seen a <select selected="yes"> sort of thing around, but I don't know how I can tell the php to add this value dynamically? <select size='1' name='occupation'> <option>".$_GET['occupation']."</option> <option value='All'>All</option> <option value='Student'>Students</a></option> <option value='Professional'>Professional</option> <option value='Hobbyist'>Hobbyists</option> </select>
View Replies !
Mysql Dropdown List
Im trying to automatically fill a dropdown list with data from MYSQL table. Sizes Table -------- ProductId | size1 | size2 | size3 | size4 | size4 | size6 | * the 'size' rows hold a numeric value for the quantity I have of each I was hoping to only list the sizes that have a greater number than 0. I have used an auto fill select code on another project but I'm just not sure how to fill in the blanks. Code:
View Replies !
Check The Dropdown List
i have a drop down list in my php code. i need to check the drop down list is set or not. for that what is the code. i heard that there is no php code for that. javascript is needed. my code is here. PHP Code: <?php $database="sms";                    /* DB name       */ $host="localhost"; $user="root";                        /* Set DB Username */ $pass="";                            /* Set DB password*/ mysql_pconnect($host,$user,$pass);  /* DB connect....*/ mysql_connect ($host,$user,$pass); mysql_select_db($database) or die( "Unable to select database"); /*DB Select*/ function orgresult() .......
View Replies !
Add Variables To Dropdown List
I have a list of variables: $variable[0] $variable[1] $variable[2] The amount of variables changes so i've used $total = count($variable) to find the amount there are. How would i tell php to create a dropdown menu with the amount of options=$total and then fill the options with $variable[0] etc. I know i can use a loop to increase the value of say $i by one each time to that i can use $variable[$i] each time, i'm just stuck with adding the whole thing to a dropdown menu with the right number of option...
View Replies !
Autopopulate Dropdown List From Database
An events-registration page with a form containing a dropdown list for upcoming events, the events will be pulled from a table which is updated by...? what i've gathered so far is that this can be done with PHP. I am a little unclear on the concept of how this is done. How does the updated information get input into the table? 1) can this be done (updating database) through a web interface by the client, or is it something i would have to do locally and then upload. If done by the client, can he delete/edit existing information--assuming he is not familiar with code. 2) what other things aside from html(good), sql(so-so), and php(newb) will i have to know? i've seen a lot of good tutorials here and will have access to the necessary software. I just want to know if there is anything else i should know before i dive in head first without testing the PHP water, which i assume is frigid.
View Replies !
Dropdown List Of Files In Folder
I am preparing a form that includes a drop-down list consisting of the names of files in a certain folder on the server. I only need to trap the file name (jpg), not the path and I'm not trying to upload the files or anything - simply allow the user to select one of a number of different image files (they're actually location maps).
View Replies !
Dropdown List - Trying To Get Default Populated From Db.
Nooby question but when I try and get this to work (it should identify which rows in the database have GK, MID, DEF, FWD against them and then put SELECTED into the option value to give a default of what the entry is currently) it just adds SELECTED to all the results as if $row["Position"] is returning true against all four conditions? What am I doing wrong? CODE:..
View Replies !
Cascade Dropdown Or Conditional List
I would like to create a conditional cascade form. based on the selection, it can display or not display an input form for the user to enter an string of text. then at the bottom of the page (or when a user submit) connect all the sections including the input field all together (it's like a story maker?)
View Replies !
Trying To Create Dropdown Menu From List
I am trying to create a dynamic dropdown select menu from a directory containing other directories and files. This is to select a certain page from the list so I can edit it. I only want the files in the menu. Here's what I have so far but it doesn't populate the dropdown. Code:
View Replies !
Dropdown List Selected By Default?
Does any one know how to have an item in the dropdown list selected by default? $city_field = HTML_QuickForm::createElement('autocomplete', 'city', 'City', $cities); $cities is an array of city names and I would like, say 'Los Angeles' selected by default.
View Replies !
Dropdown List - Insert Into Mysql
I simply want to add a dropdown list where, when an option is selected, its value will be inserted into a dbase table. More specifically, asume there is a page where the user sees his order. He will be able to select the order status (pending or delivered). So, for example, if his ordered is deleivered, by selecting "delivered" option, "delivered" will be inserted into the 'Status' column. Code:
View Replies !
Auto Fill Dropdown List Error
Im using the code below to autofill a dropdown list from my MYSQL DB. The only problem is it is leaving out the first entry (alphabetically) for each $vehicle_make ? Does anyone know why this may be hapenning? Code:
View Replies !
Stuck On Dropdown Menu List, Could Use Some Guidence
I have a form with some drop down list/menus. I do a check for ommissions and if found display a message to re-try. What I need is a way to show which options where chosen when the user submitted the form the first time. If someone could show me how to do the first one, I'm sure it's the same process for the second one. Here's the code:
View Replies !
Auto Fill Date Dropdown List
How would I modify this code to display the years in the dropdown list like so: current year 2006 2005 back 50 years <select name="year" id="year"> <?PHP for($i=date("Y"); $i<=date("Y")+2; $i++) if($year == $i) echo "<option value='$i' selected>$i</option>"; else echo "<option value='$i'>$i</option>"; ?> </select>
View Replies !
Creates A Dropdown List Of Information Belonging To That User.
I have a page that uses php to look up specific fields in a specific table of a specific database based on the username. Using this, it creates a dropdown list of information belonging to that user. The fields in question each have 13 pieces of data. Based on what they click in the dropdown box, I need that specific data to pass onto hidden fields on the page. Code:
View Replies !
Pick From A Drop Down List That Automatically Gives Options In A Second Dropdown Box
does anyone know how to create a form that allows the user to firstly pick from a drop down list that automatically gives options in a second dropdown box. eg. 'category1' is selected from dropdown box 1, this then populates dropdown box 2 with the options 'category1.a' or 'category1.b' or if 'category2' is selected from dropdown box 1 then dropdown box 2 gives the options of 'category2.a' or 'category1.b' i f any one knows how I should code this please help, if not point me in the direction of a tutorial that can.
View Replies !
Dropdown List Which Selects A Post A Title (to Edit)
I want to have a dropdown list which selects a post a title (to edit), then when you click submit I want to use POST to submit the data for that post (post title, username, subject, content) so that the edit pages form fields will already be filled with the posts data.
View Replies !
Mysql Mailing List Convert To Odbc For Access
im working on a modifying a mailing list that i found, that will allow me to send email to certain addresses located in a access database. I dont get any error, but I am not receiving the email. i setup myself in the database, residing in a state that no one else is from, so i can test mail to myself. Code:
View Replies !
Dynamic Dropdown And Hardcode Dropdown In Select Form
I have plenty of examples of dynamic dropdown choices but none of hardcoded dropdown choices. The ultimate goal is to have a job with various tasks and to track the status of those tasks for a given job. I've used one of the tutorials here to begin the process. Below is the code I have to add work on a given task. Perhaps I actually need to "Update" a job as opposed to "add". But the problem of the moment is I can't seem to hardcode one set of my options. This is the code I have: PHP Code:
View Replies !
Microsoft SQL Connection
I am looking to have a php page that will have a required include of a config file with the MS SQL connection creation. I want to have a form that saves into a MS SQL database. Could call out to a stored procedure or have inline code in the php page. Anyone have examples or generic sample code I can use?
View Replies !
PHP And Microsoft Word
I have users who can sent a Word document as an attachment to an email from a Microsoft-rich environment. I would like to be able to "capture" that attachment as a blob and deposit it into a mysql database. I am not sure how to do the capture.
View Replies !
PHP To Microsoft Outlook
Is it possible to send meeting notifications to microsoft outlook through php? I guess it would be sort of an e-mail sent to an individual telling them they have been invited to attend an event and the event info is automatically added to thier outlook calender or something?
View Replies !
Php+microsoft Sql Opinion
I use php with my mysql database a lot. I just had something come up where I need to access data from a microsoft sql database. Are there many problems with connecting php with a microsoft sql database? Would I be better off to use something like visual basic with asp?
View Replies !
Microsoft Frontpage
Is it easy to incorporate php into a microsoft front page website. I find it extrememly easy to create beautiful looking websites with frontpage but i want to add dynamics with php to it is that possible.
View Replies !
Microsoft SQL Server
I installed on my machine Apache2, PHP 5, and Microsoft SQL Server 2005 EXPRESS Edition. The op.system is Win2000. The problem, I can't connect to the SQL server via PHP. The PHP works, the sql server works(can accept connection with MSDE Query), and uncommented the line in php.ini about mssql extension. I tried with PHP 4.4.1 also, but still not working. After that I installed the SQL Server 2005 (not the Express version, but the 180 days trial version) on another machine, allowed remote connection, and I can connect to it via php without any problems.
View Replies !
Microsoft Word
I have an interface which allows people to manage and add customers. Each customer also has a category, for example 'Builders' I need a way of being able to do a mail merge to all clients with a selected category which is initialised from the web interface. For example, at the moment I can connect to MySQL and get all customers and if I go slightly further I could create a filter to do just what I need from within word. However, I need to be able to have the user choose which category from within their browser then click a button and it automatically does this filter. I was thinking maybe somehow I could export all users in a category to a CSV file and then have a mail merge doc setup which automatically pulled data from this each time the document was loaded - this would be OK I suppose if a word file could be opened which automatically had the desired filter.
View Replies !
Microsoft SQL ORDER BY
I am having a problem, I need to ORDER BY a "Reference number" field in my MS SQL DB, The only problem is, it is a varchar as it contains ref#'s like 1a, 22b, 43c. Obviously, with a straight ORDER BY I get a sort like 1, 10, 11a, 11b, 2, 21, etc I tried "CAST(SUBSTRING(ref, 1, 2) AS Integer)", however the lengths of the strings are different, theirfor I will get an error, "Can't convert 8a" etc. Any ideas on how I can sort this properly?
View Replies !
Microsoft SAPI Problem With PHP
As I've found tons of VB and C# sample codes, I was trying to transform it into PHP code, using the COM objects. My aim is to create a simple html, that creates a wav from a text. Here's what I've tried -the php script part-: $Voice = new COM("SAPI.SpVoice");//works //com_load_typelib("SAPI.SpVoice"); //This doesn't help... $Voice->Speak("Hello!"); //works $FileStream = new COM("SAPI.SpFileStream"); //works - I mean no error $FileMode = SpeechStreamFileMode.SSFMCreateForWrite;// = 3 //works - no error $FileStream->Open("c:a.wav", 3, false); //works - no error $Voice->AllowAudioOutputFormatChangesOnNextSet = false; //works - no error $Voice->AudioOutputStream = $FileStream; //HERE'S THE PROBLEM $Voice->Speak("Hello world",1); $FileStream->Close(); Here's the error I get for that line: Uncaught exception 'com_exception' with message 'Error [0x80020003] Member not found
View Replies !
|
TRACKER
