How To Access And Modify And Add Records In MySQL Table From A Windows Client?
The MySQL table is located in a Linux Server OS, so I need the
information from that table for updating Paradox tables in Windows OS.
If a PHP program in the Linux Server can save a file with the
information I need, can I make a PHP program in Windows OS to get the
saved file or even better, to access the table in the Linus Server OS?...
View Complete Forum Thread with Replies
Related Forum Messages:
How To Control Access To Specific Mysql Records For A User
I am just trying out a php form, when posted submits data to database. The system is we allow everyone to submit the form. As administrator I can view and edit the records. But whoever submits the form should be a registered user and he should be able to only view his records but not edit.
View Replies !
Having Trouble Looping Through Records In A MySQL Table
I'm having some trouble looping through the records of a MySQL table using PEAR DB. Here is my code: $navigationSql = "SELECT * FROM nav"; $navigation =& $db->query($navigationSql); while ($navigation->fetchInto($nav)){ define("NAVIGATION", "<a href="$nav[2]" target="$nav[3]" title="$nav[1]">$nav[1]</a><br />"); } The when I enter: print NAVIGATION; into any of my PHP scripts it should loop through the stuff in table named nav, but it is only displaying the first record and so far everything I've tried does not seem to make it loop through all of the records in the table and I can't figure out why not.
View Replies !
Transfer Edited Records From One MySQL Table To Another
What I need is for a user to search a certain database table for a purchase order #. The results then need to be displayed in textboxes so they can be edited as needed. Then the edited records need to be inserted into another table, and deleted from the former. I have the first two steps coded, but am having trouble figuring out how to do the third correctly. Here is my code:
View Replies !
How To Modify Records With A Button Or Check Box...?
I need some help creating a "modify / update records" page. Something that will grab a record and allow the user to post information into the fields that haven't been filled yet. I already have my create record page, I just don't know how to make a modify page. I'm also not sure if I should use checkboxes to select the record then modify on a different page or just allow the user to modify on the same page. The theory behind the worksheet is a person enters the customer name and date the contract is created. When we get confirmation, the person who received the confirmation enters the date it was received, the person who received it and who it was credited to.
View Replies !
Count,sort,diplay Number Of Records In MySQL Table
I am designing a search engine using PHP/MySQL and I am logging all search terms into a MySQL table. I was wondering how I count the number of occurences of a term in the table, and then sort and display the terms in descending order. For example, if the column in my table with search terms looked something like this: clothes casinos clothes homes homes clothes How can I count and order the records so that I can display according to how many times they appear, like so: 1. clothes(3 entries) 2. home(2 entries) 3. casinos (1 entry)
View Replies !
Get Windows Client Login
I have to create an intranet website by php, sql server and IIS. One requirement is to get the user name from the windows client login. I'd like to know if it is possible, and if yes how? I think it should be possible by asp, but in php?
View Replies !
MSSQL - Unix Client / Windows Server
I need to access a MSSQL 7.0 database on a Windows NT Server from a Linux PHP Web-server. I have looked at FreeTDS, unixODBC and iODBC. unixODBC seems the easiest but alas one need to buy licenses. iODBC is a bit slow, apart from the ODBC part containing many connection layers, it also has a request broker/client running on top of the ODBC. FreeTDS seems like a decent solution. It even has the option of using TDS in conjunction with iODBC. This eliminates the use of the extra request broker/client. Furthermore I've read somewhere that one can use the Sybase functions of PHP to connect to a MSSQL server since both use the TDS (Tabular Data Stream) Protocol. What method would be the easiest and/or could be implemented using the ADOdb database abstraction layer class?
View Replies !
Client Filesystem Access
I want to deliver subscripted content to users on CD. They then place the CD into their CD drive and navigate to my site. Once logged in, I want to be able to draw content from the CD and incorporate it with content from my server. I understand that access to the user's filesystem is not normal or even allowed by default. However I am wondering if there is a workaround to this limitation. In Javascript, I can offer the user a security certificate that, if acknowledged, will allow me to access their filesystem. Is there something like that in PHP?
View Replies !
Php Session Problems When Working With A Windows Client Program
I am currently involved in a project that involves a windows client program written in delphi and a web application written in php. I have made several php pages for the delphi program to do requests via the http component from INDY. the problems I am having are: 1) the first request from delphi app to php web app is the authenication. In which user sends username + password to the php app. If authenication is valid, a session is started and the sid is returned to the client. All subsequent requests from delphi app to php web app will have this sid as one of the arguments in the POST form request (this is one of the function in the INDY component for delphi). Even the sid is passed to the subsequent pages, the session global array is still undefined. However if I open up a web browser and create my own string request to the login page then the next page, the global array would be defined (using var_dump + echo to see the array) what is the problem? 2) does the above problem has anything to do with the http referer field? 3) this problem that I am having has been asked before on google group, but somehow the person who asked it didnt' put down the solution for it. (this only involves the web only) when I login on a page and return with a session id, then I log out.. the user is redirected to the login page again. However if the user login again (with a different login account), he would be presented with the same session ID as before. a different sesson id is presented only if the user restart the browser. why is that happening?
View Replies !
Restricting Access To A Records Contents
I have a table called Reports . These are reports of different users . Now if 2 users attend a meeting, they each make separate reports which get stored. When a third user attends another meeting on the same subject, he creates a third record. I have been fiddling around with ways of updating records such that a single report can be updated by all 3 users. But it results in even a 4th user being able to view the report (if not update) and i just dont know how i can limit this. The issue here is that a situation can arise when the 4th user may need to read the report but until the time he needs to, i dont wish to allow access to that report. Code:
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 !
MSSQL Access Via PDO And Windows ODBC
I'm running a "Windows Server 2003" with "MS SQL 2000" IIS and PHP5.1 as test environment for my project. I would like to access my MSSQL-Server via Windows ODBC and PDO. I created a System DSN an i enabled the PDO extension in my php.ini. But the following code snippet keeps failing: <?php try { $DB = new PDO("odbc:LocalServer"); } catch (PDOException $e) { echo $e->getMessage() . "<br>"; exit; } ?> Here is the error message: "could not find driver"
View Replies !
Send Mail From Windows Without Access To Php.ini?
I've found example on how to send email using PHP on Windows 2000. However they all say to set the outgoing SMTP server address in the php.ini file in the Windows system directory. That's a problem for me because I intend to upload this to my hosting company's server, where I do not have access to the system directory. Each user on this system has their own virtual mail server. Is there a way to specify the mail server in the script itself?
View Replies !
Windows Network File System Access
I'm trying to get an intranet application to create folders on another machine, on the same network. I can get to it via '192.168.7.201FolderName', and have also mapped the network location '192.168.7.201' the the drive 'S'. Code:
View Replies !
Access Active Directory (of WINDOWS SERVER 2003) Via LDAP
I want to read user information from the microsoft windows 2003 server. In the windows server 2003, i've create a domain, called "wissenskolleg". I've assigned a password to it. Now, i want get access to the Active Directory with PHP. My code: $ds=ldap_connect("wissenkolleg.com"); $r=ldap_bind($ds,"administrator","psword"); Always I've get the following error message: warning: ldap_bind(): For Unable ton bind tons of servers I've found out, that $ds always return: Resource id #2 If i changed "wissenkolleg.com" in "whyitis", it is all the same, i've can only read: Resource id #2 and the same error with ldap_bind.
View Replies !
Can MySQL Modify
I've seen a web program which uses .mdu files. What exactly are these and how do they work as I can't seem to find much information on the net.
View Replies !
Displaying # Of Records In A Table
Can anyone throw me a link to some prefab code, or a tutorial on how I can get a page to display the number of records that meet a certain criteria. example: I have a page that stores information on audio FX. I'd like to include a feature that would let the users know how many items are in a particular section. Player (10) Items (5) Weapons (0) etc. All help appreciated,
View Replies !
Counting Records In A Table
Ok, I am trying to count the number of records in one of my tables. Seems simple. BUT! its not working. It returns a 2 no matter how many records are in there. Heres the code. <?php $sql = "SELECT count(*) from cam"; $result = mysql_query($sql); ?> I would think this would work. I have also tried mysql_num_rows, and max(), and sum()... a little help would be appreciated, and why is it returning a 2?
View Replies !
Delete Records From A Table
I have a table its called queue. It has a field called id. I want to delete all records in the table apart from the ones with id equals to 74 or 75 or 87. How do i do that?
View Replies !
Displaying Records In Table
I have a table that I want to display some records from my database. I have a specific spec I'd like the table to conform to, 3 cells wide. I can get the data into a cell. But my problem is, I'd like the table to have the 3 cells fill and then have the additional data create a new rows and continue on infinately.
View Replies !
How Do I Get The Total Records From A Table?
It also shows the total submissions. Right now, when you choose to view by a particular topic (for example, select a region - California) the total submissions only shows for those results (which right now is 1). I'd like to show the total results not just for California (which right now is 4). Code:
View Replies !
Delete Records From Table 1
I have a script that doesn't delete records from one database when it should, and now I have to do this myself because database is big and causes problems on the server. What I have is: TABLE 1, field auction TABLE 2, field id so I would like to delete all records from TABLE 1 where the value of the field auction doesn't match the value of the field id in TABLE 2. Can someone help me on this, please? I need to get this database cleaned.
View Replies !
Table Row Records For Editing
I have a repeat region of a table called userid. What i¹m trying to accomplish is being able to edit the record and then update it by clicking a submit button on the same line. I¹m doing it this way so the user can quickly update a number of records one at a time. I know I could do this by passing the userid info to a detail page but really want to do it the way described.
View Replies !
Showing Records In A Table
I am busy with the site of the company I work for. We have a section where al our partners are mentioned. At this moment this is a static part of the website that I want to make dynamically. This is the url of the static page and how it should look like: This is the url of the dynamic page I created but it doesn't work the way that I want: This is the php code I used: Code: <?php $i=0; echo "<tr>"; while (list($id, $vlag, $land, $bedrijf, $website, $email) = mysql_fetch_row($result)){ echo "<td><table>-Content with the data of the records-</table></td>"; if($i % 2 == 0) { echo "</tr><tr>";.
View Replies !
AJAX To Display New Records In A Table
Instead of refreshing the entire page to show the new fields in a table, I was wondering if it would be possible to use AJAX to display the new records in a table. For example: Messages are entered into the DB. I use PHP to create a table that displays the messages. Instead of refreshing the entire page to show the table with new messages, how can I use AJAX to show the new messages in the table without refreshing the entire page?
View Replies !
Counting The Number Of Records In Table
I want to count the number of records which apply to a repeating id field. (the user id remains the same, but their are several records which relate to the user. I want to know how many records in the table exist for a specified user id) Does anyone know a function for doing this?
View Replies !
Linking Multiple Records From Another Table
I'm not sure I'm even thinking about this the right way, but here goes: I have a table of users. Each one of these users may be associated with none, one, or many records in another table I call a todo table. table user = 'id', 'name', 'bla bla bla','todo_list' table todo = 'id','title','other info' Suppose user 'id=1253' has on his todo list items 756,241, and 672. I create a string 756,241,672 and store that string in the user's todo_list field. Then when I want to display the todo items I get the string with a query, bust it up into an array, iterate the array and query the todo table. I have a gut feeling I'm making it way more complicated than need be. But I can't think of any other way to do it
View Replies !
Table Join Count Records.
got my counting records script just the way I want it, now I've read all the posts on Joins, and read the manual and mysql.com.... but can't seem to get the right number to come out. I have two tables: table1 & table 2 table one has a field called ID and field two has a field called relID (this is the link between them) I want to count all of the records in table two where the relID is equal to the table 1 ID field. I thought this would do it, but the number it returns is wrong: PHP Code:
View Replies !
Copy Select Records To New Table
In the table Step I have multiple records for each given id. I want to save the current list of records for an id to a new Step_Old table so I can look back at what I had at a given point in time, since the records for an id in the Step table will change over time. Now the question... does anyone have a slick way to do this, or do I need to Select all the records I want to save and then save them one by one with a while loop into the Step_Old table?
View Replies !
Checking $_POST Against Records In Table
I have a table containg name, description, url which contains many records When I submit a new form, I want it to check the url fields in the table and check it against what I have posted. Therefore something like $check_table = function here to get all urls if($_POST['url'] == $check_table) { return false; } else { return true} However, how do I get all the urls and get it to check each one?
View Replies !
Insert Multiple Records In Table
I want to use a form to insert multiple records into a table. I have an book club where a person would rank a book (3 to 1) next to a particular book read for a particular month. 3 being the most favorite book read that month and 1 being least favorite. Below is the table the records would be inserted into. Key----Month--------Reader---------Rank-------Book 1-------January-------Jim--------------3----------Bible 2-------January---------Jim-------------2----------Koran 3-------January---------Jim-------------1-----------Torah How can I have a form where the reader sees only (and fills in) the rank and book text fields, and the Key, Month, and Reader fields are filled in behind the scenes with the default info when the form is submitted .
View Replies !
Delete Selected Records From Table.
Can anyone see why this connection doesn't work? It's suppose to delete selected records from my table. <?php if (isset($_POST['delete'])) // && isset($_POST['delcus'])) { foreach ($_POST['delcus'] as $val) { echo "$val"; $conn= mysql_connect( "localhost", "user", "password" ); $sql = mysql_select_db( "snow" ); $del = mysql_query("DELETE * FROM request WHERE qid =" .$val); //$rows = mysql_num_rows($del); $rs = mysql_query($conn, $sql, $del); if($rs) .........................
View Replies !
Checking If Any Records Exist In A Table
I've had a few problems with the mysql_fetch_array() string, and have worked out that it's because there are no records in the table. Does anyone know of a way of checking if there are any records, so that I can create an if statement?
View Replies !
How To Paginate Table To 1/2 Records Per Column
I am setting up a scrapbook page and we will be adding images all the time. I have a dynamic table to show the image, link and description but I want to break the columns to automatically show 1/2 the images in the first column, and the other 1/2 (or less if its an odd number of images) in the right column. Code:
View Replies !
Adding Multiple Records To A Table In One Form.
I have one form in a php page. In that form there are several rows, each with several input boxes. These rows represent individual products and their price. You may add as many products as you want by clicking a add product button and it will add another row using javascript. When you are finished adding your products you then click submit. For each product I would like it to insert an individual record in the products table. For example if you add 10 products, when you click submit it will add 10 records in the product table.
View Replies !
Select All The Records In A Table That Were Input Last Month
I am trying to select all the records in a table that were input last month, example:if month today is October select all record with month of September The query I am using is PHP Code: SELECT payments.*, members.* FROM payments, members WHERE payments.coupon_id = 餞C554360' AND payments.member_id = members.member_id AND payments.begin_date < NOW() - INTERVAL(1 MONTH) This display an error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'MONTH)' at line 1 I am not sure if my query is written correctly.
View Replies !
MySQL And PHP - Modify The Html Code In The Content
I'm using mySQL and PHP on a webhost, and WordPress. ... Wordpress is what I'm using to make it easy for my pops to post articles. My index.php uses some code to pull from the mySQL db (created by wordpress) and puts the post content into a div, then p class. However, I'm noticing that when the content contains html coding, it seems to fall out of the class and lose it's padding. Is there some command I need to use to modify the html code in the content when it's posted to my page? Below is what I think is the relevant code: You can check the results at www.meetwithkbh.com (yes, it's got a goal). If there's no html like <ul>'s and <li>'s included in the post, it formats fine with the padding, but - if there is, it'll drop out of the padding that i'm trying to keep. <?php $db = mysql_connect("localhost", "mywordpressdb", "*******"); /*no, these aren't the real user/pass ;) */ mysql_select_db("dbwordpress",$db); $result = mysql_query("SELECT id, post_title, post_content, post_date_gmt FROM wp_posts ORDER BY post_date_gmt DESC Limit 0, 5",$db); while ($myrow = mysql_fetch_row($result)) { echo "<div class="post"> <p class="posttitle">"; printf("%10.60s", $myrow[1]); echo "</p>"; echo " <p class="postcontent">"; printf("%10.400s",$myrow[2]); echo "...<a href="More.php">Read More</a></p> </div><br /> "; } mysql_close($db); ?> Here is the css, contained in the index.php too, which is in the proper place in the index.php: ..posttitle { font-size: 120%; font-weight: bold; color: white; background: #806C59; padding: 3px 3px 3px 1em; margin-top:0em; } ..postcontent { padding-left:2em; padding-right: 2em; text-align: justify; } ..post { border: 1px solid #cccccc; line-height:1em; }
View Replies !
Query Problem: Counting Records From Another Table Without Using A Subquery
I'm working on a rather complex SQL query, which retrieves a list of clients that match certain criteria. One of the criteria I need to test is the number of business days that have elapsed since the client's enrollment. To facilitate this, I've created and populated a table called business_days - containing one record for every business day (non-weekends and non-holidays) for the next ten years. Using this, I can just count the number of business_days between two dates, like this: Code:
View Replies !
Moving Through Records In Table In A Single Record Page
I'm trying to create a updates pages that I can move either to the previous record or the next record within a recordset without having to return to the repeating list of records after each up date. Assuming I have done the recordset correctly, which I have and the update records command as well here is the code I'm trying to use: Code:
View Replies !
Create Dynamic Table With 3 Columns And Unknown Number Of Records?
I'm trying to create a table with only 3 columns, but the problem is I don't know how many records will populate the table so need it to automatically create <tr> and </tr> tags every 3 records. How best can I do this? At present the code below just lists every single record in one continuous row - but as I said, I want to only display 3 records per row. Code:
View Replies !
|
TRACKER
